'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