Query Working fine in ssms but failed in dremio

I have executed below Query in ssms:

select
ProjectId,ProjectName,issues.id as IssueID
,issues.kee as IssueKEE
,issues.rule_id as IssueRuleID
,issues.severity as IssueSeverity

  ,issues.message as IssueMessage
  ,issues.line as IssueLines
  ,issues.status as IssueStatus
  
  ,issues.author_login as IssueAuthorLogin
  ,issues.effort as IssueEffort
  ,issues.created_at as IssueCreatedAt
  ,issues.updated_at as IssueUpdatedAt
  ,issues.issue_creation_date as IssueCreationDate
  ,issues.issue_update_date as IssueUpdateDate
  ,issues.issue_close_date as IssueCloseDate
  ,issues.tags as IssueTags
  ,issues.component_uuid as IssueComponentUUID
  ,issues.project_uuid as IssueProjectUUID
  ,issues.locations as IssueLocation
  ,
   (SELECT
CASE
  WHEN issues.issue_type = 1 THEN 'Code Smell'
  WHEN issues.issue_type = 2 THEN 'Bug'
  WHEN issues.issue_type = 3 THEN 'Vulnerability'
END AS IssueType)

AS IssueType
from issues
INNER JOIN (SELECT
project_uuid AS ProjectId,
projects.name AS ProjectName
FROM projects
WHERE project_uuid = uuid) AS SonarProjects
ON issues.project_uuid = SonarProjects.ProjectId

It executed suceefully in ssms

but failed in dremio

ssms sucess

Can you attach a query profile?