Pyhive:使用Pyhive设置蜂巢特性

Question

我有一个复杂的蜂巢查询，其基础连接是笛卡尔产品。因此，我需要设置以下属性。但是，当我使用Pyhive执行这些属性时，它将无法执行。我遇到了一个错误，要求为笛卡尔设置属性。

set1 = '''set hive.strict.checks.cartesian.product = false'''''

set2 = '''set hive.mapred.mode = strict''''''

def connectData(query,host,port,username):
    conn = hive.Connection(host=host, port=port, username=username).cursor()
    conn.execute(query)
    val=conn.fetchall()
    columnNames = [a[0] for a in  conn.description]
    df=pd.DataFrame(data=val,columns=columnNames)
    return df
def settings(query,host,port,username):
    conn = hive.Connection(host=host, port=port, username=username).cursor()
    conn.execute(query)
settings(set1, host, port, username)
settings(set2, host, port, username)
df = connectData(query, host, port, username)
print(df)

Answer 1

尝试设置，如下所示：

hive.connect('host', configuration={'hive.strict.checks.cartesian.product':'false'})
hive.connect('host', configuration={'hive.mapred.mode':'strict'})