09-13-2017 12:35 AM
One column is giving an error when i try to retrieve it in qlikview from Hive table. Though its queriable in Hive itself. I tried to cast it in different way but to no avail. I am not sure what could be the issue.
SQL##f - SqlState: S1000, ErrorCode: 110, ErrorMsg: [Cloudera][ImpalaODBC] (110) Error while executing a query in Impala: [HY000] : AnalysisException: Unsupported type in 't_wfm.wfm_time_step'.
cast(`wfm_time_step` as DATE)
First i kept the data type as string it failed and later i change it to timestamp, still the same issue.
09-17-2017 11:47 PM