Failed_to_convert_the_JSON_string_'interval_day_to_second'_to_a_data_type

[Sambit_S]

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.

[Sambit_S]

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.

[jose_gonzalez]

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