[ https://issues.apache.org/jira/browse/HIVE-13510?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15250257#comment-15250257 ]
Ashutosh Chauhan commented on HIVE-13510: ----------------------------------------- +1 > Dynamic partitioning doesn’t work when remote metastore is used > --------------------------------------------------------------- > > Key: HIVE-13510 > URL: https://issues.apache.org/jira/browse/HIVE-13510 > Project: Hive > Issue Type: Bug > Components: Metastore > Affects Versions: 2.1.0 > Environment: Hadoop 2.7.1 > Reporter: Illya Yalovyy > Assignee: Illya Yalovyy > Priority: Critical > Attachments: HIVE-13510.1.patch > > > *Steps to reproduce:* > # Configure remote metastore (hive.metastore.uris) > # Create table t1 (a string); > # Create table t2 (a string) partitioned by (b string); > # set hive.exec.dynamic.partition.mode=nonstrict; > # Insert overwrite table t2 partition (b) select a,a from t1; > *Result:* > {noformat} > FAILED: SemanticException org.apache.hadoop.hive.ql.metadata.HiveException: > org.apache.thrift.TApplicationException: getMetaConf failed: unknown result > 16/04/13 15:04:51 [c679e424-2501-4347-8146-cf1b1cae217c main]: ERROR > ql.Driver: FAILED: SemanticException > org.apache.hadoop.hive.ql.metadata.HiveException: > org.apache.thrift.TApplicationException: getMetaConf failed: unknown result > org.apache.hadoop.hive.ql.parse.SemanticException: > org.apache.hadoop.hive.ql.metadata.HiveException: > org.apache.thrift.TApplicationException: getMetaConf failed: unknown result > at > org.apache.hadoop.hive.ql.plan.DynamicPartitionCtx.<init>(DynamicPartitionCtx.java:84) > at > org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genFileSinkPlan(SemanticAnalyzer.java:6550) > at > org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genPostGroupByBodyPlan(SemanticAnalyzer.java:9315) > at > org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genBodyPlan(SemanticAnalyzer.java:9204) > at > org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genPlan(SemanticAnalyzer.java:10071) > at > org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genPlan(SemanticAnalyzer.java:9949) > at > org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genOPTree(SemanticAnalyzer.java:10607) > at > org.apache.hadoop.hive.ql.parse.CalcitePlanner.genOPTree(CalcitePlanner.java:358) > at > org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:10618) > at > org.apache.hadoop.hive.ql.parse.CalcitePlanner.analyzeInternal(CalcitePlanner.java:233) > at > org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:245) > at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:476) > at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:318) > at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1192) > at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1287) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1118) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1106) > at > org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:236) > at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:187) > at > org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:403) > at > org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:339) > at > org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:748) > at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:721) > at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:648) > 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:606) > at org.apache.hadoop.util.RunJar.run(RunJar.java:221) > at org.apache.hadoop.util.RunJar.main(RunJar.java:136) > Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: > org.apache.thrift.TApplicationException: getMetaConf failed: unknown result > at org.apache.hadoop.hive.ql.metadata.Hive.getMetaConf(Hive.java:3493) > at > org.apache.hadoop.hive.ql.plan.DynamicPartitionCtx.<init>(DynamicPartitionCtx.java:82) > ... 29 more > Caused by: org.apache.thrift.TApplicationException: getMetaConf failed: > unknown result > at > org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_getMetaConf(ThriftHiveMetastore.java:666) > at > org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.getMetaConf(ThriftHiveMetastore.java:646) > at > org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getMetaConf(HiveMetaStoreClient.java:550) > 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:606) > at > org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:153) > at com.sun.proxy.$Proxy20.getMetaConf(Unknown Source) > 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:606) > at > org.apache.hadoop.hive.metastore.HiveMetaStoreClient$SynchronizedHandler.invoke(HiveMetaStoreClient.java:2153) > at com.sun.proxy.$Proxy20.getMetaConf(Unknown Source) > at org.apache.hadoop.hive.ql.metadata.Hive.getMetaConf(Hive.java:3491) > ... 30 more > {noformat} > > During construction of DynamicPartitionCtx it tries to read > “hive.metastore.partition.name.whitelist.pattern” from the metastore. If no > value is configured in hive-site.xml then NULL will be returned. Thrift > considers NULL as invalid result and fails with an exception. -- This message was sent by Atlassian JIRA (v6.3.4#6332)