cancel
Showing results for 
Search instead for 
Did you mean: 

Export/Import table with different name

Former Member
0 Kudos

Hi,

I have a scenario where I need to take a copy of a table with a different partition strategy. But the table is big, and SELECT INTO statements are taking a long time.

It's possible to run a BINARY export of the table quite quickly (30 minutes).

Is there some way to rename the table during IMPORT? And is it possible to change the SQL?

Was thinking maybe if I rename the folder so it matches what I want the table to be, and change the partition strategy in SQL, I could re-import and get a copy with the structure that I'm looking for.

Or will that break HANA?

John

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

I tried this but when I did the import, it didn't import the data. There must be some metadata somewhere in the binary files.

With CSV files it may work better, because this uses the HANA bulk loader. But it may take longer.