Member since
08-07-2014
4
Posts
0
Kudos Received
0
Solutions
12-01-2015
11:43 AM
Hi We are also facing the same issue of invalid file footer, the table is created as follows : 2 tables created 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 ; 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.
... View more