Re: Compressed Data Column in Hive Table

2014-04-14 Thread Peyman Mohajerian
you can also build a UDF to decompress. On Mon, Apr 14, 2014 at 5:31 PM, Abdelrahman Shettia < ashet...@hortonworks.com> wrote: > Hi Kanna, > > It may not be the best option, but you can select the column and insert it > into a staging temp table. > > > Thanks, > Rahman > > On Apr 8, 2014, at 6:

Re: Compressed Data Column in Hive Table

2014-04-14 Thread Abdelrahman Shettia
Hi Kanna, It may not be the best option, but you can select the column and insert it into a staging temp table. Thanks, Rahman On Apr 8, 2014, at 6:28 PM, Kanna Karanam wrote: > Hi – One of the columns in my hive table contains compressed data (Json > document in Gzip format). Is there an

Compressed Data Column in Hive Table

2014-04-08 Thread Kanna Karanam
Hi - One of the columns in my hive table contains compressed data (Json document in Gzip format). Is there any recommended way to decompress it and explode the json doc? Thanks, Kanna