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
MapReduce >> mail # user >> "Hive Metastore DB Issue ( Cloudera CDH4.1.2 MRv1 with hive-0.9.0-cdh4.1.2)"


Copy link to this message
-
"Hive Metastore DB Issue ( Cloudera CDH4.1.2 MRv1 with hive-0.9.0-cdh4.1.2)"
Hi All,
  I could not see the hive meta  store DB under Mysql  database Under mysql
user hadoop.

Example:

$>  mysql –u root -p
$> Add hadoop user (CREATE USER ‘hadoop'@'localhost' IDENTIFIED BY ‘hadoop
';)
$>GRANT ALL ON *.* TO ‘hadoop'@‘% IDENTIFIED BY ‘hadoop’
$> Example (GRANT ALL PRIVILEGES ON *.* TO 'hadoop'@'localhost' IDENTIFIED
BY 'hadoop' WITH GRANT OPTION;)

Bellow  configuration i am follwing
------------------------------------------------

<property>
    <name>javax.jdo.option.ConnectionURL</name>

<value>jdbc:mysql://localhost:3306/hadoop?createDatabaseIfNotExist=true</value>
</property>
<property>
    <name>javax.jdo.option.ConnectionDriverName</name>
    <value>com.mysql.jdbc.Driver</value>
</property>
<property>
  <name>javax.jdo.option.ConnectionUserName</name>
  <value>hadoop</value>
</property>
<property>
   <name>javax.jdo.option.ConnectionPassword</name>
   <value>hadoop</value>

</property>
Note: Previously i was using cdh3 it was perfectly creating under mysql
metastore DB but when i changed cdh3 to cdh4.1.2 with hive as above subject
line , It is not creating.
Any suggestiong..........................

Regrads,
samir.
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