Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 389A49D2B for ; Thu, 2 Feb 2012 14:45:07 +0000 (UTC) Received: (qmail 94110 invoked by uid 500); 2 Feb 2012 14:45:06 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 94039 invoked by uid 500); 2 Feb 2012 14:45:05 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 94031 invoked by uid 99); 2 Feb 2012 14:45:05 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 02 Feb 2012 14:45:05 +0000 X-ASF-Spam-Status: No, hits=3.1 required=5.0 tests=SPF_PASS,URI_OBFU_WWW X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of prvs=mgrover=3728dfad8@oanda.com designates 98.158.95.75 as permitted sender) Received: from [98.158.95.75] (HELO ironport-01.sms.scalar.ca) (98.158.95.75) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 02 Feb 2012 14:44:58 +0000 Received: from unknown (HELO sms-zimbra-mta-01.sms.scalar.ca) ([192.168.32.56]) by ironport-01.sms.scalar.ca with ESMTP; 02 Feb 2012 09:44:37 -0500 Received: from localhost (localhost.localdomain [127.0.0.1]) by sms-zimbra-mta-01.sms.scalar.ca (Postfix) with ESMTP id 35E3F17F48 for ; Thu, 2 Feb 2012 09:44:37 -0500 (EST) Received: from sms-zimbra-mta-01.sms.scalar.ca ([127.0.0.1]) by localhost (sms-zimbra-mta-01.sms.scalar.ca [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id FWCskyc5tAZi for ; Thu, 2 Feb 2012 09:44:36 -0500 (EST) Received: from sms-zimbra-message-store-03.sms.scalar.ca (unknown [172.17.19.202]) by sms-zimbra-mta-01.sms.scalar.ca (Postfix) with ESMTP id B064117F45 for ; Thu, 2 Feb 2012 09:44:36 -0500 (EST) Date: Thu, 02 Feb 2012 09:44:36 -0500 (EST) From: Mark Grover To: user@hive.apache.org Subject: Re: Not able to create table in hive Message-ID: In-Reply-To: <8184D4E667D5A54F888BF3B03672CD9770DABA1E61@TLEMLMBX15P.email.target.com> Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit MIME-Version: 1.0 X-Originating-IP: [216.235.10.210] X-Mailer: Zimbra 7.1.2_GA_3268 (ZimbraWebClient - FF3.0 (Linux)/7.1.2_GA_3268) X-Virus-Checked: Checked by ClamAV on apache.org Hi Manish, Sounds like a problem with your metastore. Can you verify that you have the access and correct permissions to your metastore? Mark Mark Grover, Business Intelligence Analyst OANDA Corporation www: oanda.com www: fxtrade.com e: mgrover@oanda.com "Best Trading Platform" - World Finance's Forex Awards 2009. "The One to Watch" - Treasury Today's Adam Smith Awards 2009. ----- Original Message ----- From: "Manish.Bhoge" To: user@hive.apache.org, dev@hive.apache.org Sent: Thursday, February 2, 2012 8:45:26 AM Subject: Not able to create table in hive Hi, I am trying to create a table in Hive using below DDL: CREATE TABLE pokes (foo INT, bar STRING); I am getting below error, I have logged in as admin user : FAILED: Error in metadata: javax.jdo.JDOFatalDataStoreException: Cannot get a connection, pool error Could not create a validated object, cause: A read-only user or a user in a read-only database is not permitted to disable read-only mode on a connection. NestedThrowables: org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Could not create a validated object, cause: A read-only user or a user in a read-only database is not permitted to disable read-only mode on a connection. FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask Any idea? Thank You, Manish