i tried nitin, still i cant previously before sending to mailing list i tried all the always still getting the below error
hive> load data local inpath './usr/local/hadoop_dir/hadoop/big_data/vender_details.txt' into table vender; FAILED: Error in semantic analysis: Line 1:23 Invalid path ''./usr/local/hadoop_dir/hadoop/big_data/vender_details.txt'': No files matching path file:/usr/local/hive-0.9.0/usr/local/hadoop_dir/hadoop/big_data/vender_details.txt hive> On Thu, Jul 12, 2012 at 1:42 PM, Nitin Pawar <nitinpawar...@gmail.com>wrote: > can you just give table name while loading data after into > > it shd be load data local inpath > './usr/local/hadoop_dir/hadoop/big_data/vender_details.txt' into > table vender > > > On Thu, Jul 12, 2012 at 1:35 PM, shaik ahamed <shaik5...@gmail.com> wrote: > >> Hi bejoy >> >> hive> Create external table vender(vender string,supplier >> string,order_date string,quantity int) row format delimited fields >> terminated by ' ' stored as textfile LOCATION >> '/usr/local/hadoop_dir/hadoop/big_data'; >> OK >> Time taken: 0.276 seconds >> I created the above table as u said in the hdfs location created >> successfully... >> >> then when im loadin the data in to the table im getting an error can u >> please correct it >> >> hive> load data local inpath >> './usr/local/hadoop_dir/hadoop/big_data/vender_details.txt' into table >> './usr/local/hive-0.9.0/vender' ; >> >> FAILED: Parse Error: line 1:94 mismatched input >> ''./usr/local/hive-0.9.0/vender'' expecting Identifier near 'table' in >> table name >> please help me in this .. >> >> thanks >> shaik. >> >> On Thu, Jul 12, 2012 at 12:39 PM, Bejoy KS <bejoy...@yahoo.com> wrote: >> >>> ** >>> Hi shaik >>> >>> Step 1 >>> Create an external table with the desired location in hdfs. Your data >>> files for the hive table will be stored in this location/directory in hdfs. >>> >>> Step 2 >>> Now use the LOAD DATA command to load data from any other location into >>> this table. On successful execution of this command the data files will be >>> moved to the table's location .( specified in previous step) >>> >>> Alternatively you can move or copy files within hdfs using hadoop fs >>> copy commands. >>> Regards >>> Bejoy KS >>> >>> Sent from handheld, please excuse typos. >>> ------------------------------ >>> *From: *shaik ahamed <shaik5...@gmail.com> >>> *Date: *Thu, 12 Jul 2012 12:30:23 +0530 >>> *To: *<user@hive.apache.org>; Bejoy Ks<bejoy...@yahoo.com> >>> *ReplyTo: *user@hive.apache.org >>> *Subject: *Re: unable to create external table plz corrrect the syntax >>> >>> Thanks for the reply guys >>> >>> I have tried dng with the load cmd >>> >>> i need the HDFS file to be place in the below hive path >>> >>> >>> */usr/local/hive-0.9.0# >>> * >>> */usr/local/hadoop_dir/hadoop/big_data/vender_details.txt --* this is >>> the hdfs path ,this path file >>> ** >>> *i.e vender_details.txt to be placed in the path >>> /usr/local/hive-0.9.0# --* in the hive path >>> >>> please reply me with the syntax i tried all the ways with external table >>> also >>> >>> >>> Thanks in advance >>> >>> Shaik >>> On Wed, Jul 11, 2012 at 9:03 PM, Bejoy Ks <bejoy...@yahoo.com> wrote: >>> >>>> 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. >>>> >>>> >>>> >>> >> > > > -- > Nitin Pawar > >
