Hi, When I am loading this data I am getting " " inserted into the table how to load with out " "it.
[image: Inline image 1] thanks jay Thanks Jay On Fri, May 1, 2015 at 8:21 AM, Hadoop User <[email protected]> wrote: > Here is the content of the file once it's unzip > > 106,"2003-02-03",20,2,"A","2","2","037" > 106,"2003-02-03",20,3,"A","2","2","037" > 106,"2003-02-03",8,2,"A","2","2","037" > > > > > > On May 1, 2015, at 7:32 AM, Asit Parija <[email protected]> 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 <[email protected]> > 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 <[email protected]> >> 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 <[email protected]> >>> 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 >>> >> >> >
