hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Selvamohan Neethiraj <selva.apa...@infotekies.com>
Subject Re: Problem starting Hive
Date Thu, 17 Oct 2013 20:40:06 GMT
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.Garg@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.mcdonald@bateswhite.com] 
> Sent: 17 October 2013 18:53
> To: 'user@hive.apache.org'; 'NiMartin@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.mcdonald@bateswhite.com] 
> Sent: Thursday, October 17, 2013 9:17 AM
> To: 'NiMartin@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.mcdonald@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.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 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.


Mime
View raw message