'Bulk inserts into hive database via Python's jaydebeapi executemany method is not supported
[enter link description here][1]I am trying to bulk insert from server to hive table and i am using python and jaydebeapi to insert data into hive table.
curs = conn.cursor()
curs.execute(""" create external table test(hi string, hello string, thanks string)
row format delimited fields terminated by '\-61' lines terminated by '\n' stored as parquet Location 'user/id'""")
data = [
("foo", "Parent", "bar"),
("foobar", "Parentbar", "bar"),
]
cursor = conn.cursor()
stmt = "INSERT INTO test (hi, hello,thanks) VALUES (%s, %s,%s)"
cursor.executemany(stmt, data)
conn.commit()```
but I am getting this error Java.sql.SQLEXception: Method not supported. attached the snapshot of error in below link
[1]: https://i.stack.imgur.com/o0rWV.jpg
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
Solution | Source |
---|