@nirajp  Either way HIVE or Beeline you MUST provide username /password to authenticate to be able to execute any SQL statement against the DB. See below examples Hive CLI [hive@calgary ~]$ hive .......... SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] Connecting to jdbc:hive2://calgary.canada.ca:2181,ottawa.canada.ca:2181/default;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2 Enter username for jdbc:hive2://calgary.canada.ca:2181,ottawa.canada.ca:2181/default: hive Enter password for jdbc:hive2://calgary.canada.ca:2181,ottawa.canada.ca:2181/default: ****   Beeline Connection [hive@london ~]$ beeline Beeline version 1.2.1000.2.5.3.0-37 by Apache Hive beeline> ! connect jdbc:hive2://london.tesco.co.uk:10000/;principal=hive/london.tesco.co.uk@TESCO.CO.UK Connecting to jdbc:hive2://london.tesco.co.uk:10000/;principal=hive/london.tesco.co.uk@TESCO.CO.UK Enter username for jdbc:hive2://london.tesco.co.uk:10000/;principal=hive/london.tesco.co.uk@TESCO.CO.UK:xxxxx Enter password for jdbc:hive2://london.tesco.co.uk:10000/;principal=hive/london.tesco.co.uk@TESCO.CO.UK:xxxxx Connected to: Apache Hive (version 1.2.1000.2.5.3.0-37) Driver: Hive JDBC (version 1.2.1000.2.5.3.0-37) Transaction isolation: TRANSACTION_REPEATABLE_READ 0: jdbc:hive2://london.tesco.co.uk:10000/> show databases; +----------------+--+ | database_name | +----------------+--+ | default                   | | uxbribge               | | White_city          | +----------------+--+ 3 rows selected (2.863 seconds)   If you have ranger plugin enable for hive then you will have authorization centrally handles by Ranger. HTH    ... View more

for exporting table to another cluster, snapshot is the best method. https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.2/bk_hbase_snapshots_guide/content/ch_hbase_snapshots_chapter.html ... View more

Steps for installation  cd /root yum install git git clone https://github.com/hortonworks-gallery/ambari-zeppelin-service.git echo $VERSION cd /var/lib/ambari-server/resources/stacks/HDP/2.4/services/ mkdir ZEPPELIN mv /root/ambari-zeppelin-service/* /var/lib/ambari-server/resources/stacks/HDP/ 2.4/services/ZEPPELIN/ ambari-agent stop ambari-server restart ambari-agent start then Login to ambari  Add service----->>> Zeppelin Notebook And connect to https://zeppline-host:9995 And its works...!!!!!! ... View more