Home | About | Sematext search-lucene.com search-hadoop.com
 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)"
samir das mohapatra 2013-02-07, 15:20
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