Re: FAILED: Error in metadata

2012-09-09 Thread Ravindra
I am new to Hive, Still 2 cents - 1. Do you have metastore_db already created, I don't see this name in your hive-site (you have "try"). 2. Hope you have your database client driver jar copied in the hive classpath. -- Ravi. *''We do not inherit the earth from our ancestors, we borrow it from our

Re: Where does hive store join query results

2012-09-09 Thread Bejoy KS
Hi Rajesh If you like to store the results of some hive query in a directory you need to use query like INSERT OVERWRITE [LOCAL] DIRECTORY 'fs location' ' 'https://cwiki.apache.org/Hive/languagemanual-dml.html#LanguageManualDML-Writingdataintofilesystemfromqueries If a directory is not specifi

Re: FAILED: Error in metadata

2012-09-09 Thread Hongjie Guo
check your mysql first, if you can see some tables like "TBLS","COLUMNS", the mysql should work fine. otherwise you should check your configuration about the hive-site.xml 2012/9/10 yogesh dhari > Helli Bejoy, > > I have restarted the hive and all cluster again but still the same issue. > > Pl

Re: Where does hive store join query results

2012-09-09 Thread Hongjie Guo
maybe there is empty ouput.if you can see "ok" in your consol,hive has already output the result. 2012/9/10 rajesh.ba...@orkash.com > Hi Everyone, > I am running a join query on two tables in hive. When I run the join > query, hive runs a map-reduce job.I can't seem to find the results of the >

Where does hive store join query results

2012-09-09 Thread rajesh.ba...@orkash.com
Hi Everyone, I am running a join query on two tables in hive. When I run the join query, hive runs a map-reduce job.I can't seem to find the results of the join query. Can someone tell me where hive stores the results of the join query. Thanks Rajesh Kumar

RE: FAILED: Error in metadata

2012-09-09 Thread yogesh dhari
Helli Bejoy, I have restarted the hive and all cluster again but still the same issue. Please help me out Thanks & regards Yogesh Kumar Date: Sun, 9 Sep 2012 02:21:47 -0700 From: bejoy...@yahoo.com Subject: Re: FAILED: Error in metadata To: user@hive.apache.org Hi Yogesh It looks like hive i

Unsubscribe

2012-09-09 Thread Pokarna, Sameer

Re: hive table missing

2012-09-09 Thread Bejoy KS
Hi Sam Hive table details are on he metastore db and would be gone only if that entry is deleted. That is on a drop command normally. Hive table will be there even if there is no data corresponding to the storage location. Infact it'd be there even if the store location doesn't exists. Regards

hive table missing

2012-09-09 Thread Sam Darwin
Hi, We are seeing a hive table is gone unexpectedly. I suspect that this must have been caused by someone somewhere issuing a "drop table" command.But it's unclear. My question is : are there other known ways for hive to lose a table besides "drop table". For example, let's say that t

Re: FAILED: Error in metadata

2012-09-09 Thread Bejoy KS
Hi Yogesh It looks like hive is still on the derby db . Can you restart your hive instances after updating the hive-site.xml. Also please make sure that you are modifying the right copy of the file.   Regards, Bejoy KS From: yogesh dhari To: hive request Se

FAILED: Error in metadata

2012-09-09 Thread yogesh dhari
Hi all, my hive-site.xml is javax.jdo.option.ConnectionURL jdbc:mysql://127.0.0.1:3306/try?createDatabaseIfNotExist=true javax.jdo.option.ConnectionDriverName com.mysql.jdbc.Driver javax.jdo.option.ConnectionUserName