Hi:
Check LOG4J log file (Usaually, it is in /tmp/hive/hive.log or
/tmp/${LOGNAME}/hive.log) for more details on the reason for the failure to
instantiate HiveMetaStore client.
If the MySQLConnection was stale due to long pause, try adding
'autoReconnect=true' option to the MySQL url ....
> jdbc:mysql://bigdata5.bateswhite.com:3306/hadoop?auto-Reconnect=true
* This should automatically reconnect the socket connection if it was timed-out
if the connection was not used for a while.
Thanks,
Selva-
On Oct 17, 2013, at 10:03 AM, "Garg, Rinku" <rinku.g...@fisglobal.com> wrote:
> Hi,
>
> Try this also in hive-site
>
> <property>
> <name>javax.jdo.option.ConnectionDriverName</name>
> <value> com.mysql.jdbc.Driver </value>
> <description>Driver class name for a JDBC metastore</description>
> </property>
>
>
> Thanks & Regards,
> Rinku Garg
>
> From: Clay McDonald [mailto:stuart.mcdon...@bateswhite.com]
> Sent: 17 October 2013 18:53
> To: 'user@hive.apache.org'; 'nimar...@pssd.com'
> Cc: 'Eric Mizell'; Rommel Garcia; Yi Zhang
> Subject: RE: Problem starting Hive
>
> It looks good to me…
>
> <property>
> <name>javax.jdo.option.ConnectionURL</name>
> <value>jdbc:mysql://bigdata5.bateswhite.com:3306/hadoop</value>
> <description>JDBC connect string for a JDBC metastore</description>
> </property>
>
> <property>
> <name>javax.jdo.option.ConnectionDriverName</name>
> <value>sqladmin</value>
> <description>Driver class name for a JDBC metastore</description>
> </property>
>
> <property>
> <name>javax.jdo.option.ConnectionPassword</name>
> <value>password</value>
> <description>Enter your MySQL credentials. </description>
> </property>
>
> <property>
> <name>hive.metastore.uris</name>
> <value>thrift://bigdata5.bateswhite.com:9083</value>
> <description>URI for client to contact metastore server. To enable
> HiveServer2, leave the property value empty. </description>
> </property>
>
> </configuration>
>
>
> From: Clay McDonald [mailto:stuart.mcdon...@bateswhite.com]
> Sent: Thursday, October 17, 2013 9:17 AM
> To: 'nimar...@pssd.com'
> Cc: 'user@hive.apache.org'; 'Eric Mizell'; Rommel Garcia; Yi Zhang
> Subject: RE: Problem starting Hive
>
> Nick, let me check…
>
>
> From: Martin, Nick [mailto:]
> Sent: Thursday, October 17, 2013 9:00 AM
> To: user@hive.apache.org
> Subject: RE: Problem starting Hive
>
> Hi Clay,
>
> Quick housekeeping/config check…is the URI in /etc/hive/conf/hive-site.xml
> pointing to the right place?
>
> From: Clay McDonald [mailto:stuart.mcdon...@bateswhite.com]
> Sent: Thursday, October 17, 2013 8:54 AM
> To: 'Eric Mizell'; Rommel Garcia; Yi Zhang; 'user@hive.apache.org'
> Cc: Chris Hackett; Steve Puckett; Clay McDonald; Terry Padgett
> Subject: Problem starting Hive
>
> Good morning all, I have another issue this morning. This time with Hive.
> Hive was working before I restarted the server. My metastore is MySQL on the
> same server. See error below;
>
> [root@bigdata5 staff]# hive
> 13/10/16 12:31:18 WARN conf.Configuration: mapred.max.split.size is
> deprecated. Instead, use mapreduce.input.fileinputformat.split.maxsize
> 13/10/16 12:31:18 WARN conf.Configuration: mapred.min.split.size is
> deprecated. Instead, use mapreduce.input.fileinputformat.split.minsize
> 13/10/16 12:31:18 WARN conf.Configuration: mapred.min.split.size.per.rack is
> deprecated. Instead, use
> mapreduce.input.fileinputformat.split.minsize.per.rack
> 13/10/16 12:31:18 WARN conf.Configuration: mapred.min.split.size.per.node is
> deprecated. Instead, use
> mapreduce.input.fileinputformat.split.minsize.per.node
> 13/10/16 12:31:18 WARN conf.Configuration: mapred.reduce.tasks is deprecated.
> Instead, use mapreduce.job.reduces
> 13/10/16 12:31:18 WARN conf.Configuration:
> mapred.reduce.tasks.speculative.execution is deprecated. Instead, use
> mapreduce.reduce.speculative
>
> Logging initialized using configuration in
> jar:file:/usr/lib/hive/lib/hive-common-0.11.0.2.0.5.0-67.jar!/hive-log4j.properties
> SLF4J: Class path contains multiple SLF4J bindings.
> SLF4J: Found binding in
> [jar:file:/usr/lib/hadoop/lib/slf4j-log4j12-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
> SLF4J: Found binding in
> [jar:file:/usr/lib/hive/lib/slf4j-log4j12-1.6.4.jar!/org/slf4j/impl/StaticLoggerBinder.class]
> SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an
> explanation.
> hive> show tables;
> FAILED: Execution Error, return code 1 from
> org.apache.hadoop.hive.ql.exec.DDLTask. java.lang.RuntimeException: Unable to
> instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient
> hive>
>
> ---------------------------------------------------------------------------------------
> snip ------------------------------------------------------------------------
>
> mysql> SELECT user, host FROM mysql.user;
> +----------+-------------------------+
> | user | host |
> +----------+-------------------------+
> | sqladmin | % |
> | root | 127.0.0.1 |
> | | Bigdata5.bateswhite.com |
> | root | Bigdata5.bateswhite.com |
> | | localhost |
> | root | localhost |
> | sqladmin | localhost |
> +----------+-------------------------+
> 7 rows in set (0.00 sec)
>
> mysql> SHOW DATABASES;
> +--------------------+
> | Database |
> +--------------------+
> | information_schema |
> | hadoop |
> | mysql |
> | test |
> +--------------------+
> 4 rows in set (0.00 sec)
>
> Clay McDonald
> Database Administrator
> Bates White, LLC
> 1300 Eye St, NW, Suite 600 East
> Washington, DC 20005
> Main: 202.408.6110
> Cell: 202.560.4101
> Direct: 202.747.5962
> Email: clay.mcdon...@bateswhite.com
> ****************************************************
> This electronic message transmission contains information from Bates White,
> LLC, which may be confidential or privileged. The information is intended to
> be for the use of the individual or entity named above. If you are not the
> intended recipient, be aware that any disclosure, copying, distribution, or
> use of the contents of this information is prohibited.
> If you have received this electronic transmission in error, please notify me
> by telephone at 202.747.5962 or by electronic mail at
> clay.mcdon...@bateswhite.com immediately.
> *****************************************************
> _____________
> The information contained in this message is proprietary and/or confidential.
> If you are not the intended recipient, please: (i) delete the message and all
> copies; (ii) do not disclose, distribute or use the message in any manner;
> and (iii) notify the sender immediately. In addition, please be aware that
> any message addressed to our domain is subject to archiving and review by
> persons other than the intended recipient. Thank you.
