from pyhive import hive
conn = hive.Connection(host='hadoop104',port=10000,username='baiyun' ,database='gmall')
cursor = conn.cursor()
cursor.execute('show tables')
cursor.execute('show tables')
cursor.execute('create table create_by_pyhive as select 1')
for result in cursor.fetchall():
print(result)