hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Clay McDonald <stuart.mcdon...@bateswhite.com>
Subject RE: Problem starting Hive
Date Thu, 17 Oct 2013 13:29:28 GMT
Yep..


[root@bigdata5 ~]# find / -type f -name mysql-connector-java*
/usr/lib/hive/lib/mysql-connector-java-5.1.24-bin.jar
/usr/share/java/mysql-connector-java-5.1.17.jar



From: Rommel Garcia [mailto:rgarcia@hortonworks.com]
Sent: Thursday, October 17, 2013 9:24 AM
To: Clay McDonald
Cc: Eric Mizell; user@hive.apache.org; Yi Zhang; Chris Hackett; Steve Puckett; Terry Padgett
Subject: Re: Problem starting Hive

Do you have the MySQL connector jar on you hive lib?
Rommel Garcia
Big Data Solutions Engineer - Southeast
Hortonworks, Inc.
Email: rgarcia@hortonworks.com<mailto:rgarcia@hortonworks.com>
Mobile: 404.502.9672<tel:404.502.9672>
www.hortonworks.com<http://www.hortonworks.com/>

On Oct 17, 2013, at 9:11 AM, Clay McDonald <stuart.mcdonald@bateswhite.com<mailto:stuart.mcdonald@bateswhite.com>>
wrote:
Thanks Eric! My Hive log is attached.


From: Eric Mizell [mailto:emizell@hortonworks.com]
Sent: Thursday, October 17, 2013 8:59 AM
To: Clay McDonald
Cc: Rommel Garcia; Yi Zhang; user@hive.apache.org<mailto:user@hive.apache.org>; Chris
Hackett; Steve Puckett; Clay McDonald; Terry Padgett
Subject: Re: Problem starting Hive

Clay,

Can you send the Hive log file?
--
Eric

-
Sent from iPhone



On Oct 17, 2013, at 8:54 AM, Clay McDonald <stuart.mcdonald@bateswhite.com<mailto:stuart.mcdonald@bateswhite.com>>
wrote:
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<http://Bigdata5.bateswhite.com> |
| root     | Bigdata5.bateswhite.com<http://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.mcdonald@bateswhite.com<mailto:clay.mcdonald@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.mcdonald@bateswhite.com<mailto:clay.mcdonald@bateswhite.com>
immediately.
*****************************************************

CONFIDENTIALITY NOTICE
NOTICE: This message is intended for the use of the individual or entity to which it is addressed
and may contain information that is confidential, privileged and exempt from disclosure under
applicable law. If the reader of this message is not the intended recipient, you are hereby
notified that any printing, copying, dissemination, distribution, disclosure or forwarding
of this communication is strictly prohibited. If you have received this communication in error,
please contact the sender immediately and delete it from your system. Thank You.
<hive.log>

CONFIDENTIALITY NOTICE
NOTICE: This message is intended for the use of the individual or entity to which it is addressed
and may contain information that is confidential, privileged and exempt from disclosure under
applicable law. If the reader of this message is not the intended recipient, you are hereby
notified that any printing, copying, dissemination, distribution, disclosure or forwarding
of this communication is strictly prohibited. If you have received this communication in error,
please contact the sender immediately and delete it from your system. Thank You.
Mime
View raw message