I have bunch of csv files listed inside zipped file in hdfs. Is there any way to create a hive table above those with right data?
Note: data is quoted with " in csv file.
Asked
Active
Viewed 908 times
0
-
ZIP format is not a native Hadoop format. You'd be better off uncompressing or changing to BZIP2 – OneCricketeer Jul 15 '18 at 20:33
-
As stated by @cricket_007 the **.zip** format is currently not supported by the Hadoop framework and it's a work [in-progress](https://issues.apache.org/jira/browse/MAPREDUCE-210). So a work around would be to either have the files _uncompressed_ or have them converted to Hadoop supported compressed formats .bz2 .gz or .deflate... – DataWrangler Jul 17 '18 at 05:56