Hive query select as alias and format date

select as alias In Hive, in order to use select COL as “Alias” syntax, we cannot use single or double quote. We have to use the special “backtick” symbol -> `.  Example: SELECT user_name AS `system user name`, ….. date format To format date, we need to convert the date to bigint with unix_timestamp function and then…