Return-Path: Delivered-To: apmail-hive-dev-archive@www.apache.org Received: (qmail 60149 invoked from network); 11 Nov 2010 18:55:06 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 11 Nov 2010 18:55:06 -0000 Received: (qmail 39843 invoked by uid 500); 11 Nov 2010 18:55:37 -0000 Delivered-To: apmail-hive-dev-archive@hive.apache.org Received: (qmail 39808 invoked by uid 500); 11 Nov 2010 18:55:37 -0000 Mailing-List: contact dev-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hive.apache.org Delivered-To: mailing list dev@hive.apache.org Received: (qmail 39775 invoked by uid 500); 11 Nov 2010 18:55:37 -0000 Delivered-To: apmail-hadoop-hive-dev@hadoop.apache.org Received: (qmail 39759 invoked by uid 99); 11 Nov 2010 18:55:37 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 11 Nov 2010 18:55:37 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED 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; Thu, 11 Nov 2010 18:55:36 +0000 Received: from thor (localhost [127.0.0.1]) by thor.apache.org (8.13.8+Sun/8.13.8) with ESMTP id oABItGGu022627 for ; Thu, 11 Nov 2010 18:55:16 GMT Message-ID: <21904967.31601289501716246.JavaMail.jira@thor> Date: Thu, 11 Nov 2010 13:55:16 -0500 (EST) From: "Paul Yang (JIRA)" To: hive-dev@hadoop.apache.org Subject: [jira] Commented: (HIVE-1712) Migrating metadata from derby to mysql thrown NullPointerException 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-1712?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12931132#action_12931132 ] Paul Yang commented on HIVE-1712: --------------------------------- Committed. Thanks Jake! We'll add you as a contributor so we can assign this issue to you. > Migrating metadata from derby to mysql thrown NullPointerException > ------------------------------------------------------------------ > > Key: HIVE-1712 > URL: https://issues.apache.org/jira/browse/HIVE-1712 > Project: Hive > Issue Type: Bug > Components: Metastore > Affects Versions: 0.5.0, 0.6.0 > Reporter: Jake Farrell > Fix For: 0.7.0 > > Attachments: hive-1712.patch, hive-1712_rebase.patch > > > Exported derby data to csv, loaded data into mysql and ran hive query which worked in derby and got the following exception > 2010-10-16 08:57:29,080 INFO metastore.ObjectStore (ObjectStore.java:setConf(106)) - Initialized ObjectStore > 2010-10-16 08:57:29,552 INFO metastore.HiveMetaStore (HiveMetaStore.java:logStartFunction(171)) - 0: get_table : db=default tbl=testimport > 2010-10-16 08:57:30,140 ERROR metadata.Hive (Hive.java:getTable(395)) - java.lang.NullPointerException > at java.util.Hashtable.put(Hashtable.java:394) > at java.util.Hashtable.putAll(Hashtable.java:466) > at org.apache.hadoop.hive.metastore.MetaStoreUtils.getSchema(MetaStoreUtils.java:520) > at org.apache.hadoop.hive.metastore.MetaStoreUtils.getSchema(MetaStoreUtils.java:489) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:381) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:333) > at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:683) > at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:5200) > 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) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.