hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From shaik ahamed <shaik5...@gmail.com>
Subject Re: unable to create external table plz corrrect the syntax
Date Thu, 12 Jul 2012 11:44:03 GMT
Nitin,

       I have tried with that syntax prev and i loaded the data in to the
hive table syntax is correct .



On Thu, Jul 12, 2012 at 4:21 PM, Nitin Pawar <nitinpawar432@gmail.com>wrote:

>  './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 <shaik5943@gmail.com> 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 <nitinpawar432@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 <shaik5943@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_ks@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 <shaik5943@gmail.com>
>>>>> *Date: *Thu, 12 Jul 2012 12:30:23 +0530
>>>>> *To: *<user@hive.apache.org>; Bejoy Ks<bejoy_ks@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_ks@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 <shaik5943@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
>>>
>>>
>>
>
>
> --
> Nitin Pawar
>
>

Mime
View raw message