{"id":4759,"date":"2019-09-02T10:32:41","date_gmt":"2019-09-02T14:32:41","guid":{"rendered":"https:\/\/microdevsys.com\/wp\/?p=4759"},"modified":"2019-09-02T10:32:41","modified_gmt":"2019-09-02T14:32:41","slug":"how-do-i-connect-to-hiveserver2-hs2-through-beeline","status":"publish","type":"post","link":"https:\/\/microdevsys.com\/wp\/how-do-i-connect-to-hiveserver2-hs2-through-beeline\/","title":{"rendered":"How do I connect to HiveServer2 (HS2) through beeline"},"content":{"rendered":"

\n\tHow do I connect to HiveServer2 (HS2) through beeline:\n<\/p>\n

\n\tbeeline> !connect jdbc:hive2:\/\/cm-r01en01.mws.mds.xyz:10000\/default;principal=hive\/cm-r01en01.mws.mds.xyz@MWS.MDS.XYZ<\/strong>
\n\tConnecting to jdbc:hive2:\/\/cm-r01en01.mws.mds.xyz:10000\/default;principal=hive\/cm-r01en01.mws.mds.xyz@MWS.MDS.XYZ
\n\tConnected to: Apache Hive (version 2.1.1-cdh6.3.0)
\n\tDriver: Hive JDBC (version 2.1.1-cdh6.3.0)
\n\tTransaction isolation: TRANSACTION_REPEATABLE_READ
\n\t0: jdbc:hive2:\/\/cm-r01en01.mws.mds.xyz:10000\/>
\n\t0: jdbc:hive2:\/\/cm-r01en01.mws.mds.xyz:10000\/>
\n\t0: jdbc:hive2:\/\/cm-r01en01.mws.mds.xyz:10000\/> show tables;
\n\tINFO  : Compiling command(queryId=hive_20190902102937_4ef97c5b-19ff-47b8-be81-dacb2edeece0): show tables
\n\tINFO  : Semantic Analysis Completed
\n\tINFO  : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:tab_name, type:string, comment:from deserializer)], properties:null)
\n\tINFO  : Completed compiling command(queryId=hive_20190902102937_4ef97c5b-19ff-47b8-be81-dacb2edeece0); Time taken: 2.67 seconds
\n\tINFO  : Executing command(queryId=hive_20190902102937_4ef97c5b-19ff-47b8-be81-dacb2edeece0): show tables
\n\tINFO  : Starting task [Stage-0:DDL] in serial mode
\n\tINFO  : Completed executing command(queryId=hive_20190902102937_4ef97c5b-19ff-47b8-be81-dacb2edeece0); Time taken: 1.333 seconds
\n\tINFO  : OK
\n\t+———–+
\n\t| tab_name  |
\n\t+———–+
\n\t+———–+
\n\tNo rows selected (5.048 seconds)
\n\t0: jdbc:hive2:\/\/cm-r01en01.mws.mds.xyz:10000\/> show databases;
\n\tINFO  : Compiling command(queryId=hive_20190902103034_18cb927f-0ab7-4a2d-b311-206b6ebb2cc2): show databases
\n\tINFO  : Semantic Analysis Completed
\n\tINFO  : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:database_name, type:string, comment:from deserializer)], properties:null)
\n\tINFO  : Completed compiling command(queryId=hive_20190902103034_18cb927f-0ab7-4a2d-b311-206b6ebb2cc2); Time taken: 0.059 seconds
\n\tINFO  : Executing command(queryId=hive_20190902103034_18cb927f-0ab7-4a2d-b311-206b6ebb2cc2): show databases
\n\tINFO  : Starting task [Stage-0:DDL] in serial mode
\n\tINFO  : Completed executing command(queryId=hive_20190902103034_18cb927f-0ab7-4a2d-b311-206b6ebb2cc2); Time taken: 0.039 seconds
\n\tINFO  : OK
\n\t+—————-+
\n\t| database_name  |
\n\t+—————-+
\n\t| default        |
\n\t+—————-+
\n\t1 row selected (0.362 seconds)
\n\t0: jdbc:hive2:\/\/cm-r01en01.mws.mds.xyz:10000\/><\/span>
\n\t \n<\/p>\n

\n\tCheers,
\n\tTK<\/p>\n\n

\n\n\t\t\n