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.