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

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
Highlighted

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?

View solution in original post

1 REPLY 1
Highlighted

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?

View solution in original post

Don't have an account?
Coming from Hortonworks? Activate your account here