[2010-06-04 09:22:11,817] ERROR (Log4JLogger.java:115) - Error thrown executing ALTER TABLE COLUMNS ADD TYPE_NAME varchar(128) NOT NULL : Cannot find the object "COLUMNS" because it does not exist or you do not have permissions. com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "COLUMNS" because it does not exist or you do not have permissions. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:786) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:685) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:658) at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730) at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:681) at org.datanucleus.store.rdbms.table.TableImpl.validateColumns(TableImpl.java:261) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:2794) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:2595) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2241) at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113) at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:994) at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:960) at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:691) at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:358) at org.datanucleus.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1344) at org.datanucleus.ObjectManagerImpl.getExtent(ObjectManagerImpl.java:3736) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compileCandidates(JDOQLQueryCompiler.java:411) at org.datanucleus.store.rdbms.query.QueryCompiler.executionCompile(QueryCompiler.java:312) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compile(JDOQLQueryCompiler.java:225) at org.datanucleus.store.rdbms.query.JDOQLQuery.compileInternal(JDOQLQuery.java:174) at org.datanucleus.store.query.Query.executeQuery(Query.java:1443) 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.getTable(ObjectStore.java:494) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_table(HiveMetaStore.java:397) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.drop_table(HiveMetaStore.java:353) at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.dropTable(HiveMetaStoreClient.java:340) at org.apache.hadoop.hive.ql.metadata.Hive.dropTable(Hive.java:308) at org.apache.hadoop.hive.ql.metadata.Hive.dropTable(Hive.java:293) at com.contextweb.hive.lookup.LookupDumper.createTable(LookupDumper.java:179) at com.contextweb.hive.lookup.LookupDumper.execute(LookupDumper.java:122) at com.contextweb.hive.cli.QueryCommand.runImpl(QueryCommand.java:142) at com.contextweb.hive.cli.HiveSessionAwareCommand.run(HiveSessionAwareCommand.java:48) at com.contextweb.hive.cli.Launcher.exec(Launcher.java:78) at com.contextweb.hive.cli.Launcher.main(Launcher.java:46) [2010-06-04 09:22:12,314] ERROR (Log4JLogger.java:115) - An exception was thrown while adding/validating class(es) : Cannot find the object "COLUMNS" because it does not exist or you do not have permissions. com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "COLUMNS" because it does not exist or you do not have permissions. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:786) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:685) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:658) at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730) at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:681) at org.datanucleus.store.rdbms.table.TableImpl.validateColumns(TableImpl.java:261) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:2794) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:2595) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2241) at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113) at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:994) at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:960) at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:691) at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:358) at org.datanucleus.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1344) at org.datanucleus.ObjectManagerImpl.getExtent(ObjectManagerImpl.java:3736) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compileCandidates(JDOQLQueryCompiler.java:411) at org.datanucleus.store.rdbms.query.QueryCompiler.executionCompile(QueryCompiler.java:312) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compile(JDOQLQueryCompiler.java:225) at org.datanucleus.store.rdbms.query.JDOQLQuery.compileInternal(JDOQLQuery.java:174) at org.datanucleus.store.query.Query.executeQuery(Query.java:1443) 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.getTable(ObjectStore.java:494) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_table(HiveMetaStore.java:397) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.drop_table(HiveMetaStore.java:353) at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.dropTable(HiveMetaStoreClient.java:340) at org.apache.hadoop.hive.ql.metadata.Hive.dropTable(Hive.java:308) at org.apache.hadoop.hive.ql.metadata.Hive.dropTable(Hive.java:293) at com.contextweb.hive.lookup.LookupDumper.createTable(LookupDumper.java:179) at com.contextweb.hive.lookup.LookupDumper.execute(LookupDumper.java:122) at com.contextweb.hive.cli.QueryCommand.runImpl(QueryCommand.java:142) at com.contextweb.hive.cli.HiveSessionAwareCommand.run(HiveSessionAwareCommand.java:48) at com.contextweb.hive.cli.Launcher.exec(Launcher.java:78) at com.contextweb.hive.cli.Launcher.main(Launcher.java:46) [2010-06-04 09:22:12,319] ERROR (Log4JLogger.java:115) - An exception was thrown while adding/validating class(es) : Cannot find the object "COLUMNS" because it does not exist or you do not have permissions. com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "COLUMNS" because it does not exist or you do not have permissions. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:786) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:685) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:658) at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730) at org.datanucleus.store.rdbms.table.TableImpl.createForeignKeys(TableImpl.java:529) at org.datanucleus.store.rdbms.table.TableImpl.validateForeignKeys(TableImpl.java:473) at org.datanucleus.store.rdbms.table.TableImpl.validateConstraints(TableImpl.java:399) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:2865) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:2595) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2241) at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113) at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:994) at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:960) at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:691) at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:358) at org.datanucleus.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1344) at org.datanucleus.ObjectManagerImpl.getExtent(ObjectManagerImpl.java:3736) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compileCandidates(JDOQLQueryCompiler.java:411) at org.datanucleus.store.rdbms.query.QueryCompiler.executionCompile(QueryCompiler.java:312) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compile(JDOQLQueryCompiler.java:225) at org.datanucleus.store.rdbms.query.JDOQLQuery.compileInternal(JDOQLQuery.java:174) at org.datanucleus.store.query.Query.executeQuery(Query.java:1443) 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.getTable(ObjectStore.java:494) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_table(HiveMetaStore.java:397) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.drop_table(HiveMetaStore.java:353) at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.dropTable(HiveMetaStoreClient.java:340) at org.apache.hadoop.hive.ql.metadata.Hive.dropTable(Hive.java:308) at org.apache.hadoop.hive.ql.metadata.Hive.dropTable(Hive.java:293) at com.contextweb.hive.lookup.LookupDumper.createTable(LookupDumper.java:179) at com.contextweb.hive.lookup.LookupDumper.execute(LookupDumper.java:122) at com.contextweb.hive.cli.QueryCommand.runImpl(QueryCommand.java:142) at com.contextweb.hive.cli.HiveSessionAwareCommand.run(HiveSessionAwareCommand.java:48) at com.contextweb.hive.cli.Launcher.exec(Launcher.java:78) at com.contextweb.hive.cli.Launcher.main(Launcher.java:46) [2010-06-04 09:22:12,323] ERROR (Log4JLogger.java:115) - An exception was thrown while adding/validating class(es) : Cannot find the object "COLUMNS" because it does not exist or you do not have permissions. com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "COLUMNS" because it does not exist or you do not have permissions. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:786) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:685) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:658) at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730) at org.datanucleus.store.rdbms.table.TableImpl.createIndices(TableImpl.java:650) at org.datanucleus.store.rdbms.table.TableImpl.validateIndices(TableImpl.java:595) at org.datanucleus.store.rdbms.table.TableImpl.validateConstraints(TableImpl.java:400) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:2865) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:2595) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2241) at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113) at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:994) at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:960) at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:691) at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:358) at org.datanucleus.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1344) at org.datanucleus.ObjectManagerImpl.getExtent(ObjectManagerImpl.java:3736) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compileCandidates(JDOQLQueryCompiler.java:411) at org.datanucleus.store.rdbms.query.QueryCompiler.executionCompile(QueryCompiler.java:312) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compile(JDOQLQueryCompiler.java:225) at org.datanucleus.store.rdbms.query.JDOQLQuery.compileInternal(JDOQLQuery.java:174) at org.datanucleus.store.query.Query.executeQuery(Query.java:1443) 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.getTable(ObjectStore.java:494) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_table(HiveMetaStore.java:397) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.drop_table(HiveMetaStore.java:353) at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.dropTable(HiveMetaStoreClient.java:340) at org.apache.hadoop.hive.ql.metadata.Hive.dropTable(Hive.java:308) at org.apache.hadoop.hive.ql.metadata.Hive.dropTable(Hive.java:293) at com.contextweb.hive.lookup.LookupDumper.createTable(LookupDumper.java:179) at com.contextweb.hive.lookup.LookupDumper.execute(LookupDumper.java:122) at com.contextweb.hive.cli.QueryCommand.runImpl(QueryCommand.java:142) at com.contextweb.hive.cli.HiveSessionAwareCommand.run(HiveSessionAwareCommand.java:48) at com.contextweb.hive.cli.Launcher.exec(Launcher.java:78) at com.contextweb.hive.cli.Launcher.main(Launcher.java:46) [2010-06-04 09:22:12,323] ERROR (Log4JLogger.java:115) - An exception was thrown while adding/validating class(es) : Cannot find the object "SORT_COLS" because it does not exist or you do not have permissions. com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "SORT_COLS" because it does not exist or you do not have permissions. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:786) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:685) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:658) at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730) at org.datanucleus.store.rdbms.table.TableImpl.createForeignKeys(TableImpl.java:529) at org.datanucleus.store.rdbms.table.TableImpl.createConstraints(TableImpl.java:431) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:2860) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:2595) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2241) at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113) at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:994) at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:960) at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:691) at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:358) at org.datanucleus.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1344) at org.datanucleus.ObjectManagerImpl.getExtent(ObjectManagerImpl.java:3736) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compileCandidates(JDOQLQueryCompiler.java:411) at org.datanucleus.store.rdbms.query.QueryCompiler.executionCompile(QueryCompiler.java:312) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compile(JDOQLQueryCompiler.java:225) at org.datanucleus.store.rdbms.query.JDOQLQuery.compileInternal(JDOQLQuery.java:174) at org.datanucleus.store.query.Query.executeQuery(Query.java:1443) 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.getTable(ObjectStore.java:494) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_table(HiveMetaStore.java:397) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.drop_table(HiveMetaStore.java:353) at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.dropTable(HiveMetaStoreClient.java:340) at org.apache.hadoop.hive.ql.metadata.Hive.dropTable(Hive.java:308) at org.apache.hadoop.hive.ql.metadata.Hive.dropTable(Hive.java:293) at com.contextweb.hive.lookup.LookupDumper.createTable(LookupDumper.java:179) at com.contextweb.hive.lookup.LookupDumper.execute(LookupDumper.java:122) at com.contextweb.hive.cli.QueryCommand.runImpl(QueryCommand.java:142) at com.contextweb.hive.cli.HiveSessionAwareCommand.run(HiveSessionAwareCommand.java:48) at com.contextweb.hive.cli.Launcher.exec(Launcher.java:78) at com.contextweb.hive.cli.Launcher.main(Launcher.java:46) [2010-06-04 09:22:12,332] ERROR (Log4JLogger.java:115) - An exception was thrown while adding/validating class(es) : Cannot find the object "SORT_COLS" because it does not exist or you do not have permissions. com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "SORT_COLS" because it does not exist or you do not have permissions. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:786) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:685) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:658) at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730) at org.datanucleus.store.rdbms.table.TableImpl.createIndices(TableImpl.java:650) at org.datanucleus.store.rdbms.table.TableImpl.createConstraints(TableImpl.java:432) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:2860) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:2595) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2241) at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113) at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:994) at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:960) at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:691) at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:358) at org.datanucleus.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1344) at org.datanucleus.ObjectManagerImpl.getExtent(ObjectManagerImpl.java:3736) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compileCandidates(JDOQLQueryCompiler.java:411) at org.datanucleus.store.rdbms.query.QueryCompiler.executionCompile(QueryCompiler.java:312) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compile(JDOQLQueryCompiler.java:225) at org.datanucleus.store.rdbms.query.JDOQLQuery.compileInternal(JDOQLQuery.java:174) at org.datanucleus.store.query.Query.executeQuery(Query.java:1443) 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.getTable(ObjectStore.java:494) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_table(HiveMetaStore.java:397) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.drop_table(HiveMetaStore.java:353) at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.dropTable(HiveMetaStoreClient.java:340) at org.apache.hadoop.hive.ql.metadata.Hive.dropTable(Hive.java:308) at org.apache.hadoop.hive.ql.metadata.Hive.dropTable(Hive.java:293) at com.contextweb.hive.lookup.LookupDumper.createTable(LookupDumper.java:179) at com.contextweb.hive.lookup.LookupDumper.execute(LookupDumper.java:122) at com.contextweb.hive.cli.QueryCommand.runImpl(QueryCommand.java:142) at com.contextweb.hive.cli.HiveSessionAwareCommand.run(HiveSessionAwareCommand.java:48) at com.contextweb.hive.cli.Launcher.exec(Launcher.java:78) at com.contextweb.hive.cli.Launcher.main(Launcher.java:46) [2010-06-04 09:22:12,333] ERROR (Log4JLogger.java:115) - An exception was thrown while adding/validating class(es) : Cannot find the object "TABLE_PARAMS" because it does not exist or you do not have permissions. com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "TABLE_PARAMS" because it does not exist or you do not have permissions. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:786) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:685) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:658) at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730) at org.datanucleus.store.rdbms.table.TableImpl.createForeignKeys(TableImpl.java:529) at org.datanucleus.store.rdbms.table.TableImpl.createConstraints(TableImpl.java:431) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:2860) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:2595) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2241) at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113) at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:994) at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:960) at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:691) at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:358) at org.datanucleus.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1344) at org.datanucleus.ObjectManagerImpl.getExtent(ObjectManagerImpl.java:3736) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compileCandidates(JDOQLQueryCompiler.java:411) at org.datanucleus.store.rdbms.query.QueryCompiler.executionCompile(QueryCompiler.java:312) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compile(JDOQLQueryCompiler.java:225) at org.datanucleus.store.rdbms.query.JDOQLQuery.compileInternal(JDOQLQuery.java:174) at org.datanucleus.store.query.Query.executeQuery(Query.java:1443) 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.getTable(ObjectStore.java:494) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_table(HiveMetaStore.java:397) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.drop_table(HiveMetaStore.java:353) at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.dropTable(HiveMetaStoreClient.java:340) at org.apache.hadoop.hive.ql.metadata.Hive.dropTable(Hive.java:308) at org.apache.hadoop.hive.ql.metadata.Hive.dropTable(Hive.java:293) at com.contextweb.hive.lookup.LookupDumper.createTable(LookupDumper.java:179) at com.contextweb.hive.lookup.LookupDumper.execute(LookupDumper.java:122) at com.contextweb.hive.cli.QueryCommand.runImpl(QueryCommand.java:142) at com.contextweb.hive.cli.HiveSessionAwareCommand.run(HiveSessionAwareCommand.java:48) at com.contextweb.hive.cli.Launcher.exec(Launcher.java:78) at com.contextweb.hive.cli.Launcher.main(Launcher.java:46) [2010-06-04 09:22:12,337] ERROR (Log4JLogger.java:115) - An exception was thrown while adding/validating class(es) : Cannot find the object "TABLE_PARAMS" because it does not exist or you do not have permissions. com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "TABLE_PARAMS" because it does not exist or you do not have permissions. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:786) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:685) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:658) at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730) at org.datanucleus.store.rdbms.table.TableImpl.createIndices(TableImpl.java:650) at org.datanucleus.store.rdbms.table.TableImpl.createConstraints(TableImpl.java:432) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:2860) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:2595) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2241) at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113) at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:994) at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:960) at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:691) at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:358) at org.datanucleus.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1344) at org.datanucleus.ObjectManagerImpl.getExtent(ObjectManagerImpl.java:3736) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compileCandidates(JDOQLQueryCompiler.java:411) at org.datanucleus.store.rdbms.query.QueryCompiler.executionCompile(QueryCompiler.java:312) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compile(JDOQLQueryCompiler.java:225) at org.datanucleus.store.rdbms.query.JDOQLQuery.compileInternal(JDOQLQuery.java:174) at org.datanucleus.store.query.Query.executeQuery(Query.java:1443) 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.getTable(ObjectStore.java:494) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_table(HiveMetaStore.java:397) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.drop_table(HiveMetaStore.java:353) at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.dropTable(HiveMetaStoreClient.java:340) at org.apache.hadoop.hive.ql.metadata.Hive.dropTable(Hive.java:308) at org.apache.hadoop.hive.ql.metadata.Hive.dropTable(Hive.java:293) at com.contextweb.hive.lookup.LookupDumper.createTable(LookupDumper.java:179) at com.contextweb.hive.lookup.LookupDumper.execute(LookupDumper.java:122) at com.contextweb.hive.cli.QueryCommand.runImpl(QueryCommand.java:142) at com.contextweb.hive.cli.HiveSessionAwareCommand.run(HiveSessionAwareCommand.java:48) at com.contextweb.hive.cli.Launcher.exec(Launcher.java:78) at com.contextweb.hive.cli.Launcher.main(Launcher.java:46) [2010-06-04 09:22:12,337] ERROR (Log4JLogger.java:115) - An exception was thrown while adding/validating class(es) : Cannot find the object "SERDE_PARAMS" because it does not exist or you do not have permissions. com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "SERDE_PARAMS" because it does not exist or you do not have permissions. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:786) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:685) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:658) at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730) at org.datanucleus.store.rdbms.table.TableImpl.createForeignKeys(TableImpl.java:529) at org.datanucleus.store.rdbms.table.TableImpl.createConstraints(TableImpl.java:431) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:2860) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:2595) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2241) at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113) at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:994) at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:960) at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:691) at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:358) at org.datanucleus.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1344) at org.datanucleus.ObjectManagerImpl.getExtent(ObjectManagerImpl.java:3736) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compileCandidates(JDOQLQueryCompiler.java:411) at org.datanucleus.store.rdbms.query.QueryCompiler.executionCompile(QueryCompiler.java:312) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compile(JDOQLQueryCompiler.java:225) at org.datanucleus.store.rdbms.query.JDOQLQuery.compileInternal(JDOQLQuery.java:174) at org.datanucleus.store.query.Query.executeQuery(Query.java:1443) 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.getTable(ObjectStore.java:494) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_table(HiveMetaStore.java:397) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.drop_table(HiveMetaStore.java:353) at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.dropTable(HiveMetaStoreClient.java:340) at org.apache.hadoop.hive.ql.metadata.Hive.dropTable(Hive.java:308) at org.apache.hadoop.hive.ql.metadata.Hive.dropTable(Hive.java:293) at com.contextweb.hive.lookup.LookupDumper.createTable(LookupDumper.java:179) at com.contextweb.hive.lookup.LookupDumper.execute(LookupDumper.java:122) at com.contextweb.hive.cli.QueryCommand.runImpl(QueryCommand.java:142) at com.contextweb.hive.cli.HiveSessionAwareCommand.run(HiveSessionAwareCommand.java:48) at com.contextweb.hive.cli.Launcher.exec(Launcher.java:78) at com.contextweb.hive.cli.Launcher.main(Launcher.java:46) [2010-06-04 09:22:12,349] ERROR (Log4JLogger.java:115) - An exception was thrown while adding/validating class(es) : Cannot find the object "SERDE_PARAMS" because it does not exist or you do not have permissions. com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "SERDE_PARAMS" because it does not exist or you do not have permissions. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:786) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:685) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:658) at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730) at org.datanucleus.store.rdbms.table.TableImpl.createIndices(TableImpl.java:650) at org.datanucleus.store.rdbms.table.TableImpl.createConstraints(TableImpl.java:432) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:2860) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:2595) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2241) at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113) at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:994) at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:960) at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:691) at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:358) at org.datanucleus.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1344) at org.datanucleus.ObjectManagerImpl.getExtent(ObjectManagerImpl.java:3736) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compileCandidates(JDOQLQueryCompiler.java:411) at org.datanucleus.store.rdbms.query.QueryCompiler.executionCompile(QueryCompiler.java:312) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compile(JDOQLQueryCompiler.java:225) at org.datanucleus.store.rdbms.query.JDOQLQuery.compileInternal(JDOQLQuery.java:174) at org.datanucleus.store.query.Query.executeQuery(Query.java:1443) 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.getTable(ObjectStore.java:494) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_table(HiveMetaStore.java:397) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.drop_table(HiveMetaStore.java:353) at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.dropTable(HiveMetaStoreClient.java:340) at org.apache.hadoop.hive.ql.metadata.Hive.dropTable(Hive.java:308) at org.apache.hadoop.hive.ql.metadata.Hive.dropTable(Hive.java:293) at com.contextweb.hive.lookup.LookupDumper.createTable(LookupDumper.java:179) at com.contextweb.hive.lookup.LookupDumper.execute(LookupDumper.java:122) at com.contextweb.hive.cli.QueryCommand.runImpl(QueryCommand.java:142) at com.contextweb.hive.cli.HiveSessionAwareCommand.run(HiveSessionAwareCommand.java:48) at com.contextweb.hive.cli.Launcher.exec(Launcher.java:78) at com.contextweb.hive.cli.Launcher.main(Launcher.java:46) [2010-06-04 09:22:12,356] ERROR (Log4JLogger.java:115) - An exception was thrown while adding/validating class(es) : Cannot find the object "BUCKETING_COLS" because it does not exist or you do not have permissions. com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "BUCKETING_COLS" because it does not exist or you do not have permissions. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:786) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:685) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:658) at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730) at org.datanucleus.store.rdbms.table.TableImpl.createForeignKeys(TableImpl.java:529) at org.datanucleus.store.rdbms.table.TableImpl.createConstraints(TableImpl.java:431) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:2860) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:2595) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2241) at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113) at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:994) at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:960) at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:691) at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:358) at org.datanucleus.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1344) at org.datanucleus.ObjectManagerImpl.getExtent(ObjectManagerImpl.java:3736) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compileCandidates(JDOQLQueryCompiler.java:411) at org.datanucleus.store.rdbms.query.QueryCompiler.executionCompile(QueryCompiler.java:312) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compile(JDOQLQueryCompiler.java:225) at org.datanucleus.store.rdbms.query.JDOQLQuery.compileInternal(JDOQLQuery.java:174) at org.datanucleus.store.query.Query.executeQuery(Query.java:1443) 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.getTable(ObjectStore.java:494) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_table(HiveMetaStore.java:397) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.drop_table(HiveMetaStore.java:353) at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.dropTable(HiveMetaStoreClient.java:340) at org.apache.hadoop.hive.ql.metadata.Hive.dropTable(Hive.java:308) at org.apache.hadoop.hive.ql.metadata.Hive.dropTable(Hive.java:293) at com.contextweb.hive.lookup.LookupDumper.createTable(LookupDumper.java:179) at com.contextweb.hive.lookup.LookupDumper.execute(LookupDumper.java:122) at com.contextweb.hive.cli.QueryCommand.runImpl(QueryCommand.java:142) at com.contextweb.hive.cli.HiveSessionAwareCommand.run(HiveSessionAwareCommand.java:48) at com.contextweb.hive.cli.Launcher.exec(Launcher.java:78) at com.contextweb.hive.cli.Launcher.main(Launcher.java:46) [2010-06-04 09:22:12,356] ERROR (Log4JLogger.java:115) - An exception was thrown while adding/validating class(es) : Cannot find the object "BUCKETING_COLS" because it does not exist or you do not have permissions. com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "BUCKETING_COLS" because it does not exist or you do not have permissions. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:786) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:685) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:658) at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730) at org.datanucleus.store.rdbms.table.TableImpl.createIndices(TableImpl.java:650) at org.datanucleus.store.rdbms.table.TableImpl.createConstraints(TableImpl.java:432) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:2860) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:2595) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2241) at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113) at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:994) at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:960) at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:691) at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:358) at org.datanucleus.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1344) at org.datanucleus.ObjectManagerImpl.getExtent(ObjectManagerImpl.java:3736) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compileCandidates(JDOQLQueryCompiler.java:411) at org.datanucleus.store.rdbms.query.QueryCompiler.executionCompile(QueryCompiler.java:312) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compile(JDOQLQueryCompiler.java:225) at org.datanucleus.store.rdbms.query.JDOQLQuery.compileInternal(JDOQLQuery.java:174) at org.datanucleus.store.query.Query.executeQuery(Query.java:1443) 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.getTable(ObjectStore.java:494) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_table(HiveMetaStore.java:397) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.drop_table(HiveMetaStore.java:353) at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.dropTable(HiveMetaStoreClient.java:340) at org.apache.hadoop.hive.ql.metadata.Hive.dropTable(Hive.java:308) at org.apache.hadoop.hive.ql.metadata.Hive.dropTable(Hive.java:293) at com.contextweb.hive.lookup.LookupDumper.createTable(LookupDumper.java:179) at com.contextweb.hive.lookup.LookupDumper.execute(LookupDumper.java:122) at com.contextweb.hive.cli.QueryCommand.runImpl(QueryCommand.java:142) at com.contextweb.hive.cli.HiveSessionAwareCommand.run(HiveSessionAwareCommand.java:48) at com.contextweb.hive.cli.Launcher.exec(Launcher.java:78) at com.contextweb.hive.cli.Launcher.main(Launcher.java:46) [2010-06-04 09:22:12,385] ERROR (Log4JLogger.java:115) - An exception was thrown while adding/validating class(es) : Cannot find the object "SD_PARAMS" because it does not exist or you do not have permissions. com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "SD_PARAMS" because it does not exist or you do not have permissions. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:786) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:685) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:658) at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730) at org.datanucleus.store.rdbms.table.TableImpl.createForeignKeys(TableImpl.java:529) at org.datanucleus.store.rdbms.table.TableImpl.createConstraints(TableImpl.java:431) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:2860) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:2595) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2241) at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113) at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:994) at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:960) at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:691) at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:358) at org.datanucleus.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1344) at org.datanucleus.ObjectManagerImpl.getExtent(ObjectManagerImpl.java:3736) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compileCandidates(JDOQLQueryCompiler.java:411) at org.datanucleus.store.rdbms.query.QueryCompiler.executionCompile(QueryCompiler.java:312) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compile(JDOQLQueryCompiler.java:225) at org.datanucleus.store.rdbms.query.JDOQLQuery.compileInternal(JDOQLQuery.java:174) at org.datanucleus.store.query.Query.executeQuery(Query.java:1443) 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.getTable(ObjectStore.java:494) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_table(HiveMetaStore.java:397) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.drop_table(HiveMetaStore.java:353) at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.dropTable(HiveMetaStoreClient.java:340) at org.apache.hadoop.hive.ql.metadata.Hive.dropTable(Hive.java:308) at org.apache.hadoop.hive.ql.metadata.Hive.dropTable(Hive.java:293) at com.contextweb.hive.lookup.LookupDumper.createTable(LookupDumper.java:179) at com.contextweb.hive.lookup.LookupDumper.execute(LookupDumper.java:122) at com.contextweb.hive.cli.QueryCommand.runImpl(QueryCommand.java:142) at com.contextweb.hive.cli.HiveSessionAwareCommand.run(HiveSessionAwareCommand.java:48) at com.contextweb.hive.cli.Launcher.exec(Launcher.java:78) at com.contextweb.hive.cli.Launcher.main(Launcher.java:46) [2010-06-04 09:22:12,389] ERROR (Log4JLogger.java:115) - An exception was thrown while adding/validating class(es) : Cannot find the object "SD_PARAMS" because it does not exist or you do not have permissions. com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "SD_PARAMS" because it does not exist or you do not have permissions. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:786) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:685) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:658) at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730) at org.datanucleus.store.rdbms.table.TableImpl.createIndices(TableImpl.java:650) at org.datanucleus.store.rdbms.table.TableImpl.createConstraints(TableImpl.java:432) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:2860) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:2595) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2241) at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113) at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:994) at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:960) at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:691) at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:358) at org.datanucleus.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1344) at org.datanucleus.ObjectManagerImpl.getExtent(ObjectManagerImpl.java:3736) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compileCandidates(JDOQLQueryCompiler.java:411) at org.datanucleus.store.rdbms.query.QueryCompiler.executionCompile(QueryCompiler.java:312) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compile(JDOQLQueryCompiler.java:225) at org.datanucleus.store.rdbms.query.JDOQLQuery.compileInternal(JDOQLQuery.java:174) at org.datanucleus.store.query.Query.executeQuery(Query.java:1443) 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.getTable(ObjectStore.java:494) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_table(HiveMetaStore.java:397) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.drop_table(HiveMetaStore.java:353) at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.dropTable(HiveMetaStoreClient.java:340) at org.apache.hadoop.hive.ql.metadata.Hive.dropTable(Hive.java:308) at org.apache.hadoop.hive.ql.metadata.Hive.dropTable(Hive.java:293) at com.contextweb.hive.lookup.LookupDumper.createTable(LookupDumper.java:179) at com.contextweb.hive.lookup.LookupDumper.execute(LookupDumper.java:122) at com.contextweb.hive.cli.QueryCommand.runImpl(QueryCommand.java:142) at com.contextweb.hive.cli.HiveSessionAwareCommand.run(HiveSessionAwareCommand.java:48) at com.contextweb.hive.cli.Launcher.exec(Launcher.java:78) at com.contextweb.hive.cli.Launcher.main(Launcher.java:46) [2010-06-04 09:22:12,389] ERROR (Log4JLogger.java:115) - An exception was thrown while adding/validating class(es) : Cannot find the object "PARTITION_KEYS" because it does not exist or you do not have permissions. com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "PARTITION_KEYS" because it does not exist or you do not have permissions. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:786) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:685) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:658) at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730) at org.datanucleus.store.rdbms.table.TableImpl.createForeignKeys(TableImpl.java:529) at org.datanucleus.store.rdbms.table.TableImpl.createConstraints(TableImpl.java:431) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:2860) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:2595) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2241) at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113) at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:994) at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:960) at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:691) at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:358) at org.datanucleus.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1344) at org.datanucleus.ObjectManagerImpl.getExtent(ObjectManagerImpl.java:3736) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compileCandidates(JDOQLQueryCompiler.java:411) at org.datanucleus.store.rdbms.query.QueryCompiler.executionCompile(QueryCompiler.java:312) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compile(JDOQLQueryCompiler.java:225) at org.datanucleus.store.rdbms.query.JDOQLQuery.compileInternal(JDOQLQuery.java:174) at org.datanucleus.store.query.Query.executeQuery(Query.java:1443) 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.getTable(ObjectStore.java:494) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_table(HiveMetaStore.java:397) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.drop_table(HiveMetaStore.java:353) at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.dropTable(HiveMetaStoreClient.java:340) at org.apache.hadoop.hive.ql.metadata.Hive.dropTable(Hive.java:308) at org.apache.hadoop.hive.ql.metadata.Hive.dropTable(Hive.java:293) at com.contextweb.hive.lookup.LookupDumper.createTable(LookupDumper.java:179) at com.contextweb.hive.lookup.LookupDumper.execute(LookupDumper.java:122) at com.contextweb.hive.cli.QueryCommand.runImpl(QueryCommand.java:142) at com.contextweb.hive.cli.HiveSessionAwareCommand.run(HiveSessionAwareCommand.java:48) at com.contextweb.hive.cli.Launcher.exec(Launcher.java:78) at com.contextweb.hive.cli.Launcher.main(Launcher.java:46) [2010-06-04 09:22:12,418] ERROR (Log4JLogger.java:115) - An exception was thrown while adding/validating class(es) : Cannot find the object "PARTITION_KEYS" because it does not exist or you do not have permissions. com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "PARTITION_KEYS" because it does not exist or you do not have permissions. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:786) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:685) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:658) at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730) at org.datanucleus.store.rdbms.table.TableImpl.createIndices(TableImpl.java:650) at org.datanucleus.store.rdbms.table.TableImpl.createConstraints(TableImpl.java:432) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:2860) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:2595) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2241) at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113) at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:994) at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:960) at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:691) at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:358) at org.datanucleus.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1344) at org.datanucleus.ObjectManagerImpl.getExtent(ObjectManagerImpl.java:3736) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compileCandidates(JDOQLQueryCompiler.java:411) at org.datanucleus.store.rdbms.query.QueryCompiler.executionCompile(QueryCompiler.java:312) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compile(JDOQLQueryCompiler.java:225) at org.datanucleus.store.rdbms.query.JDOQLQuery.compileInternal(JDOQLQuery.java:174) at org.datanucleus.store.query.Query.executeQuery(Query.java:1443) 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.getTable(ObjectStore.java:494) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_table(HiveMetaStore.java:397) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.drop_table(HiveMetaStore.java:353) at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.dropTable(HiveMetaStoreClient.java:340) at org.apache.hadoop.hive.ql.metadata.Hive.dropTable(Hive.java:308) at org.apache.hadoop.hive.ql.metadata.Hive.dropTable(Hive.java:293) at com.contextweb.hive.lookup.LookupDumper.createTable(LookupDumper.java:179) at com.contextweb.hive.lookup.LookupDumper.execute(LookupDumper.java:122) at com.contextweb.hive.cli.QueryCommand.runImpl(QueryCommand.java:142) at com.contextweb.hive.cli.HiveSessionAwareCommand.run(HiveSessionAwareCommand.java:48) at com.contextweb.hive.cli.Launcher.exec(Launcher.java:78) at com.contextweb.hive.cli.Launcher.main(Launcher.java:46) [2010-06-04 09:22:12,441] ERROR (Log4JLogger.java:115) - Error thrown executing DROP TABLE PARTITION_KEYS : Cannot drop the table 'PARTITION_KEYS', because it does not exist or you do not have permission. com.microsoft.sqlserver.jdbc.SQLServerException: Cannot drop the table 'PARTITION_KEYS', because it does not exist or you do not have permission. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:786) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:685) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:658) at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730) at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:681) at org.datanucleus.store.rdbms.table.AbstractTable.drop(AbstractTable.java:422) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.rollbackSchemaCreation(RDBMSManager.java:3034) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:2640) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2241) at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113) at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:994) at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:960) at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:691) at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:358) at org.datanucleus.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1344) at org.datanucleus.ObjectManagerImpl.getExtent(ObjectManagerImpl.java:3736) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compileCandidates(JDOQLQueryCompiler.java:411) at org.datanucleus.store.rdbms.query.QueryCompiler.executionCompile(QueryCompiler.java:312) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compile(JDOQLQueryCompiler.java:225) at org.datanucleus.store.rdbms.query.JDOQLQuery.compileInternal(JDOQLQuery.java:174) at org.datanucleus.store.query.Query.executeQuery(Query.java:1443) 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.getTable(ObjectStore.java:494) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_table(HiveMetaStore.java:397) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.drop_table(HiveMetaStore.java:353) at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.dropTable(HiveMetaStoreClient.java:340) at org.apache.hadoop.hive.ql.metadata.Hive.dropTable(Hive.java:308) at org.apache.hadoop.hive.ql.metadata.Hive.dropTable(Hive.java:293) at com.contextweb.hive.lookup.LookupDumper.createTable(LookupDumper.java:179) at com.contextweb.hive.lookup.LookupDumper.execute(LookupDumper.java:122) at com.contextweb.hive.cli.QueryCommand.runImpl(QueryCommand.java:142) at com.contextweb.hive.cli.HiveSessionAwareCommand.run(HiveSessionAwareCommand.java:48) at com.contextweb.hive.cli.Launcher.exec(Launcher.java:78) at com.contextweb.hive.cli.Launcher.main(Launcher.java:46)