[ https://issues.apache.org/jira/browse/HIVE-7891?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mithun Radhakrishnan updated HIVE-7891: --------------------------------------- Status: Patch Available (was: Open) > Table-creation fails through HCatClient for Oracle-based metastore. > ------------------------------------------------------------------- > > Key: HIVE-7891 > URL: https://issues.apache.org/jira/browse/HIVE-7891 > Project: Hive > Issue Type: Bug > Components: HCatalog, Metastore > Affects Versions: 0.14.0 > Reporter: Mithun Radhakrishnan > Assignee: Mithun Radhakrishnan > Attachments: HIVE-7891.1.patch > > > When tables are created using {{HCatClient.createTable()}}, if the > HCatTable's creation-comment is an empty string, the table creation fails > spectacularly, with this guttural utterance: > {noformat} > Exception in thread "main" org.apache.hive.hcatalog.common.HCatException : > 9001 : Exception occurred while processing HCat request : MetaException while > creating table.. Cause : > MetaException(message:java.lang.NullPointerException: Null values not allowed > in persistent maps.) > at > org.apache.hive.hcatalog.api.HCatClientHMSImpl.createTable(HCatClientHMSImpl.java:185) > at net.myth.HiveClient.main(HiveClient.java:67) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:601) > at org.apache.hadoop.util.RunJar.main(RunJar.java:208) > Caused by: MetaException(message:java.lang.NullPointerException: Null values > not allowed in persistent maps.) > at > org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$create_table_with_environment_context_result$create_table_with_environment_context_resultStandardScheme.read(ThriftHiveMetastore.java:22138) > at > org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$create_table_with_environment_context_result$create_table_with_environment_context_resultStandardScheme.read(ThriftHiveMetastore.java:22106) > at > org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$create_table_with_environment_context_result.read(ThriftHiveMetastore.java:22032) > at > org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:78) > at > org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_create_table_with_environment_context(ThriftHiveMetastore.java:797) > at > org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.create_table_with_environment_context(ThriftHiveMetastore.java:783) > at > org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:487) > at > org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:476) > at > org.apache.hive.hcatalog.api.HCatClientHMSImpl.createTable(HCatClientHMSImpl.java:175) > {noformat} > This manifests with an Oracle backend, because an empty comment-string is > stored in the table-properties map as a null-string. I've a patch that fixes > this. -- This message was sent by Atlassian JIRA (v6.2#6252)