Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Unsupported Datatype

Solved Go to solution
Highlighted

Unsupported Datatype

Explorer

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.



1 ACCEPTED SOLUTION

Accepted Solutions

Re: Unsupported Datatype

Guru
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?
1 REPLY 1

Re: Unsupported Datatype

Guru
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?
Don't have an account?
Coming from Hortonworks? Activate your account here