on 01-22-2015 9:55 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.