search

cloudera / impyla

Python DB API 2.0 client for Impala and Hive (HiveServer2 protocol)
Apache License 2.0
730 stars 248 forks source link

Multirow Insert #460

Open darklord1807 opened 3 years ago

darklord1807 commented 3 years ago

Hello,

I need to do multirow insert and Impala supports same but when trying:

allToBeInserted.to_sql('xx', engine, if_exists='append', index=False,chunksize=2000,method='multi')

I get the following error

sqlalchemy.exc.CompileError: The 'impala' dialect with current database version settings does not support in-place multirow inserts.

Any idea how this can be enabled?

Thanks

darklord1807 commented 3 years ago

Fixed by pull request #461