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
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
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
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
>
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
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
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
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
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
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
11 matches
Mail list logo