User Defined Column name in select statement in Hivesql

Question

I need to create user defined column name like below Postgresql query into HiveSql. Could you please help me on this.

SELECT
    COUNT(user_id) as "Total Customers"
FROM 
    customer_profiles
WHERE
    profiled_date BETWEEN '2020-01-01' AND '2020-12-31'

Answer

Use backticks:

SELECT
    COUNT(user_id) as `Total Customers`
FROM 
 ...

But it is not possible to preserve case due to Hive limitation. Resulted column name will be in lower case:

total customers

See this answer: https://stackoverflow.com/a/57183048/2700344

Accepted Answer

Use backticks:SELECT    COUNT(user_id) as `Total Customers`FROM  ...But it is not possible to preserve case due to Hive limitation. Resulted column name will be in lower case:total customersSee this answer: https://stackoverflow.com/a/57183048/2700344

Advertisement

Answer