Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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

 
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB