FAQ
Impala 0.7.1 fails to query an external table backed by files ending with a
.sql.gz extension. These are gzipped tab-separated value files and I can
successfully query them with Hive.

Output:

$ impala-shell
Connected to $HOST:21000
Unable to load history: [Errno 2] No such file or directory
Welcome to the Impala shell. Press TAB twice to see a list of available
commands.

Copyright (c) 2012 Cloudera, Inc. All rights reserved.

(Build version: Impala v0.7.1 (70cfa54) built on Tue Apr 16 22:10:43 PDT
2013)

[$HOST:21000] > select * from exampletable limit 10;
Query: select * from exampletable limit 10
ERROR: AnalysisException: Failed to load metadata for table: exampletable
CAUSED BY: TableLoadingException: Failed to load metadata for table:
exampletable
CAUSED BY: RuntimeException: Compressed text files are not supported:
hdfs://$HOST:8020/path/to/file.sql.gz
[$HOST:21000] >

Apparently there have been issues in this area before (IMPALA-14<https://issues.cloudera.org/browse/IMPALA-14>)
- is there some connection? That issue seems to imply support for gzipped
files, but apparently that is no longer the case. Regression?

Cluster is CDH4.2.0 installed using parcels from Cloudera Manager 4.5

BTW, the "Unable to load history: [Errno 2] No such file or directory"
seems to only appear on the first invocation of impala-shell. Probably
shouldn't be considered an error at all in that case, since obviously there
would be no history on the first invocation.
- Josh

Search Discussions

Discussion Posts

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 7 | next ›
Discussion Overview
groupimpala-user @
categorieshadoop
postedApr 17, '13 at 9:49p
activeJan 17, '14 at 9:45a
posts7
users7
websitecloudera.com
irc#hadoop

People

Translate

site design / logo © 2022 Grokbase