Return-Path: Delivered-To: apmail-hadoop-hive-dev-archive@minotaur.apache.org Received: (qmail 70391 invoked from network); 23 Jun 2010 04:34:21 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 23 Jun 2010 04:34:21 -0000 Received: (qmail 44663 invoked by uid 500); 23 Jun 2010 04:34:21 -0000 Delivered-To: apmail-hadoop-hive-dev-archive@hadoop.apache.org Received: (qmail 44339 invoked by uid 500); 23 Jun 2010 04:34:19 -0000 Mailing-List: contact hive-dev-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: hive-dev@hadoop.apache.org Delivered-To: mailing list hive-dev@hadoop.apache.org Received: (qmail 43831 invoked by uid 99); 23 Jun 2010 04:34:15 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 23 Jun 2010 04:34:15 +0000 X-ASF-Spam-Status: No, hits=-1538.6 required=10.0 tests=ALL_TRUSTED,AWL X-Spam-Check-By: apache.org Received: from [140.211.11.22] (HELO thor.apache.org) (140.211.11.22) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 23 Jun 2010 04:34:14 +0000 Received: from thor (localhost [127.0.0.1]) by thor.apache.org (8.13.8+Sun/8.13.8) with ESMTP id o5N4XsCf026661 for ; Wed, 23 Jun 2010 04:33:54 GMT Message-ID: <23600854.8871277267634714.JavaMail.jira@thor> Date: Wed, 23 Jun 2010 00:33:54 -0400 (EDT) From: "Arvind Prabhakar (JIRA)" To: hive-dev@hadoop.apache.org Subject: [jira] Commented: (HIVE-1176) 'create if not exists' fails for a table name with 'select' in it In-Reply-To: <1023542778.339391266430588408.JavaMail.jira@brutus.apache.org> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/HIVE-1176?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12881538#action_12881538 ] Arvind Prabhakar commented on HIVE-1176: ---------------------------------------- Updated patch with a test case attached. Please use HIVE-1176-3.patch. The changed files in this patch are as follows: # modified: build.properties # modified: build.xml # new file: data/files/simple.txt # modified: eclipse-templates/.classpath # modified: ivy/ivysettings.xml # deleted: lib/datanucleus-core-1.1.2.LICENSE # deleted: lib/datanucleus-core-1.1.2.jar # deleted: lib/datanucleus-enhancer-1.1.2.LICENSE # deleted: lib/datanucleus-enhancer-1.1.2.jar # deleted: lib/datanucleus-rdbms-1.1.2.LICENSE # deleted: lib/datanucleus-rdbms-1.1.2.jar # deleted: lib/jdo2-api-2.3-SNAPSHOT.LICENSE # deleted: lib/jdo2-api-2.3-SNAPSHOT.jar # modified: metastore/ivy.xml # modified: metastore/src/java/org/apache/hadoop/hive/metastore/HiveMetaStoreClient.java # new file: ql/src/test/queries/clientpositive/hive_1176.q # new file: ql/src/test/results/clientpositive/hive_1176.q.out > 'create if not exists' fails for a table name with 'select' in it > ----------------------------------------------------------------- > > Key: HIVE-1176 > URL: https://issues.apache.org/jira/browse/HIVE-1176 > Project: Hadoop Hive > Issue Type: Bug > Components: Metastore, Query Processor > Reporter: Prasad Chakka > Assignee: Arvind Prabhakar > Fix For: 0.6.0 > > Attachments: HIVE-1176-1.patch, HIVE-1176-2.patch, HIVE-1176-3.patch, HIVE-1176.lib-files.tar.gz, HIVE-1176.patch > > > hive> create table if not exists tmp_select(s string, c string, n int); > org.apache.hadoop.hive.ql.metadata.HiveException: MetaException(message:Got exception: javax.jdo.JDOUserException JDOQL Single-String query should always start with SELECT) > at org.apache.hadoop.hive.ql.metadata.Hive.getTablesForDb(Hive.java:441) > at org.apache.hadoop.hive.ql.metadata.Hive.getTablesByPattern(Hive.java:423) > at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeCreateTable(SemanticAnalyzer.java:5538) > at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:5192) > at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:105) > at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:275) > at org.apache.hadoop.hive.ql.Driver.runCommand(Driver.java:320) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:312) > at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:123) > at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:181) > at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:287) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at org.apache.hadoop.util.RunJar.main(RunJar.java:156) > Caused by: MetaException(message:Got exception: javax.jdo.JDOUserException JDOQL Single-String query should always start with SELECT) > at org.apache.hadoop.hive.metastore.MetaStoreUtils.logAndThrowMetaException(MetaStoreUtils.java:612) > at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTables(HiveMetaStoreClient.java:450) > at org.apache.hadoop.hive.ql.metadata.Hive.getTablesForDb(Hive.java:439) > ... 15 more -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.