Please mention partition as well, while loading data into a partitioned table.
On Fri, May 1, 2015 at 8:22 PM, Sean Busbey <bus...@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 (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 >