hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vineet Garg (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-18755) Modifications to the metastore for catalogs
Date Mon, 02 Apr 2018 18:20:00 GMT

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

Vineet Garg commented on HIVE-18755:
------------------------------------

Looks like this has broken the internal derby initschema. I am unable to start hive cli. I
get the following error:

{code:sql}
Exception in thread "main" java.lang.RuntimeException: java.lang.RuntimeException: org.apache.hadoop.hive.ql.metadata.HiveException:
java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
 at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:651)
 at org.apache.hadoop.hive.ql.session.SessionState.beginStart(SessionState.java:560)
 at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:747)
 at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:683)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:498)
 at org.apache.hadoop.util.RunJar.run(RunJar.java:239)
 at org.apache.hadoop.util.RunJar.main(RunJar.java:153)
Caused by: java.lang.RuntimeException: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException:
Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
 at org.apache.hadoop.hive.ql.session.SessionState.setupAuth(SessionState.java:894)
 at org.apache.hadoop.hive.ql.session.SessionState.getAuthenticator(SessionState.java:1619)
 at org.apache.hadoop.hive.ql.session.SessionState.getUserFromAuthenticator(SessionState.java:1236)
 at org.apache.hadoop.hive.ql.exec.tez.TezSessionState.setupSessionAcls(TezSessionState.java:552)
 at org.apache.hadoop.hive.ql.exec.tez.TezSessionState.openInternal(TezSessionState.java:348)
 at org.apache.hadoop.hive.ql.exec.tez.TezSessionState.beginOpen(TezSessionState.java:248)
 at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:648)
 ... 9 more
Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Unable
to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
 at org.apache.hadoop.hive.ql.session.SessionState.setAuthorizerV2Config(SessionState.java:926)
 at org.apache.hadoop.hive.ql.session.SessionState.setupAuth(SessionState.java:886)
 ... 15 more
Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Unable
to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
 at org.apache.hadoop.hive.ql.metadata.Hive.registerAllFunctionsOnce(Hive.java:261)
 at org.apache.hadoop.hive.ql.metadata.Hive.<init>(Hive.java:413)
 at org.apache.hadoop.hive.ql.metadata.Hive.create(Hive.java:357)
 at org.apache.hadoop.hive.ql.metadata.Hive.getInternal(Hive.java:337)
 at org.apache.hadoop.hive.ql.metadata.Hive.get(Hive.java:313)
 at org.apache.hadoop.hive.ql.session.SessionState.setAuthorizerV2Config(SessionState.java:922)
 ... 16 more
Caused by: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
 at org.apache.hadoop.hive.metastore.utils.JavaUtils.newInstance(JavaUtils.java:86)
 at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:95)
 at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:148)
 at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:119)
 at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:4062)
 at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:4114)
 at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:4094)
 at org.apache.hadoop.hive.ql.metadata.Hive.getAllFunctions(Hive.java:4350)
 at org.apache.hadoop.hive.ql.metadata.Hive.reloadFunctions(Hive.java:273)
 at org.apache.hadoop.hive.ql.metadata.Hive.registerAllFunctionsOnce(Hive.java:256)
 ... 21 more
Caused by: java.lang.reflect.InvocationTargetException
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
 at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
 at org.apache.hadoop.hive.metastore.utils.JavaUtils.newInstance(JavaUtils.java:84)
 ... 30 more
Caused by: MetaException(message:Insert of object "org.apache.hadoop.hive.metastore.model.MDatabase@1e76afeb"
using statement "INSERT INTO DBS (DB_ID,CTLG_NAME,"DESC",DB_LOCATION_URI,"NAME",OWNER_NAME,OWNER_TYPE)
VALUES (?,?,?,?,?,?,?)" failed : 'CTLG_NAME' is not a column in table or VTI 'APP.DBS'.)
 at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:84)
 at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:93)
 at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:8381)
 at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:168)
 at org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.<init>(SessionHiveMetaStoreClient.java:81)
 ... 35 more
Caused by: MetaException(message:Insert of object "org.apache.hadoop.hive.metastore.model.MDatabase@1e76afeb"
using statement "INSERT INTO DBS (DB_ID,CTLG_NAME,"DESC",DB_LOCATION_URI,"NAME",OWNER_NAME,OWNER_TYPE)
VALUES (?,?,?,?,?,?,?)" failed : 'CTLG_NAME' is not a column in table or VTI 'APP.DBS'.)
 at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:208)
 at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:108)
 at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:80)
 ... 39 more
Caused by: javax.jdo.JDODataStoreException: Insert of object "org.apache.hadoop.hive.metastore.model.MDatabase@1e76afeb"
using statement "INSERT INTO DBS (DB_ID,CTLG_NAME,"DESC",DB_LOCATION_URI,"NAME",OWNER_NAME,OWNER_TYPE)
VALUES (?,?,?,?,?,?,?)" failed : 'CTLG_NAME' is not a column in table or VTI 'APP.DBS'.
NestedThrowables:
java.sql.SQLSyntaxErrorException: 'CTLG_NAME' is not a column in table or VTI 'APP.DBS'.
 at org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:543)
 at org.datanucleus.api.jdo.JDOPersistenceManager.jdoMakePersistent(JDOPersistenceManager.java:729)
 at org.datanucleus.api.jdo.JDOPersistenceManager.makePersistent(JDOPersistenceManager.java:749)
 at org.apache.hadoop.hive.metastore.ObjectStore.createDatabase(ObjectStore.java:933)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:498)
 at org.apache.hadoop.hive.metastore.RawStoreProxy.invoke(RawStoreProxy.java:97)
 at com.sun.proxy.$Proxy35.createDatabase(Unknown Source)
 at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB_core(HiveMetaStore.java:727)
 at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:749)
 at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:516)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:498)
 at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:147)
 ... 41 more
Caused by: java.sql.SQLSyntaxErrorException: 'CTLG_NAME' is not a column in table or VTI 'APP.DBS'.
 at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
 at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
 at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
 at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
 at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
 at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
 at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
 at org.apache.derby.impl.jdbc.EmbedPreparedStatement42.<init>(Unknown Source)
 at org.apache.derby.jdbc.Driver42.newEmbedPreparedStatement(Unknown Source)
 at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
 at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
 at com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:311)
 at com.zaxxer.hikari.pool.HikariProxyConnection.prepareStatement(HikariProxyConnection.java)
 at org.datanucleus.store.rdbms.SQLController.getStatementForUpdate(SQLController.java:255)
 at org.datanucleus.store.rdbms.request.InsertRequest.execute(InsertRequest.java:241)
 at org.datanucleus.store.rdbms.RDBMSPersistenceHandler.insertObjectInTable(RDBMSPersistenceHandler.java:162)
 at org.datanucleus.store.rdbms.RDBMSPersistenceHandler.insertObject(RDBMSPersistenceHandler.java:138)
 at org.datanucleus.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.java:3363)
 at org.datanucleus.state.StateManagerImpl.makePersistent(StateManagerImpl.java:3339)
 at org.datanucleus.ExecutionContextImpl.persistObjectInternal(ExecutionContextImpl.java:2080)
 at org.datanucleus.ExecutionContextImpl.persistObjectWork(ExecutionContextImpl.java:1923)
 at org.datanucleus.ExecutionContextImpl.persistObject(ExecutionContextImpl.java:1778)
 at org.datanucleus.ExecutionContextThreadedImpl.persistObject(ExecutionContextThreadedImpl.java:217)
 at org.datanucleus.api.jdo.JDOPersistenceManager.jdoMakePersistent(JDOPersistenceManager.java:724)
 ... 57 more
Caused by: ERROR 42X14: 'CTLG_NAME' is not a column in table or VTI 'APP.DBS'.
 at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
 at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
 at org.apache.derby.impl.sql.compile.ResultColumn.bindResultColumnByName(Unknown Source)
 at org.apache.derby.impl.sql.compile.ResultColumnList.bindResultColumnsByName(Unknown Source)
 at org.apache.derby.impl.sql.compile.InsertNode.bindStatement(Unknown Source)
 at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
 at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
 at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown
Source)
 ... 75 more
 {code}

> Modifications to the metastore for catalogs
> -------------------------------------------
>
>                 Key: HIVE-18755
>                 URL: https://issues.apache.org/jira/browse/HIVE-18755
>             Project: Hive
>          Issue Type: Sub-task
>          Components: Metastore
>            Reporter: Alan Gates
>            Assignee: Alan Gates
>            Priority: Major
>              Labels: pull-request-available
>             Fix For: 3.0.0
>
>         Attachments: HIVE-18755.2.patch, HIVE-18755.3.patch, HIVE-18755.4.patch, HIVE-18755.final.patch,
HIVE-18755.nothrift, HIVE-18755.patch
>
>
> Step 1 of adding catalogs is to add support in the metastore.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message