[HIVE-28437] The Docker Image of apache/hive:4.0.0 does not document how to enable INFORMATION_SCHEMA database - ASF JIRA

Log work

Agile Board

Rank to Top

Rank to Bottom

Bulk Copy Attachments

Bulk Move Attachments

Add vote

Voters

Watch issue

Watchers

Create sub-task

Convert to sub-task

Move

Link

Clone

Labels

Update Comment Author

Replace String in Comment

Update Comment Visibility

Delete Comments

XML

Word

Printable

JSON

Details

Type: Improvement
Status: Open
Priority: Major
Resolution: Unresolved
Affects Version/s: None
Fix Version/s: None
Component/s: None
Labels:
None

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

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)

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.