Hi, Are you logged in using hive specific user or as root user.
/tmp/hive/hive.log file may be created once root user and it can’t be updated by any other user so it says permission denied. Thanks & Regards, Rinku Garg From: Clay McDonald [mailto:stuart.mcdon...@bateswhite.com] Sent: 17 October 2013 18:41 To: 'Eric Mizell'; user@hive.apache.org Cc: Rommel Garcia; Yi Zhang; Chris Hackett; Steve Puckett; Terry Padgett Subject: RE: Problem starting Hive Thanks Eric! My Hive log is attached. From: Eric Mizell [mailto:emiz...@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.mcdon...@bateswhite.com<mailto:stuart.mcdon...@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<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=N5YDuUCH9J3DMyaafAw8tDUw6NMLQztDvoJeWmjNlLY%3D%0A&s=080cb8415402a8b24564c5a9e64501a74cb672ff1556c095aee42ed2b38a5e2f> 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<https://urldefense.proofpoint.com/v1/url?u=http://Bigdata5.bateswhite.com&k=%2FbkpAUdJWZuiTILCq%2FFnQg%3D%3D%0A&r=zqOP248aNQyhYgwT%2FsREm5ngqRHnJdl9rnHZ1a6ArtU%3D%0A&m=N5YDuUCH9J3DMyaafAw8tDUw6NMLQztDvoJeWmjNlLY%3D%0A&s=ff04527098c060c9576d46a4216c57544804ed9bc41f47bedf18569c16be11ea> | | root | Bigdata5.bateswhite.com<https://urldefense.proofpoint.com/v1/url?u=http://Bigdata5.bateswhite.com&k=%2FbkpAUdJWZuiTILCq%2FFnQg%3D%3D%0A&r=zqOP248aNQyhYgwT%2FsREm5ngqRHnJdl9rnHZ1a6ArtU%3D%0A&m=N5YDuUCH9J3DMyaafAw8tDUw6NMLQztDvoJeWmjNlLY%3D%0A&s=ff04527098c060c9576d46a4216c57544804ed9bc41f47bedf18569c16be11ea> | | | 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. ***************************************************** 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. _____________ 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.
