Prerequisite: Build up a Hive server environment

We can follow the document to build up your Hive environment.

Apache Hive on Docker
- You need the following information:
  1. Hive server IP address: <hive-ip-address>
  2. Hive server port: <hive-port>
Please create a VM account to let the Hive client can login into the Hive server.
- You need the following information:
  1. Hive server VM username: <hive-server-username>
  2. Hive server VM password: <hive-server-password>

Step-by-step Method

Step 1: Build up Hive docker image.

Build up your own jupyter notebook docker image.

You can also use simon3458/jupyter-notebook-hive:0.1.0 docker image directly to create the notebook.
- Get the Dockerfile.
```
$ git clone <https://github.com/InfuseAI/showcase>
$ cd showcase/control-hive-in-notebook/
```
- Build up docker images:
```
$ docker build -t <workspace-name>/jupyter-notebook-hive:0.1.0 .
```
- Push to docker registry:
  
  If you want to push the docker image into the docker registry platform, then you need to use docker login or nerdctl login to login into the platform.
```
$ docker push <workspace-name>/jupyter-notebook-hive:0.1.0
```

Step 2: Create Hive jupyter environment and connect to the Hive server.

Create a Jupyter notebook.
Create a terminal.

Follow the command line to login to the Hive server.

jovyan@jupyter-phadmin:~$ beeline
log4j:WARN No appenders could be found for logger (org.apache.hadoop.util.Shell).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See <http://logging.apache.org/log4j/1.2/faq.html#noconfig> for more info.
Beeline version 2.3.9 by Apache Hive

beeline> !connect jdbc:hive2://<hive-ip-address>:<hive-port> 
Enter username for jdbc:hive2://<hive-ip-address>:<hive-port>: <hive-server-username> 
Enter password for jdbc:hive2://<hive-ip-address>:<hive-port>: <hive-server-password>

Connected to: Apache Hive (version 2.3.2)
Driver: Hive JDBC (version 2.3.9)
Transaction isolation: TRANSACTION_REPEATABLE_READ

0: jdbc:hive2://18.179.53.185:10000> show databases;
+----------------+
| database_name  |
+----------------+
| default        |
| testdb         |
+----------------+
2 rows selected (0.248 seconds)

Reference

How do I install the "Beeline" Hive client?

How do I install the "Beeline" Hive client?