在单个pyhive.execute命令中执行多个查询

from pyhive import hive
from TCLIService.ttypes import TOperationState

# 连接到 Hive
conn = hive.Connection(host='your_host', port=10000, username='your_username')

# 创建一个 cursor
cursor = conn.cursor()

# 定义要执行的多个查询
queries = [
    "SELECT * FROM table1 LIMIT 10",
    "SELECT * FROM table2 LIMIT 10",
    "SELECT COUNT(*) FROM table3"
]

# 循环执行每个查询
for query in queries:
    cursor.execute(query)
    
    # 获取查询结果
    print("Results of the query:", query)
    for result in cursor.fetchall():
        print(result)

# 关闭 cursor 和连接
cursor.close()
conn.close()