question whats the difference between beeline and hive in Archives of Support Questions (Read Only)

whats the difference between beeline and hive

aliyesami — Tue, 03 Jan 2017 23:51:48 GMT

I am not sure I understand why would I use beeline instead of hive , can someone explain ?

thanks

Re: whats the difference between beeline and hive

divakarreddy_a — Wed, 04 Jan 2017 00:03:14 GMT

@Sami Ahmad

I hope below link will help to understand the difference between beeline and hive

https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.2/bk_dataintegration/content/beeline-vs-hive-cli.html

Re: whats the difference between beeline and hive

SQLShaw — Wed, 04 Jan 2017 00:43:46 GMT

@Sami Ahmad

You'll want to use beeline going forward since the Hive CLI will be deprecated. Beeline's JDBC connection provides for a higher level of security than the Hive CLI.

Re: whats the difference between beeline and hive

dvillarreal — Wed, 04 Jan 2017 06:46:41 GMT

You may find this useful as well for future. https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients Also, be advised ranger only works with hiveserver2.