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 <[email protected]> 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
