Failed_to_convert_the_JSON_string_'interval_day_to_second'_to_a_data_type
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-05-2023 06:27 AM
I am trying to access a delta share table which has a field of datatype interval day to second below.
Sample data in the table:-
The above table while accessing through delta share giving error as below.
Any help in resolving this issue will be appreciated. Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-13-2023 12:13 AM
The issue was indeed with the specific data type interval day to second in my Delta Share table.
I casted the column from interval day to second to string in my Delta Share table and I am able to access the table and data now.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-12-2023 03:31 PM
Hi @Sambit_S ,
did you have time to check Kaniz's response? could you please verity it and let us know if you still need help