Home | About | Sematext search-lucene.com search-hadoop.com
 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
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>';
>>>
>>>
>>>
>>> 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 <[EMAIL PROTECTED]>
>>> *To:* [EMAIL PROTECTED]
>>> *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
Nitin Pawar