hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bhagwan S. Soni" <bhgwnsson...@gmail.com>
Subject Re: parque table
Date Fri, 01 May 2015 15:19:16 GMT
Please mention partition as well, while loading data into a partitioned
table.

On Fri, May 1, 2015 at 8:22 PM, Sean Busbey <busbey@cloudera.com> wrote:

> -user@hadoop to bcc
>
> Kumar,
>
> I'm copying your question over to the Apache Hive user list (
> user@hive.apache.org). Please keep your questions about using Hive there.
> The Hadoop user list (user@hadoop.apache.org) is just for that project.
>
> On Fri, May 1, 2015 at 9:32 AM, Asit Parija <asit@sigmoidanalytics.com>
> wrote:
>
>> 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
>>>>
>>>
>>>
>>
>
>
> --
> Sean
>

Mime
View raw message