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.

Impala Parquet Partition table: Invalid File Footer ERROR

Highlighted

Impala Parquet Partition table: Invalid File Footer ERROR

Contributor
 

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.

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