Qiheng He created HIVE-28437:
--------------------------------
Summary: The Docker Image of apache/hive:4.0.0 does not document
how to enable INFORMATION_SCHEMA tables
Key: HIVE-28437
URL: https://issues.apache.org/jira/browse/HIVE-28437
Project: Hive
Issue Type: Improvement
Reporter: Qiheng He
- 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)
