Overview of beeline

#1

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 beeline --help

Let us see some important beeline commands

!help
!sh
!script
!connect

  • Example to connect to Hive
    !connect jdbc:hive2://nn01.itversity.com:10000/training_retail

Enter OS username as username for now and hit enter for the password as we have not integrated with sentry.


Practice hive on state of the art Big Data cluster - https://labs.itversity.com
You can sign up for our courses on Udemy using $10 coupons - Udemy Coupons - Big Data Courses


0 Likes