Member since
08-07-2014
4
Posts
0
Kudos Received
0
Solutions
08-07-2014
08:43 AM
I have pipe-delimited text files in HDFS (lines delimited by new line), and a parquet table: CREATE EXTERNAL TABLE IF NOT EXISTS table_parquet( TRADE_DATE TIMESTAMP, [removed for brevity] FILLER STRING ) PARTITIONED BY(REGION STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n' STORED AS PARQUET LOCATION 'hdfs://path/to/location/'; ALTER TABLE table_parquet ADD PARTITION(REGION ='euro') LOCATION 'hdfs://path/to/location/euro'; However, when I try to query the table, I get Backend 0:File hdfs://path/to/file.txt is invalid. Invalid file footer: | I have tried inserting spaces between the last pipe and the newline, and I've tried removing the last pipe, but no luck. Any ideas what I'm doing wrong? Edit: This is Impala 1.4.0
... View more
Labels:
- Labels:
-
Apache Impala
-
HDFS