Hello Nitin, Dint understand what you mean. Are you telling me to set COMPRESSION_CODEC=gzip ?
thanks Jay On Thu, Apr 30, 2015 at 10:02 PM, Nitin Pawar <nitinpawar...@gmail.com> wrote: > You loaded a gz file in a table stored as text file > either define compression format or uncompress the file and load it > > On Fri, May 1, 2015 at 9:17 AM, Kumar Jayapal <kjayapa...@gmail.com> > wrote: > >> Created table CREATE TABLE raw (line STRING) PARTITIONED BY >> (FISCAL_YEAR smallint, FISCAL_PERIOD smallint) >> STORED AS TEXTFILE; >> >> and loaded it with data. >> >> LOAD DATA LOCAL INPATH '/tmp/weblogs/20090603-access.log.gz' INTO TABLE >> raw; >> >> I have to load it to parque table >> >> when I say select * from raw it shows all null values. >> >> >> NULLNULLNULLNULLNULLNULLNULLNULL >> NULLNULLNULLNULLNULLNULLNULLNULL >> NULLNULLNULLNULLNULLNULLNULLNULL >> NULLNULLNULLNULLNULLNULLNULLNULL >> Why is not show showing the actual data in file. will it show once I load >> it to parque table? >> >> Please let me know if I am doing anything wrong. >> >> >> Thanks >> jay >> >> > > > -- > Nitin Pawar >