- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
How to get Column names in uppercase using impala
- Labels:
-
Apache Impala
Created on 02-01-2019 03:49 AM - edited 09-16-2022 07:06 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks in advance.
Created 02-01-2019 10:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Created 02-01-2019 07:08 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Result of the above query should return as below:
Employee ID
——————
1
2
Instead of below
employee id
——————
1
2
Thanks in advance
Created on 02-11-2019 02:25 AM - edited 02-11-2019 02:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I do not see any such option available yet.
