[ https://issues.apache.org/jira/browse/HIVE-28437?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Qiheng He updated HIVE-28437: ----------------------------- Description: - The Docker Image of *apache/hive:4.0.0* does not document how to enable *INFORMATION_SCHEMA* database. See [Setting Up Hive with Docker - Apache Hive - Apache Software Foundation|https://cwiki.apache.org/confluence/display/Hive/Setting+Up+Hive+with+Docker] . Apparently, the *INFORMATION_SCHEMA* database is not present in the HiveServer2 instance started by a command like {*}docker run -d -p 10000:10000 -p 10002:10002 --env SERVICE_NAME=hiveserver2 apache/hive:4.0.0{*}. This can be verified by executing *use INFORMATION_SCHEMA;* in dbeaver. {code:bash} org.jkiss.dbeaver.model.sql.DBSQLException: SQL 错误 [10072] [42000]: Error while compiling statement: FAILED: SemanticException [Error 10072]: Database does not exist: INFORMATION_SCHEMA at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:133) at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeStatement(SQLQueryJob.java:615) {code} - There are HIVE-16946 and HIVE-16941 that have not been closed, but the related issues do not involve the Docker Image scenario. It seems that it has never been documented how to use *schematool* in a Docker Image remotely. was: - The Docker Image of *apache/hive:4.0.0* does not document how to enable *INFORMATION_SCHEMA* database. See [Setting Up Hive with Docker - Apache Hive - Apache Software Foundation|https://cwiki.apache.org/confluence/display/Hive/Setting+Up+Hive+with+Docker] . Apparently, the *INFORMATION_SCHEMA* database is not present in the HiveServer2 instance started by a command like {*}docker run -d -p 10000:10000 -p 10002:10002 --env SERVICE_NAME=hiveserver2 apache/hive:4.0.0{*}. This can be verified by executing *use INFORMATION_SCHEMA;* in dbeaver. {code:bash} org.jkiss.dbeaver.model.sql.DBSQLException: SQL 错误 [10072] [42000]: Error while compiling statement: FAILED: SemanticException [Error 10072]: Database does not exist: INFORMATION_SCHEMA at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:133) at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeStatement(SQLQueryJob.java:615) {code} - There are HIVE-16946 and HIVE-16941 that have not been closed, but the related issues do not involve the Docker Image scenario. It seems that it has never been documented how to use schematool in a Docker Image remotely. > The Docker Image of apache/hive:4.0.0 does not document how to enable > INFORMATION_SCHEMA database > ------------------------------------------------------------------------------------------------- > > Key: HIVE-28437 > URL: https://issues.apache.org/jira/browse/HIVE-28437 > Project: Hive > Issue Type: Improvement > Reporter: Qiheng He > Priority: Major > > - The Docker Image of *apache/hive:4.0.0* does not document how to enable > *INFORMATION_SCHEMA* database. See [Setting Up Hive with Docker - Apache Hive > - Apache Software > Foundation|https://cwiki.apache.org/confluence/display/Hive/Setting+Up+Hive+with+Docker] > . Apparently, the *INFORMATION_SCHEMA* database is not present in the > HiveServer2 instance started by a command like {*}docker run -d -p > 10000:10000 -p 10002:10002 --env SERVICE_NAME=hiveserver2 > apache/hive:4.0.0{*}. This can be verified by executing *use > INFORMATION_SCHEMA;* in dbeaver. > {code:bash} > org.jkiss.dbeaver.model.sql.DBSQLException: SQL 错误 [10072] [42000]: Error > while compiling statement: FAILED: SemanticException [Error 10072]: Database > does not exist: INFORMATION_SCHEMA > at > org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:133) > at > org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeStatement(SQLQueryJob.java:615) > {code} > - There are HIVE-16946 and HIVE-16941 that have not been closed, but the > related issues do not involve the Docker Image scenario. It seems that it has > never been documented how to use *schematool* in a Docker Image remotely. -- This message was sent by Atlassian Jira (v8.20.10#820010)