Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Drill >> mail # dev >> Setting up Hive...


Copy link to this message
-
Re: Setting up Hive...
On Tue, Mar 25, 2014 at 6:56 PM, George Chow <[EMAIL PROTECTED]> wrote:

hive.metastore.uris should point to metastore server which is different
from HiveServer1/2. Drill uses Metastore thrift interface to fetch the
table/db info. From your first email, it looks like you are embedding the
metastore within HiveServer1. You can copy the following settings from you
current hiveserver's hive-site.xml to storage-engines.json to embed
metastore in Drillbit or start the metastore as separate service using
'hive --service metastore' and point hive.metastore.uris to the address.

  "javax.jdo.option.ConnectionURL" :
"jdbc:mysql://hostname/hivedrill?createDatabaseIfNotExist=true",

  "javax.jdo.option.ConnectionDriverName" : "com.mysql.jdbc.Driver",
  "javax.jdo.option.ConnectionUserName" : "user",

  "javax.jdo.option.ConnectionPassword" : "passwd"
Thanks

Venki