Inserting Data in Hive tables.

2010-09-16 Thread Adarsh Sharma
Hi all, I am new to Hive. I followed the Hive wiki tutorial but not able to insert data individually in Hive-0.5 version. As we did in Sql by insert into table values(a,11); etc Hive loads data by files. Is there any command to insert data in it. Thanks in Advance

Re: Inserting Data in Hive tables.

2010-09-16 Thread Guru Prasad
Hi Adarsh, As far as I know there nothing like adding values or updating tables in hive. I am also not too old to hive so you can wait for some ans from more experienced people out here. Regards ~guru On 09/16/2010 12:12 PM, Adarsh Sharma wrote: Hi all, I am new to Hive. I followed the

Re: Inserting Data in Hive tables.

2010-09-16 Thread Adarsh Sharma
Anyway Thanks. I will find it. Guru Prasad wrote: Hi Adarsh, As far as I know there nothing like adding values or updating tables in hive. I am also not too old to hive so you can wait for some ans from more experienced people out here. Regards ~guru On 09/16/2010 12:12 PM, Adarsh

Re: Hive - ERROR XBM0H: Directory /root/metastore_db cannot be created

2010-09-16 Thread vaibhav negi
Hi, please help . I am stuck with it. When i run show tables query i could not see any tables. Vaibhav Negi On Thu, Sep 2, 2010 at 1:06 PM, vaibhav negi sssena...@gmail.comwrote: Hi , I am running hive on hadoop 0.20.2 with 2 node cluster. I had created hadoop user and loaded data

Re: Inserting Data in Hive tables.

2010-09-16 Thread Edward Capriolo
On Thu, Sep 16, 2010 at 3:52 AM, Adarsh Sharma adarsh.sha...@orkash.com wrote: Anyway Thanks. I will find it. Guru Prasad wrote: Hi Adarsh, As far as I know there nothing like adding values or updating tables in hive. I am also not too old to hive so you can wait for some ans from

Re: Hive - ERROR XBM0H: Directory /root/metastore_db cannot be created

2010-09-16 Thread Edward Capriolo
On Thu, Sep 16, 2010 at 8:42 AM, vaibhav negi sssena...@gmail.com wrote: Hi, please help . I am stuck with it. When i run show tables query i could not see any tables. Vaibhav Negi On Thu, Sep 2, 2010 at 1:06 PM, vaibhav negi sssena...@gmail.com wrote: Hi , I am running hive

Access to JobClient/Hadoop Counters

2010-09-16 Thread gaurav jain
Hi, Do I have access to hadoop counters or JobClient if I am using a hive query either thru HIVE CLI or HIVE Java API? -- Looked into HIVE code base and looks like there are no public interfaces. ExecDriver* classes maintains and use that information locally.

Re: Hive can't run query with a TextInputFormat exception

2010-09-16 Thread Carl Steinbach
Hi Peter, I was unable to reproduce your problem using a fresh install of hadoop-0.20.1+169.68 from CDH2 and hive-0.5.0+20 from CDH3. I also verified that the hadoop-0.20.1+169.68-core.jar contains org.apache.hadoop.mapred.TextInputFormat. I agree that this is most likely a classpath issue. My

Re: Hive can't run query with a TextInputFormat exception

2010-09-16 Thread Carl Steinbach
Hi Ed, I'm happy to answer questions on this list related to Hive and Cloudera packaging issues. I'd also like to point out that it's impossible to differentiate between a cloudera packaging issue and an Apache Hive issue before you know the cause of the problem. Thanks. Carl On Wed, Sep 15,

Re: Is it possible to have counters in a transform map or reduce script?

2010-09-16 Thread Carl Steinbach
Hi Leo, Hive does not currently support this feature, but it would not be that hard to implement, especially since we can probably borrow code from the streaming implementation. I filed a ticket for it here: https://issues.apache.org/jira/browse/HIVE-1649 Thanks. Carl On Wed, Sep 15, 2010 at