Impala was not able to query hive table with column type date

pgb — Fri, 16 Sep 2022 10:14:14 GMT

Hi,

I have successfully created a table in Hive by ingesting a CSV file, but I cannot query this table with Impala which does not recognize the column with the data type "date":

Create table elections (
  id string,
  name string,
  dt date)
    row format delimited 
    fields terminated by ','
    stored as textfile;

LOAD DATA LOCAL INPATH "/home/cloudera/datasets/vox/elections.csv" overwrite INTO TABLE elections ;

I was able to successfully query that table in hive. Below the result of describe within each query editor:

HIVE

IMPALA

Would you be able to explain that difference ? I'm using Hive version 1.1.0 and Impala version 2.3.0

Thanks

Re: Impala was not able to query hive table with column type date

mathieu.d — Wed, 27 Apr 2016 14:53:29 GMT

Not sure this is the latest documentation for Impala but the Hive "Date" type is not supported in Impala.

Use TIMESTAMP instead for example.

Check "Impala supported data types" in google. (Sorry I can't paste the url I don't know why).

question Impala was not able to query hive table with column type date in Archives of Support Questions (Read Only)

Impala was not able to query hive table with column type date

Re: Impala was not able to query hive table with column type date