prestodb / presto-python-client

Python DB-API client for Presto
Apache License 2.0
239 stars 87 forks source link

Unable to insert data #124

Open hhhzt opened 1 year ago

hhhzt commented 1 year ago

My table creation statement is: create table test(word string) PARTITIONED by(dt string, hour string) STORED as orc Execute in my code: cursor = conn.cursor() sql = f''' insert into table auto_diagnose.test PARTITION(dt="2023-03-23" ,hour="10") values ("test7") '''

cursor.execute(sql) conn.commit() The code did not report an error, but no new data was added to the hive table

ShashiSai commented 1 year ago

hello, were you able to solve this issue?

nianaoqi commented 1 year ago

我也是,解决了吗