Execute multiple queries in single pyhive.execute command

user_1616785 0
Viewed 3674

Using pyhive, is it possible to execute multiple hql's like 'CREATE TABLE TABLE1 (ITEM_KEY BIGINT );CREATE TABLE TABLE2 (ITEM_NAME BIGINT );'.

Sample code

from pyhive import hive
conn = hive.Connection(host=host
                       , port=port, username=user
                       , password=passwd
                       , auth=auth)
cursor = conn.cursor()
query= 'CREATE TABLE TABLE1 (ITEM_KEY BIGINT );CREATE TABLE TABLE2 (ITEM_NAME BIGINT );'. 
cursor.execute(query)
pyhive python
1 Answers

How about you split your query and execute them one by one?

qList = query.split(";")
for q in qList:
    cursor.execute(q)
user_86394440
Related