Thanks Rinku, Nick, Rommel, and Eric,
I think I have other issues with MySQL.. Anyway, I've got another
more important fire to put out. I'll take this up again later..
Clay McDonald
From: Garg, Rinku [mailto:rinku.g...@fisglobal.com]
Sent: Thursday, October 17, 2013 10:03 AM
To: user@hive.apache.org; 'nimar...@pssd.com'
Cc: 'Eric Mizell'; Rommel Garcia; Yi Zhang
Subject: RE: Problem starting Hive
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<mailto: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<https://urldefense.proofpoint.com/v1/url?u=http://www.slf4j.org/codes.html%23multiple_bindings&k=%2FbkpAUdJWZuiTILCq%2FFnQg%3D%3D%0A&r=zqOP248aNQyhYgwT%2FsREm5ngqRHnJdl9rnHZ1a6ArtU%3D%0A&m=VSG5xWy%2BQD3Grytk%2B5zCI7EoDshioa%2F5J2E%2BUCPctFA%3D%0A&s=c443c2cb03575fe638d0272425e9b63226e9dd0b4380262ad3b1826bb13ab0d7>
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<mailto: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<mailto: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.
