Hi Kumar , You can remove the stored as text file part and then try that out by default it should be able to read the .gz files ( if they are comma delimited csv files ) .
Thanks Asit On Fri, May 1, 2015 at 10:55 AM, Kumar Jayapal <kjayapa...@gmail.com> wrote: > 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 >> > >
