[ 
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)

Reply via email to