Section 6:58. Running Hive Queries using Beeline

To run Hive queries using Beeline, you can follow these steps:

1. Open a terminal window and enter the command “beeline”.
2. In Hive, the “-u” option is used to specify the JDBC URL for connecting to the Hive server. This option is used in conjunction with the Hive CLI or with other Hive tools such as Beeline.
3. if you want to connect to the same Hive server using Beeline, you can use the following command:

$ beeline -u jdbc:hive2://localhost:10000/default

This command will start a Beeline session and connect to the Hive server using the specified JDBC URL.

In general, the “-u” option is a convenient way to specify the JDBC URL when using Hive or Beeline. It allows you to connect to Hive servers running on different hosts or with different configuration settings, and can be used to customize your Hive session to your specific needs.