Execute multiple queries in single execute command

[sjd-lab]

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)

[77QingLiu]

+1, Same question

[zx06]

Same question

[BingyanZen]

Same question +1

[MichelleArk]

+1

[kelleyrw]

+1

[kelleyrw]

It's fine if this is not allowed. Can someone in the know comment?

[c-hui]

+1

[NadimYounes]

+1