Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> unable to create external table plz corrrect the syntax


Copy link to this message
-
Re: unable to create external table plz corrrect the syntax
'./usr/local/hadoop_dir/hadoop/big_data/vender_details.txt'  ... why there
is a "." at the beginning ?

On Thu, Jul 12, 2012 at 2:53 PM, shaik ahamed <[EMAIL PROTECTED]> wrote:

> 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 <[EMAIL PROTECTED]>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 <[EMAIL PROTECTED]>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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]>
>>>> *Date: *Thu, 12 Jul 2012 12:30:23 +0530
>>>> *To: *<[EMAIL PROTECTED]>; Bejoy Ks<[EMAIL PROTECTED]>
>>>> *ReplyTo: *[EMAIL PROTECTED]
>>>> *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 <[EMAIL PROTECTED]> 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>';
>>>>>
>

Nitin Pawar
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB