Column named "user"

I have a view with a column named “user” and I have not figured out a way to use this column in queries.
Whether I do:
select user from my_view
select “user” from my_view

the result is the same, which is that every row has the username I’m using to access dremio, rather than the value of that column in my data. This doesn’t seem to happen for other reserved words, only “user”. I see similar results when I try to use this column in a where or group by clause.

Is there any workaround for this (other than changing the column name)?

did you try:
SELECT my_object.user
FROM my_object

What is the view definition?

@hmarchman-jones, thanks. qualifying the column name did the trick.

1 Like