Reply
Explorer
Posts: 7
Registered: ‎10-04-2016
Accepted Solution

Unsupported Datatype

Hi ,
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'.

SQL SELECT

    cast(`wfm_time_step` as DATE)

FROM IMPALA.`test_fin_base`.`t_wfm`



First i kept the data type as string it failed and later i change it to timestamp, still the same issue.



Cloudera Employee
Posts: 212
Registered: ‎03-23-2015

Re: Unsupported Datatype

Impala does not support DATE data type, please refer to Cloudera doc:

https://www.cloudera.com/documentation/enterprise/latest/topics/impala_langref_unsupported.html

You mentioned you changed to timestamp, it also failed, can you please let me know how you made the change?
Announcements