This could be a problem. Hive uses newline as the record separator. A ZIP file will certainly newline characters. So I doubt this is possible.
BUT, I would like to hear from anyone who has solved the "newline is always a record separator" problem, because we ran into it for another type of compressed file. Chuck ________________________________ From: Manish.Bhoge [manish.bh...@target.com] Sent: Wednesday, September 26, 2012 3:17 AM To: user@hive.apache.org Subject: zip file or tar file cosumption Hivers, I want to understand that would it be possible to utilize zip/tar files directly into Hive. All the files has similar schema (structure). Say 50 *.txt files are zipped into a single zip file can we load data directly from this zip file OR should we need to unzip first? Thanks & Regards Manish Bhoge | Technical Architect • Target DW/BI| • +919379850010 (M) Ext: 5691 VOIP: 22165 | • “Excellence is not a skill, It is an attitude.” MySite<http://mysites.target.com/personal/z063783>
