Hive JDBC 配置session properties

最新推荐文章于 2025-03-21 15:17:09 发布

吐槽达达仔

最新推荐文章于 2025-03-21 15:17:09 发布

阅读量1.2k

点赞数

分类专栏： Hive 文章标签： hive jdbc properties 配置

本文链接：https://blog.youkuaiyun.com/dacoolbaby/article/details/84903707

版权

19 篇文章

订阅专栏

在使用hive jdbc的时候，需要有一些hive session的配置，

比如说：

当前作业使用的是哪条队列

当前作业的map大小，reduce大小，map个数，reduce的个数。

等等

解决方案是：在jdbc url上面，进行初始化的配置。

Connection URL Format

The HiveServer2 URL is a string with the following syntax:

jdbc:hive2:// <host1>:<port1>,<host2>:<port2>/dbName;initFile=<file>;sess_var_list?hive_conf_list#hive_var_list

where

<host1>:<port1>,<host2>:<port2> is a server instance or a comma separated list of server instances to connect to (if dynamic service discovery is enabled). If empty, the embedded server will be used.
dbName is the name of the initial database.
<file> is the path of init script file (Hive 2.2.0 and later). This script file is written with SQL statements which will be executed automatically after connection. This option can be empty.
sess_var_list is a semicolon separated list of key=value pairs of session variables (e.g., user=foo;password=bar).
hive_conf_list is a semicolon separated list of key=value pairs of Hive configuration variables for this session
hive_var_list is a semicolon separated list of key=value pairs of Hive variables for this session.