Re: unable to create external table plz corrrect the syntax

2012-07-12 Thread shaik ahamed
> On Thu, Jul 12, 2012 at 12:39 PM, Bejoy KS wrote: >>>> >>>>> ** >>>>> Hi shaik >>>>> >>>>> Step 1 >>>>> Create an external table with the desired location in hdfs. Your data >>>>> files for the h

Re: unable to create external table plz corrrect the syntax

2012-07-12 Thread Nitin Pawar
with external >>>> table also >>>> >>>> >>>> Thanks in advance >>>> >>>> Shaik >>>> On Wed, Jul 11, 2012 at 9:03 PM, Bejoy Ks wrote: >>>> >>>>> Hi Shaik >>>>> >>>

Re: unable to create external table plz corrrect the syntax

2012-07-12 Thread shaik ahamed
;>> 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

Re: unable to create external table plz corrrect the syntax

2012-07-12 Thread Nitin Pawar
doop fs copy >> commands. >> Regards >> Bejoy KS >> >> Sent from handheld, please excuse typos. >> -- >> *From: *shaik ahamed >> *Date: *Thu, 12 Jul 2012 12:30:23 +0530 >> *To: *; Bejoy Ks >> *ReplyTo: *us

Re: unable to create external table plz corrrect the syntax

2012-07-12 Thread shaik ahamed
--- > *From: *shaik ahamed > *Date: *Thu, 12 Jul 2012 12:30:23 +0530 > *To: *; Bejoy Ks > *ReplyTo: *user@hive.apache.org > *Subject: *Re: unable to create external table plz corrrect the syntax > > Thanks for the reply guys > >I ha

Re: unable to create external table plz corrrect the syntax

2012-07-12 Thread Bejoy KS
2 Jul 2012 12:30:23 To: ; Bejoy Ks Reply-To: 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# *

Re: unable to create external table plz corrrect the syntax

2012-07-12 Thread shaik ahamed
lfs to hdfs if the data volume is large (100G) it'll take some time. > > > Regards > > Bejoy KS > > > > > ---------- > *From:* shaik ahamed > *To:* user@hive.apache.org > *Sent:* Wednesday, July 11, 2012 8:38 PM > *Subject:* unable to create externa

Re: unable to create external table plz corrrect the syntax

2012-07-11 Thread Bejoy Ks
ge (100G) it'll take some time. Regards Bejoy KS From: shaik ahamed 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

unable to create external table plz corrrect the syntax

2012-07-11 Thread shaik ahamed
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 c