Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Problem starting Hive


Copy link to this message
-
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:[EMAIL PROTECTED]]
Sent: Thursday, October 17, 2013 8:54 AM
To: 'Eric Mizell'; Rommel Garcia; Yi Zhang; '[EMAIL PROTECTED]'
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: [EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>
****************************************************
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 [EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]> immediately.
*****************************************************
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB