Reply
New Contributor
Posts: 2
Registered: ‎02-01-2019

How to get Column names in uppercase using impala

When we have column names in query, always impala returns column names in lowercase. I’d greatfull if you could let us know how to get column names in uppercase.

Thanks in advance.
Cloudera Employee
Posts: 14
Registered: ‎08-16-2018

Re: How to get Column names in uppercase using impala

In Impala, the identifiers are always case-insensitive. i.e., tables named t1 and T1 always refer to the same table, regardless of quote characters. Internally, Impala always folds all specified table and column names to lowercase. This is why the column headers in query output are always displayed in lowercase.

 

Aliases follow the same rules as identifiers when it comes to case insensitivity. 

 

More information on Cloudera's Impala documentation: 

 

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

New Contributor
Posts: 2
Registered: ‎02-01-2019

Re: How to get Column names in uppercase using impala

Is there any way to get the aliases in specified format? For example, SELECT c1 AS “Employee ID” from EMPLOYEE;
Result of the above query should return as below:
Employee ID
——————
1
2
Instead of below
employee id
——————
1
2

Thanks in advance
Cloudera Employee
Posts: 14
Registered: ‎08-16-2018

Re: How to get Column names in uppercase using impala

[ Edited ]

I do not see any such option available yet.