hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Edward Capriolo (JIRA)" <j...@apache.org>
Subject [jira] Resolved: (HIVE-1303) Adding/selecting many external partitions tables in one session eventually fails
Date Tue, 07 Dec 2010 17:41:09 GMT

     [ https://issues.apache.org/jira/browse/HIVE-1303?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Edward Capriolo resolved HIVE-1303.
-----------------------------------

    Resolution: Won't Fix

This was solved by doing pooling at the JPOX/Data Nucleus level.

> Adding/selecting many external partitions tables in one session eventually fails
> --------------------------------------------------------------------------------
>
>                 Key: HIVE-1303
>                 URL: https://issues.apache.org/jira/browse/HIVE-1303
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 0.5.0
>            Reporter: Edward Capriolo
>            Priority: Critical
>
> echo "create external table if not exists edtest ( dat string ) partitioned by (dummy
string) location '/tmp/a';" > test.q
>  for i in {1..3000} ; do echo "alter table ed_test add partition (dummy='${i}') location
'/tmp/duh';" ; done >> test.q
> hive -f test.q
> Also, there are problems working with this type of table as well. :(
> $ hive -e "explain select * from XXXXX_action "
> Hive history file=/tmp/XXXXXX/hive_job_log_media6_201004121029_170696698.txt
> FAILED: Error in semantic analysis: javax.jdo.JDODataStoreException: Access denied for
user 'hivadm'@'XXXXXX' (using password: YES)
> NestedThrowables:
> java.sql.SQLException: Access denied for user 'hivadm'@'XXXXXX' (using password: YES)
> Interestingly enough if we specify some partitions we can dodge this error. I get the
fealing that the select * is trying to select too many partitions and causing this error.
> 2010-04-12 10:33:02,789 ERROR metadata.Hive (Hive.java:getPartition(629)) - javax.jdo.JDODataStoreException:
Access denied for user 'hivadm'@'rs01
> .sd.pl.pvt' (using password: YES)
>     at org.datanucleus.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:289)
>     at org.datanucleus.jdo.JDOQuery.execute(JDOQuery.java:274)
>     at org.apache.hadoop.hive.metastore.ObjectStore.getMTable(ObjectStore.java:551)
>     at org.apache.hadoop.hive.metastore.ObjectStore.getMPartition(ObjectStore.java:716)
>     at org.apache.hadoop.hive.metastore.ObjectStore.getPartition(ObjectStore.java:704)
>     at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_partition(HiveMetaStore.java:593)
>     at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getPartition(HiveMetaStoreClient.java:418)
>     at org.apache.hadoop.hive.ql.metadata.Hive.getPartition(Hive.java:620)
>     at org.apache.hadoop.hive.ql.optimizer.ppr.PartitionPruner.prune(PartitionPruner.java:215)
>     at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genMapRedTasks(SemanticAnalyzer.java:4883)
>     at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:5224)
>     at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:105)
>     at org.apache.hadoop.hive.ql.parse.ExplainSemanticAnalyzer.analyzeInternal(ExplainSemanticAnalyzer.java:44)
>     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:251)
>     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)
> NestedThrowablesStackTrace:
> java.sql.SQLException: Access denied for user 'hivadm'@'XXXXX.domain.whatetever' (using
password: YES)
>     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
>     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
>     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:885)
>     at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3436)
>     at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1247)
>     at com.mysql.jdbc.Connection.createNewIO(Connection.java:2775)
>     at com.mysql.jdbc.Connection.<init>(Connection.java:1555)
>     at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
>     at org.datanucleus.store.rdbms.datasource.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:142)
>     at org.datanucleus.store.rdbms.datasource.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:118)
>     at org.datanucleus.store.rdbms.ConnectionProviderPriorityList.getConnection(ConnectionProviderPriorityList.java:59)
>     at org.datanucleus.store.rdbms.ConnectionFactoryImpl$ManagedConnectionImpl.getConnection(ConnectionFactoryImpl.java:458)
>     at org.datanucleus.store.rdbms.ConnectionFactoryImpl$ManagedConnectionImpl.getXAResource(ConnectionFactoryImpl.java:418)
>     at org.datanucleus.ConnectionManagerImpl.enlistResource(ConnectionManagerImpl.java:329)
>     at org.datanucleus.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:210)
>     at org.datanucleus.store.rdbms.ConnectionFactoryImpl.getConnection(ConnectionFactoryImpl.java:345)
>     at org.datanucleus.store.AbstractStoreManager.getConnection(AbstractStoreManager.java:267)
>     at org.datanucleus.store.rdbms.query.SQLEvaluator.evaluate(SQLEvaluator.java:91)
>     at org.datanucleus.store.rdbms.query.JDOQLQuery.performExecute(JDOQLQuery.java:287)
>     at org.datanucleus.store.query.Query.executeQuery(Query.java:1475)
>     at org.datanucleus.store.rdbms.query.JDOQLQuery.executeQuery(JDOQLQuery.java:244)
>     at org.datanucleus.store.query.Query.executeWithArray(Query.java:1357)
>     at org.datanucleus.jdo.JDOQuery.execute(JDOQuery.java:265)
>     at org.apache.hadoop.hive.metastore.ObjectStore.getMTable(ObjectStore.java:551)
>     at org.apache.hadoop.hive.metastore.ObjectStore.getMPartition(ObjectStore.java:716)
>     at org.apache.hadoop.hive.metastore.ObjectStore.getPartition(ObjectStore.java:704)
>     at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_partition(HiveMetaStore.java:593)
>     at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getPartition(HiveMetaStoreClient.java:418)
>     at org.apache.hadoop.hive.ql.metadata.Hive.getPartition(Hive.java:620)
>     at org.apache.hadoop.hive.ql.optimizer.ppr.PartitionPruner.prune(PartitionPruner.java:215)
>     at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genMapRedTasks(SemanticAnalyzer.java:4883)
>     at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:5224)
>     at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:105)
>     at org.apache.hadoop.hive.ql.parse.ExplainSemanticAnalyzer.analyzeInternal(ExplainSemanticAnalyzer.java:44)
>     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:251)
>     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)
> 2010-04-12 10:33:02,790 ERROR parse.SemanticAnalyzer (SemanticAnalyzer.java:genMapRedTasks(4886))
- org.apache.hadoop.hive.ql.metadata.HiveExcepti
> on: javax.jdo.JDODataStoreException: Access denied for user 'hivadm'@'XXXXX.domain.whatetever'
(using password: YES)
> NestedThrowables:
> java.sql.SQLException: Access denied for user 'hivadm'@'XXXXX.domain.whatetever' (using
password: YES)
>     at org.apache.hadoop.hive.ql.metadata.Hive.getPartition(Hive.java:630)
>     at org.apache.hadoop.hive.ql.optimizer.ppr.PartitionPruner.prune(PartitionPruner.java:215)
>     at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genMapRedTasks(SemanticAnalyzer.java:4883)
>     at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:5224)
>     at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:105)
>     at org.apache.hadoop.hive.ql.parse.ExplainSemanticAnalyzer.analyzeInternal(ExplainSemanticAnalyzer.java:44)
>     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:251)
>     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: javax.jdo.JDODataStoreException: Access denied for user 'hivadm'@'XXXXX.domain.whatetever'
(using password: YES)
> NestedThrowables:
> java.sql.SQLException: Access denied for user 'hivadm'@'XXXXX.domain.whatetever' (using
password: YES)
>     at org.datanucleus.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:289)
>     at org.datanucleus.jdo.JDOQuery.execute(JDOQuery.java:274)
>     at org.apache.hadoop.hive.metastore.ObjectStore.getMTable(ObjectStore.java:551)
>     at org.apache.hadoop.hive.metastore.ObjectStore.getMPartition(ObjectStore.java:716)
>     at org.apache.hadoop.hive.metastore.ObjectStore.getPartition(ObjectStore.java:704)
>     at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_partition(HiveMetaStore.java:593)
>     at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getPartition(HiveMetaStoreClient.java:418)
>     at org.apache.hadoop.hive.ql.metadata.Hive.getPartition(Hive.java:620)
>     ... 17 more
> Caused by: java.sql.SQLException: Access denied for user 'hivadm'@'XXXXX.domain.whatetever'
(using password: YES)
>     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
>     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
>     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:885)
>     at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3436)
>     at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1247)
>     at com.mysql.jdbc.Connection.createNewIO(Connection.java:2775)
>     at com.mysql.jdbc.Connection.<init>(Connection.java:1555)
>     at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
>     at org.datanucleus.store.rdbms.datasource.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:142)
>     at org.datanucleus.store.rdbms.datasource.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:118)
>     at org.datanucleus.store.rdbms.ConnectionProviderPriorityList.getConnection(ConnectionProviderPriorityList.java:59)
>     at org.datanucleus.store.rdbms.ConnectionFactoryImpl$ManagedConnectionImpl.getConnection(ConnectionFactoryImpl.java:458)
>     at org.datanucleus.store.rdbms.ConnectionFactoryImpl$ManagedConnectionImpl.getXAResource(ConnectionFactoryImpl.java:418)
>     at org.datanucleus.ConnectionManagerImpl.enlistResource(ConnectionManagerImpl.java:329)
>     at org.datanucleus.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:210)
>     at org.datanucleus.store.rdbms.ConnectionFactoryImpl.getConnection(ConnectionFactoryImpl.java:345)
>     at org.datanucleus.store.AbstractStoreManager.getConnection(AbstractStoreManager.java:267)
>     at org.datanucleus.store.rdbms.query.SQLEvaluator.evaluate(SQLEvaluator.java:91)
>     at org.datanucleus.store.rdbms.query.JDOQLQuery.performExecute(JDOQLQuery.java:287)
>     at org.datanucleus.store.query.Query.executeQuery(Query.java:1475)
>     at org.datanucleus.store.rdbms.query.JDOQLQuery.executeQuery(JDOQLQuery.java:244)
>     at org.datanucleus.store.query.Query.executeWithArray(Query.java:1357)
>     at org.datanucleus.jdo.JDOQuery.execute(JDOQuery.java:265)
>     ... 23 more
> 2010-04-12 10:33:02,793 ERROR ql.Driver (SessionState.java:printError(248)) - FAILED:
Error in semantic analysis: javax.jdo.JDODataStoreException:
>  Access denied for user 'hivadm'@'XXXXX.domain.whatetever' (using password: YES)
> NestedThrowables:
> java.sql.SQLException: Access denied for user 'hivadm'@'XXXXX.domain.whatetever' (using
password: YES)
> org.apache.hadoop.hive.ql.parse.SemanticException: javax.jdo.JDODataStoreException: Access
denied for user 'hivadm'@'XXXXX.domain.whatetever' (using passwo
> rd: YES)
> NestedThrowables:
> java.sql.SQLException: Access denied for user 'hivadm'@'XXXXX.domain.whatetever' (using
password: YES)
>     at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genMapRedTasks(SemanticAnalyzer.java:4887)
>     at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:5224)
>     at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:105)
>     at org.apache.hadoop.hive.ql.parse.ExplainSemanticAnalyzer.analyzeInternal(ExplainSemanticAnalyzer.java:44)
>     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:251)
>     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: org.apache.hadoop.hive.ql.metadata.HiveException: javax.jdo.JDODataStoreException:
Access denied for user 'hivadm'@'XXXXX.domain.whatetever' (us
> ing password: YES)
> NestedThrowables:
> java.sql.SQLException: Access denied for user 'hivadm'@'XXXXX.domain.whatetever' (using
password: YES)
>     at org.apache.hadoop.hive.ql.metadata.Hive.getPartition(Hive.java:630)
>     at org.apache.hadoop.hive.ql.optimizer.ppr.PartitionPruner.prune(PartitionPruner.java:215)
>     at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genMapRedTasks(SemanticAnalyzer.java:4883)
>     ... 15 more
> Caused by: javax.jdo.JDODataStoreException: Access denied for user 'hivadm'@'XXXXX.domain.whatetever'
(using password: YES)
> NestedThrowables:
> java.sql.SQLException: Access denied for user 'hivadm'@'XXXXX.domain.whatetever' (using
password: YES)
>     at org.datanucleus.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:289)
>     at org.datanucleus.jdo.JDOQuery.execute(JDOQuery.java:274)
>     at org.apache.hadoop.hive.metastore.ObjectStore.getMTable(ObjectStore.java:551)
>     at org.apache.hadoop.hive.metastore.ObjectStore.getMPartition(ObjectStore.java:716)
>     at org.apache.hadoop.hive.metastore.ObjectStore.getPartition(ObjectStore.java:704)
>     at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_partition(HiveMetaStore.java:593)
>     at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getPartition(HiveMetaStoreClient.java:418)
>     at org.apache.hadoop.hive.ql.metadata.Hive.getPartition(Hive.java:620)
>     ... 17 more
> Caused by: java.sql.SQLException: Access denied for user 'hivadm'@'XXXXX.domain.whatetever'
(using password: YES)
>     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
>     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
>     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:885)
>     at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3436)
>     at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1247)
>     at com.mysql.jdbc.Connection.createNewIO(Connection.java:2775)
>     at com.mysql.jdbc.Connection.<init>(Connection.java:1555)
>     at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
>     at org.datanucleus.store.rdbms.datasource.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:142)
>     at org.datanucleus.store.rdbms.datasource.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:118)
>     at org.datanucleus.store.rdbms.ConnectionProviderPriorityList.getConnection(ConnectionProviderPriorityList.java:59)
>     at org.datanucleus.store.rdbms.ConnectionFactoryImpl$ManagedConnectionImpl.getConnection(ConnectionFactoryImpl.java:458)
>     at org.datanucleus.store.rdbms.ConnectionFactoryImpl$ManagedConnectionImpl.getXAResource(ConnectionFactoryImpl.java:418)
>     at org.datanucleus.ConnectionManagerImpl.enlistResource(ConnectionManagerImpl.java:329)
> Access denied for user 'hivadm'@'XXXXX.domain.whatetever' (using password: YES)
> NestedThrowables:
> java.sql.SQLException: Access denied for user 'hivadm'@'XXXXX.domain.whatetever' (using
password: YES)
> org.apache.hadoop.hive.ql.parse.SemanticException: javax.jdo.JDODataStoreException: Access
denied for user 'hivadm'@'XXXXX.domain.whatetever' (using passwo
> rd: YES)
> NestedThrowables:
> java.sql.SQLException: Access denied for user 'hivadm'@'XXXXX.domain.whatetever' (using
password: YES)
>     at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genMapRedTasks(SemanticAnalyzer.java:4887)
>     at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:5224)
>     at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:105)
>     at org.apache.hadoop.hive.ql.parse.ExplainSemanticAnalyzer.analyzeInternal(ExplainSemanticAnalyzer.java:44)
>     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:251)
>     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: org.apache.hadoop.hive.ql.metadata.HiveException: javax.jdo.JDODataStoreException:
Access denied for user 'hivadm'@'XXXXX.domain.whatetever' (us
> ing password: YES)
> NestedThrowables:
> java.sql.SQLException: Access denied for user 'hivadm'@'XXXXX.domain.whatetever' (using
password: YES)
>     at org.apache.hadoop.hive.ql.metadata.Hive.getPartition(Hive.java:630)
>     at org.apache.hadoop.hive.ql.optimizer.ppr.PartitionPruner.prune(PartitionPruner.java:215)
>     at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genMapRedTasks(SemanticAnalyzer.java:4883)
>     ... 15 more
> Caused by: javax.jdo.JDODataStoreException: Access denied for user 'hivadm'@'XXXXX.domain.whatetever'
(using password: YES)
> NestedThrowables:
> java.sql.SQLException: Access denied for user 'hivadm'@'XXXXX.domain.whatetever' (using
password: YES)
>     at org.datanucleus.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:289)
>     at org.datanucleus.jdo.JDOQuery.execute(JDOQuery.java:274)
>     at org.apache.hadoop.hive.metastore.ObjectStore.getMTable(ObjectStore.java:551)
>     at org.apache.hadoop.hive.metastore.ObjectStore.getMPartition(ObjectStore.java:716)
>     at org.apache.hadoop.hive.metastore.ObjectStore.getPartition(ObjectStore.java:704)
>     at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_partition(HiveMetaStore.java:593)
>     at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getPartition(HiveMetaStoreClient.java:418)
>     at org.apache.hadoop.hive.ql.metadata.Hive.getPartition(Hive.java:620)
>     ... 17 more
> Caused by: java.sql.SQLException: Access denied for user 'hivadm'@'XXXXX.domain.whatetever'
(using password: YES)
>     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
>     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
>     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:885)
>     at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3436)
>     at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1247)
>     at com.mysql.jdbc.Connection.createNewIO(Connection.java:2775)
>     at com.mysql.jdbc.Connection.<init>(Connection.java:1555)
>     at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
>     at org.datanucleus.store.rdbms.datasource.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:142)
>     at org.datanucleus.store.rdbms.datasource.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:118)
>     at org.datanucleus.store.rdbms.ConnectionProviderPriorityList.getConnection(ConnectionProviderPriorityList.java:59)
>     at org.datanucleus.store.rdbms.ConnectionFactoryImpl$ManagedConnectionImpl.getConnection(ConnectionFactoryImpl.java:458)
>     at org.datanucleus.store.rdbms.ConnectionFactoryImpl$ManagedConnectionImpl.getXAResource(ConnectionFactoryImpl.java:418)
>     at org.datanucleus.ConnectionManagerImpl.enlistResource(ConnectionManagerImpl.java:329)
>     at org.datanucleus.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:210)
>     at org.datanucleus.store.rdbms.ConnectionFactoryImpl.getConnection(ConnectionFactoryImpl.java:345)
>     at org.datanucleus.store.AbstractStoreManager.getConnection(AbstractStoreManager.java:267)
>     at org.datanucleus.store.rdbms.query.SQLEvaluator.evaluate(SQLEvaluator.java:91)
>     at org.datanucleus.store.rdbms.query.JDOQLQuery.performExecute(JDOQLQuery.java:287)
>     at org.datanucleus.store.query.Query.executeQuery(Query.java:1475)
>     at org.datanucleus.store.rdbms.query.JDOQLQuery.executeQuery(JDOQLQuery.java:244)
>     at org.datanucleus.store.query.Query.executeWithArray(Query.java:1357)
>     at org.datanucleus.jdo.JDOQuery.execute(JDOQuery.java:265)
>     ... 23 more

-- 
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