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 rinku.g...@fisglobal.comwrote: Hi All, ** ** I have setup

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: hdfs

RE: Issue while quering Hive

2013-09-16 Thread Garg, Rinku
...@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 a normal table

Re: Issue while quering Hive

2013-09-16 Thread Nitin Pawar
, *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 .gz file contains the data in sequencefile ? or its a plain csv? ** ** I think looking

Re: Issue while quering Hive

2013-09-16 Thread Sanjay Subramanian
. Is that rue?? Thanks Regards, Rinku Garg From: Nitin Pawar [mailto:nitinpawar...@gmail.commailto:nitinpawar...@gmail.com] Sent: 16 September 2013 15:57 To: user@hive.apache.orgmailto:user@hive.apache.org Subject: Re: Issue while quering Hive Does your .gz file contains the data in sequencefile