on 07-19-2016 11:50 PM
Hello,
By uploading a big flat file (1.5 GB) into HANA the columns are only recognized as varchar and I don’t have the possibility to change the data type.
I've already tried this: creating a table with the correct type (currencies as decimal (17,2) and quantities as decimal (17,2). But by uploading the table, the mapping doesn’t work. The error message said that I could not map from varchar to decimal. I tried with all numeric data type and it’s not working.
The problem is that the table is quite big. I cannot open it in excel or in notepad, notepad++, etc.
Could you please tell me how I can convert the data type of columns to a numeric type (integer or decimal)?
Big thanks!
Regards
Sylvan
Why don't you try to put your file in the "original" table, then SELECT the data and INSERT it in the "right" table.
When the INSERT command finish, you just drop the original table and rename the right one.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
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.