Re: Mysql metastore configuration error.

2011-11-22 Thread Sriram Krishnan
r@hive.apache.org>> Cc: Sriram Krishnan mailto:skrish...@netflix.com>> Subject: RE: Mysql metastore configuration error. I checked the TBLS table. It contains an entry for abcd. About Hadoop only jobs. Yes I ran examples provided with Hadoop which don’t use hive at all. They ran fin

Re: FW: Mysql metastore configuration error.

2011-11-22 Thread Jasper Knulst
. select * from abcd, show tables, describe > abcd, then it works fine. > > ** ** > > What am I doing wrong. > > ** ** > > Thanks, > > Aditya > > *From:* Aditya Singh30 > *Sent:* Tuesday, November 22, 2011 2:03 PM > *To:* 'user@hive.

FW: Mysql metastore configuration error.

2011-11-22 Thread Aditya Singh30
elect * from abcd, show tables, describe abcd, then it works fine. What am I doing wrong. Thanks, Aditya From: Aditya Singh30 Sent: Tuesday, November 22, 2011 2:03 PM To: 'user@hive.apache.org' Cc: 'Sriram Krishnan' Subject: RE: Mysql metastore configuration error. I checked the

Re: Mysql metastore configuration error.

2011-11-22 Thread Alexander C.H. Lorenz
x27;abcd' > > ** ** > > I checked the permissions for hiveuser on metastore DB, re-run the command > “GRANT ALL ON metastore.* TO 'hiveuser'@'%';”, but still when I run the > java program it gives the same error. > > Does this points to anything. > > *

RE: Mysql metastore configuration error.

2011-11-22 Thread Aditya Singh30
command "GRANT ALL ON metastore.* TO 'hiveuser'@'%';", but still when I run the java program it gives the same error. Does this points to anything. Regards, Aditya From: Sriram Krishnan [mailto:skrish...@netflix.com] Sent: Tuesday, November 22, 2011 1:19 PM To: user@hi

Re: Mysql metastore configuration error.

2011-11-21 Thread Sriram Krishnan
aditya_sing...@infosys.com>> Reply-To: mailto:user@hive.apache.org>> Date: Tue, 22 Nov 2011 12:56:16 +0530 To: "user@hive.apache.org<mailto:user@hive.apache.org>" mailto:user@hive.apache.org>> Subject: RE: Mysql metastore configuration error. Sorry It was a typo.

RE: Mysql metastore configuration error.

2011-11-21 Thread Aditya Singh30
Sorry It was a typo.. I used "Load data local inpath 'path/to/abcd.txt' into table abcd;" only Thanks for pointing it out Stephen. Regards, Aditya From: Stephen Boesch [mailto:java...@gmail.com] Sent: Tuesday, November 22, 2011 12:32 PM To: user@hive.apache.org Subject:

Re: Mysql metastore configuration error.

2011-11-21 Thread Stephen Boesch
Was that code above *verbatim? * because there is a typo Hive> Load *s*ata local inpath ‘path/to/abcd.txt’ into table abcd; (load sata not load data) 2011/11/21 Aditya Singh30 > Hi Everybody, > > I am using Apache’s Hadoop-0.20.2 and > Apache’s Hive-0.7.0.

Mysql metastore configuration error.

2011-11-21 Thread Aditya Singh30
Hi Everybody, I am using Apache's Hadoop-0.20.2 and Apache's Hive-0.7.0. I have a 2 node cluster. One Redhat Linux 6.0(Hadoop Server) and other Windows 7 using Cygwin. The Hadoop cluster is working fine. I have checked by executing various examples provided with H