Best unofficial Apache Server developers community

Answers

Hive doesn't respond when I try to make a query

⇧

⇩

56 views

I have a setup on a EC2 instance that uses Whirr to spin up new hadoop instances. I have been trying to get Hive to work with this setup. Hive should be configured to use mysql as the local metastore. The issue that I am having is that every time I try to run a query like( CREATE TABLE testers (foo INT, bark STRING); ) via the hive interface it just hangs there and doesn't seem like it is doing anything.

Any help would be appreciated.

amazon-ec2 hadoop hive

asked May 18, 2011 1:19 pm CDT

jmeed

posted via StackOverflow

1 Answers

⇧

⇩

I would first get the debug output from the hive command line to see where it is hanging. Run the hive shell with this parameter, and then paste the output of your command.

hive -hiveconf hive.root.logger=DEBUG,console

answered May 19, 2011 7:01 pm CDT

Jeremy Carroll

Your answer

Similar discussion threads

PATCH/puppet 1/1] (#6499) Make puppet respond identically to -h and --help
February 25, 2011 01:23:08 PM
lib/puppet/util/command_line.rb had a special case for puppet --help to return generic help instead of the puppet apply help, but it would return puppet apply help when you gave it -h. Signed-off-by: nfagerlund <nick.fag### @gmail.com> ---…

Commented: (HIVE-1579) showJobFailDebugInfo fails job if tasktracker does not respond
January 16, 2011 02:18:28 PM
[ https://issues.apache.org/jira/browse/HIVE-1579?page=com.atlassian.jir a.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=1 2982375#action_12982375 ] Richard Williamson commented on HIVE-1579:

Created: (HIVE-1579) showJobFailDebugInfo fails job if tasktracker does not respond
August 21, 2010 02:19:22 AM
showJobFailDebugInfo fails job if tasktracker does not respond

Commented: (HIVE-1579) showJobFailDebugInfo fails job if tasktracker does not respond
January 16, 2011 10:39:31 PM
[ https://issues.apache.org/jira/browse/HIVE-1579?page=com.atlassian.jir a.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=1 2982475#action_12982475 ] Richard Williamson commented on HIVE-1579:

Re: Tomcat 6 does not respond or freeze after startup
August 3, 2010 02:38:37 PM
Hello, thank you for your response. @Version: I have downloaded the following Tomcat version: http://ftp.fernuni-hagen.de/ftp-dir/pub/mirrors/www.apache.org/tomcat/ tomcat-6/v6.0.29/bin/apache-tomcat-6.0.29-windows-x86.zip @Logs:…

Created: (HIVE-1820) Make Hive database data center aware
December 1, 2010 04:12:58 PM
Make Hive database data center aware

Commented: (HIVE-1264) Make Hive work with Hadoop security
September 16, 2010 05:04:00 PM
[ https://issues.apache.org/jira/browse/HIVE-1264?page=com.atlassian.jir a.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=1 2910346#action_12910346 ] John Sichi commented on HIVE-1264:

Commented: (HIVE-1264) Make Hive work with Hadoop security
July 22, 2010 12:05:53 AM
[ https://issues.apache.org/jira/browse/HIVE-1264?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12891002#action_12891002 ] Venkatesh S commented on HIVE-1264:

Assigned: (HIVE-1264) Make Hive work with Hadoop security
July 26, 2010 05:38:23 PM
[ https://issues.apache.org/jira/browse/HIVE-1264?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashish Thusoo reassigned HIVE-1264:

Resolved: (HIVE-1264) Make Hive work with Hadoop security
October 11, 2010 06:44:18 PM
[ https://issues.apache.org/jira/browse/HIVE-1264?page=com.atlassian.jir a.plugin.system.issuetabpanels:all-tabpanel ] John Sichi resolved HIVE-1264.

Commented: (HIVE-1264) Make Hive work with Hadoop security
July 21, 2010 03:35:51 PM
[ https://issues.apache.org/jira/browse/HIVE-1264?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12890877#action_12890877 ] Carl Steinbach commented on HIVE-1264:

Commented: (HIVE-1264) Make Hive work with Hadoop security
September 1, 2010 01:56:18 PM
[ https://issues.apache.org/jira/browse/HIVE-1264?page=com.atlassian.jir a.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=1 2905156#action_12905156 ] Todd Lipcon commented on HIVE-1264:

Updated: (HIVE-1264) Make Hive work with Hadoop security
September 24, 2010 01:24:18 PM
[ https://issues.apache.org/jira/browse/HIVE-1264?page=com.atlassian.jir a.plugin.system.issuetabpanels:all-tabpanel ] John Sichi updated HIVE-1264:

Commented: (HIVE-1264) Make Hive work with Hadoop security
September 24, 2010 01:24:18 PM
[ https://issues.apache.org/jira/browse/HIVE-1264?page=com.atlassian.jir a.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=1 2914573#action_12914573 ] John Sichi commented on HIVE-1264:

Updated: (HIVE-1264) Make Hive work with Hadoop security
September 23, 2010 06:05:18 PM
[ https://issues.apache.org/jira/browse/HIVE-1264?page=com.atlassian.jir a.plugin.system.issuetabpanels:all-tabpanel ] Todd Lipcon updated HIVE-1264:

Updated: (HIVE-1264) Make Hive work with Hadoop security
July 21, 2010 02:25:51 PM
[ https://issues.apache.org/jira/browse/HIVE-1264?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Venkatesh S updated HIVE-1264:

Commented: (HIVE-1708) make hive history file configurable
January 4, 2011 11:49:13 PM
[ https://issues.apache.org/jira/browse/HIVE-1708?page=com.atlassian.jir a.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=1 2977633#action_12977633 ] Mohit Sikri commented on HIVE-1708:

Updated: (HIVE-1264) Make Hive work with Hadoop security
July 21, 2010 02:31:55 PM
[ https://issues.apache.org/jira/browse/HIVE-1264?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-1264:

Updated: (HIVE-1264) Make Hive work with Hadoop security
January 3, 2011 05:07:14 AM
[ https://issues.apache.org/jira/browse/HIVE-1264?page=com.atlassian.jir a.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-1264:

Commented: (HIVE-1264) Make Hive work with Hadoop security
July 26, 2010 05:42:18 PM
[ https://issues.apache.org/jira/browse/HIVE-1264?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12892517#action_12892517 ] Ashish Thusoo commented on HIVE-1264:

Questions and Answers are licensed under cc-wiki license.

Hive doesn't respond when I try to make a query

1 Answers

Your answer

Join with account you already have