hadoop-mapreduce-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Asit Parija <a...@sigmoidanalytics.com>
Subject Re: parque table
Date Fri, 01 May 2015 14:32:48 GMT
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 <kjayapal17@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 <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