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:28 PM, Kanna Karanam <kanna...@microsoft.com> wrote: > > 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 > > > > CONFIDENTIALITY NOTICE > NOTICE: This message is intended for the use of the individual or entity > to which it is addressed and may contain information that is confidential, > privileged and exempt from disclosure under applicable law. If the reader > of this message is not the intended recipient, you are hereby notified that > any printing, copying, dissemination, distribution, disclosure or > forwarding of this communication is strictly prohibited. If you have > received this communication in error, please contact the sender immediately > and delete it from your system. Thank You.
