Let us understand another CLI which can be used to run Hive Queries.
- There is no authentication and authorization for Hive CLI
- Hive CLI is being deprecated and it is recommended to use beeline.
- Beeline uses JDBC and connects to Hive via HiveServer2
- We can integrate Beeline with Sentry for authentication and authorization.
- You can get help over beeline using
Let us see some important beeline commands
- Example to connect to Hive
Enter OS username as username for now and hit enter for the password as we have not integrated with sentry.