hadoop-mapreduce-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nitin Pawar <nitinpawar...@gmail.com>
Subject Re: parque table
Date Fri, 01 May 2015 05:02:45 GMT
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