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 Plain View
MapReduce >> mail # user >> RE: "Hive Metastore DB Issue ( Cloudera CDH4.1.2 MRv1 with


+
Viral Bajaria 2013-02-07, 11:30
+
Konstantin Boudnik 2013-02-07, 23:09
+
samir das mohapatra 2013-02-07, 10:47
Copy link to this message
-
Re: "Hive Metastore DB Issue ( Cloudera CDH4.1.2 MRv1 with hive-0.9.0-cdh4.1.2)"
Any Suggestion...................
On Thu, Feb 7, 2013 at 4:17 PM, samir das mohapatra <[EMAIL PROTECTED]
> wrote:

> 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.
>
+
samir das mohapatra 2013-02-08, 06:20
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