Re: Issue while quering Hive

2013-09-16 Thread Sanjay Subramanian
Pawar mailto:nitinpawar...@gmail.com>> Reply-To: "user@hive.apache.org<mailto:user@hive.apache.org>" mailto:user@hive.apache.org>> Date: Monday, September 16, 2013 5:07 AM To: "user@hive.apache.org<mailto:user@hive.apache.org>" mailto:user@hive.apache.org>> Subject

Re: Issue while quering Hive

2013-09-16 Thread Nitin Pawar
** ** > > Thanks & Regards, > > *Rinku Garg* > > > > *From:* Nitin Pawar [mailto:nitinpawar...@gmail.com] > *Sent:* 16 September 2013 15:57 > > *To:* user@hive.apache.org > *Subject:* Re: Issue while quering Hive > > ** ** > > Does your

RE: Issue while quering Hive

2013-09-16 Thread Garg, Rinku
[mailto:nitinpawar...@gmail.com] Sent: 16 September 2013 15:57 To: user@hive.apache.org Subject: Re: Issue while quering Hive Does your .gz file contains the data in sequencefile ? or its a plain csv? I think looking at the filename its a plain csv file, so I would recommend that you create

Re: Issue while quering Hive

2013-09-16 Thread Nitin Pawar
npawar...@gmail.com] > *Sent:* 16 September 2013 14:19 > *To:* user@hive.apache.org > *Subject:* Re: Issue while quering Hive > > ** ** > > Look at the error message > > ** ** > > Caused by: java.io.IOException: > hdfs://localhost:54310/user/hive/war

RE: Issue while quering Hive

2013-09-16 Thread Garg, Rinku
Hi Nitin, Yes, I created the table with sequencefile. Thanks & Regards, Rinku Garg From: Nitin Pawar [mailto:nitinpawar...@gmail.com] Sent: 16 September 2013 14:19 To: user@hive.apache.org Subject: Re: Issue while quering Hive Look at the error message Caused by: java.io.IOException:

Re: Issue while quering Hive

2013-09-16 Thread Nitin Pawar
Look at the error message Caused by: java.io.IOException: hdfs://localhost:54310/user/ hive/warehouse/cpj_tbl/cpj.csv.gz not a SequenceFile Did you create table with sequencefile ? On Mon, Sep 16, 2013 at 1:33 PM, Garg, Rinku wrote: > Hi All, > > ** ** > > I have setup Hadoop, hive setup