Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

`User` column read as built-in function (sysname). How to return actual values in `User`?

`User` column read as built-in function (sysname). How to return actual values in `User`?

New Contributor

Hi,

 

The `User` column in my select is being read as the built-in function (sysname).  What do I need to do to return the actual values from the column?

 

Thanks.

3 REPLIES 3

Re: `User` column read as built-in function (sysname). How to return actual values in `User`?

Community Manager

Hi @Nicklt19 ,

 

Could you please give us some background of the environment you are using? For example, are you talking about Hive/Impala, versions etc?

 

If it is Hive, you may want to read below links to see if they help:

https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Select

 

https://community.cloudera.com/t5/Support-Questions/Can-we-make-Hive-support-Quoted-Identifiers-in-C...

Li Wang, Technical Resolution Manager


Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.

Learn more about the Cloudera Community:

Terms of Service

Community Guidelines

How to use the forum

Re: `User` column read as built-in function (sysname). How to return actual values in `User`?

New Contributor
Hi,

It is Impala. I cannot say what version as I'm not at work now to check.
Highlighted

Re: `User` column read as built-in function (sysname). How to return actual values in `User`?

Community Manager

Hi @Nicklt19 ,

 

Thanks for the quick feedback. You may want to read below public documentation which talks about how Impala handles reserved keywords:

https://docs.cloudera.com/documentation/enterprise/latest/topics/impala_identifiers.html

 

Thanks and hope it helps,

Li

 

Li Wang, Technical Resolution Manager


Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.

Learn more about the Cloudera Community:

Terms of Service

Community Guidelines

How to use the forum

Don't have an account?
Coming from Hortonworks? Activate your account here