bulk insert in hana

[former_member604834]

Is it possible bulk insert in hana like

INSERTINTO tbl_name (a,b,c)VALUES(1,2,3),(4,5,6),(7,8,9);

[Vitaliy-R]

It is not in HANA's SQL syntax afaik.

But if you do it from Python, then you can do `executemany` (https://help.sap.com/viewer/0eec0d68141541d1b07893a39944924e/2.0.04/en-US/d0c010fa5c4e4e4cba7b791cd1...)

Something like [there might be some syntax mistake in below snippet, but should give the idea]

rows = ((1,2,3),(4,5,6),(7,8,9))
parms = '?,?,?'
sql = 'INSERT INTO "tbl_name" VALUES ({})'.format(parms)
cursor.executemany(sql, rows)

Regards.

[former_member604834]

witalij I am using java / spring boot. One by one query is executing even I run batch statement.