on 01-23-2017 1:37 PM
I have a source table in POSTGRES having one JSON column.When i am fetching this column in BODS it is automatically taking it as varchar().But Varchar of this size is not supported by BODS.
Please suggest what can be solve this issue.
Thanks in Advance !
Arun,
I am able to fetch this table now in HANA using this approach.
Thanks a lot !!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Nishtha,
Can you try doing a select on the POSTGRES table column which has JSON datatype using a SQL transform and then output it to a Target table.
Try changing the datatype of the JSON object to LONG in the Query transform
SQL Transform>Query Transform(Change the datatype of JSON column to LONG)>Target Table
Regards
Arun Sasi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Thanks for the reply !
I changed the DS settings as suggested by you and then ran my job.But facing below attached error while running it.
Please help.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Nishtha
Can you try checking the option Import unsupported data types as VARCHAR of size and then run the job
Regards
Arun Sasi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
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.