-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 (u...@hadoop.apache.org) is just for that project. On Fri, May 1, 2015 at 9:32 AM, Asit Parija <a...@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 <kjayapa...@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 <nitinpawar...@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 <kjayapa...@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
