Hive-JDBC操作

javax.jdo.option.ConnectionPassword root123 hive.exec.local.scratchdir /tmp/hive hive.downloaded.resources.dir /tmp/hive hive.metastore.warehouse.dir /data/hive/warehouse hive.metastore.event.db.notification.api.auth false hive.server2.active.passive.ha.enable true hive.server2.transport.mode binary Expects one of [binary, http]. Transport mode of HiveServer2. hive.server2.logging.operation.log.location /tmp/hive hive.hwi.listen.host 0.0.0.0 This is the host address the Hive Web Interface will listen on hive.server2.webui.host 0.0.0.0 The host address the HiveServer2 WebUI will listen on

三：启动metastore

在启动beeline之前需要先启动hiveserver2，而在启动hiveserver2之前需要先启动metastore。metastore默认的端口为9083。

cd /usr/local/Cellar/hive/3.1.2/bin
hive --service metastore &

启动过一定确认一下启动是否成功。

四：启动hiveserver2

cd /usr/local/Cellar/hive/3.1.2/bin
hive --service hiveserver2 &

hiveserver2默认的端口