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.

How to access DATE Datatype Column of Hive table in impala????

How to access DATE Datatype Column of Hive table in impala????

New Contributor

Hi 

AM new to Hadoop..

Could you please help to guide me on below issues.

 

HiveTable1

--------

Col1 DATE

Col2 String

 

HiveTable2

----------

Field1 DATE

Field2 String

 

Am trying to select data from HiveTable1 and insert into HiveTable2 using impala.

 

impala Query:

Insert into HiveTable2

(

Field1

,Field2

)

SELECT Col1,Col2 from HiveTable1;

 

This Statement is failing with unsupported datatype error message.

 

Please help to achive this..