Error while compiling statement: FAILED: ParseException line 2:29 cannot recognize input near 'LOCALTIMESTAMP' 'then' 'null' in expression

Viewed 28

I am using Hadoop Hive to run my SQL queries. However, this one does not work. Any ideas how to fix it?

SELECT (case when SRC_SYS_UPD_TS in LOCALTIMESTAMP then null else SRC_SYS_UPD_TS end) as SRC_SYS_UPD_TS, FROM dl_edge_base_atds_58616_base_atdsttdp_IIDR_DATA_IN.R14CARRC

0 Answers
Related