Unsupported Datatype

iraz098 — Fri, 16 Sep 2022 12:14:09 GMT

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.

Re: Unsupported Datatype

EricL — Mon, 18 Sep 2017 06:47:55 GMT

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?

question Re: Unsupported Datatype in Archives of Support Questions (Read Only)

Unsupported Datatype

Re: Unsupported Datatype