Re: Hive questions about the meta db

2008-10-02 Thread Edward Capriolo
I am doing a lot of testing with Hive, I will be sure to add this information to the wiki once I get it going. Thus far I downloaded the same version of derby that hive uses. I have verified that the connections is up and running. ij version 10.4 ij connect

Re: Hive questions about the meta db

2008-10-02 Thread Prasad Chakka
@hadoop.apache.org Subject: Re: Hive questions about the meta db I am doing a lot of testing with Hive, I will be sure to add this information to the wiki once I get it going. Thus far I downloaded the same version of derby that hive uses. I have verified that the connections is up and running. ij

Re: Hive questions about the meta db

2008-10-02 Thread Edward Capriolo
namehive.metastore.local/name valuetrue/value Why would I set this property to true? My goal is to store the meta data in an external database. It i set this to true the metabase is created in the working directory.

RE: Hive questions about the meta db

2008-10-02 Thread Ashish Thusoo
... Thanks, Ashish -Original Message- From: Edward Capriolo [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2008 1:28 PM To: core-user@hadoop.apache.org Subject: Re: Hive questions about the meta db namehive.metastore.local/name valuetrue/value Why would I set this property to true? My

Re: Hive questions about the meta db

2008-10-02 Thread Edward Capriolo
I determined the problem once I set the log4j properties to debug. derbyclient.jar derbytools.jar does not ship with hive. As a result when you try to org.apache.derby.jdbc.ClientDriver you get an invocation target exception. The solution for this was to download the derby, and place those files

RE: Hive questions about the meta db

2008-10-01 Thread Ashish Thusoo
hive instance concurrently without any problems (just spawn different instance of the CLI). Ashish -Original Message- From: Edward Capriolo [mailto:[EMAIL PROTECTED] Sent: Wed 10/1/2008 5:04 PM To: core-user@hadoop.apache.org Subject: Hive questions about the meta db I have been working

Re: Hive questions about the meta db

2008-10-01 Thread Prasad Chakka
Hi Edward, By default, the embedded version of apache derby database is used as a metadb. You can run multiple queries against same metadb by providing a jdbc connection (where the metadata is located) to a mysql/derby or any other relational database in the options