1

I'd like to know how to add a pseudo column in select statement using Dremio?

on MS SQL, I am able to simply use below statement to add a blank column on my result.

SELECT ' ' as [Pseudo_Colum] 
FROM  Table

How am I doing it on Dremio?

user2251216
  • 13
  • 1
  • 5
  • 1
    What is the error you get? I don't know Dremio, but standard SQL uses double quotes for identifiers, not those dreaded square brackets. Did you try `select ' ' as "Pseudo_Column" from ...` –  Mar 31 '21 at 13:47
  • ah...you were right, I just changed brackets to double quotes and that works thank you so much :) – user2251216 Mar 31 '21 at 13:55

0 Answers0