RE: Error Creating External Table

2013-04-05 Thread Ranjitha Chandrashekar
Hi Piyush That was a problem with the path. There were other incompatible files in that directory. Thanks anyway.. :) From: Piyush Srivastava [mailto:piyush.srivast...@wizecommerce.com] Sent: 05 April 2013 15:23 To: user@hive.apache.org Subject: RE: Error Creating External Table When you

RE: Error Creating External Table

2013-04-05 Thread Piyush Srivastava
3:16 PM To: user@hive.apache.org Subject: Error Creating External Table Hi When i try creating a external table to a text file on HDFS i get the following error. Could someone please let me know where I am going wrong. hive> create external table seq4 (item STRING) row format delimited fields

Error Creating External Table

2013-04-05 Thread Ranjitha Chandrashekar
Hi When i try creating a external table to a text file on HDFS i get the following error. Could someone please let me know where I am going wrong. hive> create external table seq4 (item STRING) row format delimited fields terminated by '' STORED as TEXTFILE location 'hdfs://:54310/user/myfold