hadoop-hdfs-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kumar Jayapal <kjayapa...@gmail.com>
Subject Re: parque table
Date Fri, 01 May 2015 05:25:56 GMT
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 <nitinpawar432@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 <kjayapal17@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
>

Mime
View raw message