Reply
Expert Contributor
Posts: 88
Registered: ‎01-31-2015

Impala Parquet Partition table: Invalid File Footer ERROR

 

Hi 

Impala version :2.2.0+cdh5.4.5+0 

 

I am also facing the same issue of invalid file footer, the table is created as follows :

 

2 tables created (TEXT AND PARQUET)

 

TEXT:

 

CREATE EXTERNAL TABLE ABC_TEXT (

NAME STRING,

ID INT,

PHONE INT)

PARTITION BY (Customer_id INT)

ROW FORMAT DELIMITED

FIELDS TERMINATED BY ';'

STORED AS TEXTFILE

LOCATION '/USER/ABC_TEXT ;

 

PARQUET:

 

CREATE EXTERNAL TABLE ABC_PARQUET (

NAME STRING,

ID INT,

PHONE INT )

PARTITION BY (Customer_id INT)

STORED AS PARQUET

LOCATION '/USER/ABC_PARQUET' ;

 

Then run the insert script, which inserts data perfectly but when queried on parquet table getting following error 

 

 

Error:

Caused by: java.sql.SQLException: [Simba][ImpalaJDBCDriver](500312) Error in fetching data rows: 

Invalid file footer

 

Please let me know what I am doing wrong.