dengzhhu653 commented on code in PR #5629:
URL: https://github.com/apache/hive/pull/5629#discussion_r1946175399
##########
packaging/src/docker/README.md:
##########
@@ -210,3 +210,14 @@ docker compose down
select count(distinct a) from hive_example;
select sum(b) from hive_example;
```
+
+#### Hive Schema Tool
+
+`Hive Schema Tool` is located in the Docker Image at
`/opt/hive/bin/schematool`.
+Possible use cases are as follows,
+
+```shell
+docker run -d --env SERVICE_NAME=hiveserver2 --name hive4
apache/hive:${HIVE_VERSION}
+docker exec -it hive4 /bin/bash
+/opt/hive/bin/schematool -info -dbType hive -metaDbType derby -url
jdbc:hive2://localhost:10000/default
Review Comment:
In order for HiveServer2 to read the `sys` table, the HiveServer2 needs to
configure the properties to connect the backing db:
```
javax.jdo.option.ConnectionURL
javax.jdo.option.ConnectionDriverName
javax.jdo.option.ConnectionUserName
javax.jdo.option.ConnectionPassword
```
otherwise though we can create those tables, still we cann't get the real
info that the HMS stores, as it goes to the embedded derby to when querying the
table.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org
For additional commands, e-mail: gitbox-h...@hive.apache.org
