Home | About | Sematext search-lucene.com search-hadoop.com
 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
-
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.
>