Hi Shaik For the correct syntax for create table statement please refer https://cwiki.apache.org/Hive/languagemanual-ddl.html#LanguageManualDDL-CreateTable
Please try our this command to avoid the syntax error Create external table vender(vender string,supplier string,order_date string,quantity int) row format delimited fields terminated by ' ' stored as textfile LOCATION '<hdfs dir>'; Replace 'hdfs dir' with the required director path in hdfs Then try out the LOAD DATA LOCAL command, since your are loading data from lfs to hdfs if the data volume is large (100G) it'll take some time. Regards Bejoy KS ________________________________ From: shaik ahamed <shaik5...@gmail.com> To: user@hive.apache.org Sent: Wednesday, July 11, 2012 8:38 PM Subject: unable to create external table plz corrrect the syntax Thanks for the reply guys, I have tried using the below cmd usr/local/hive-0.9.0# load data local inpath ‘/usr/local/hadoop_dir/hadoop/big_data/vender_details.txt’ into table vender; in the above hive path we cant load the data using the above cmd ? In the below there is an syntax error plz correct it hive> create external table vender(vender string,supplier string,order_date string,quantity int)['./usr/local/hadoop_dir/hadoop/big_data/vender_details.txt'] [ row format delimited fields terminated by ' ' stored as textfile] ; FAILED: Parse Error: line 1:90 mismatched input '[' expecting EOF near ')' Thanks in advance Regards shaik.
