hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jake Farrell (JIRA)" <j...@apache.org>
Subject [jira] Commented: (HIVE-1712) Migrating metadata from derby to mysql thrown NullPointerException
Date Thu, 14 Oct 2010 17:30:34 GMT

    [ https://issues.apache.org/jira/browse/HIVE-1712?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12921034#action_12921034
] 

Jake Farrell commented on HIVE-1712:
------------------------------------

Tracked down the issue to the SERDE_PARAMS table which in the mysql create statement has 
`PARAM_VALUE` default NULL.  The values that are saved to the db when hive loads the data
are blank, when exported from derby they are blank in the csv, and when imported into mysql
are defaulted to NULL. This NULL value when picked up by MetaStoreUtils is not being caught
and causes the NullPointerException

> Migrating metadata from derby to mysql thrown NullPointerException
> ------------------------------------------------------------------
>
>                 Key: HIVE-1712
>                 URL: https://issues.apache.org/jira/browse/HIVE-1712
>             Project: Hadoop Hive
>          Issue Type: Bug
>          Components: Metastore
>    Affects Versions: 0.5.0
>            Reporter: Jake Farrell
>
> 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.


Mime
View raw message