Failed_to_convert_the_JSON_string_'interval_day_to_second'_to_a_data_type

Sambit_S
New Contributor III

I am trying to access a delta share table which has a field of datatype interval day to second below.

Sambit_S_0-1696512262555.png

Sample data in the table:-

Sambit_S_1-1696512337390.png

 

The above table while accessing through delta share giving error as below.

Sambit_S_2-1696512405641.png

Any help in resolving this issue will be appreciated. Thanks.

 

Sambit_S
New Contributor III

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.

Sambit_S_0-1697181041398.png

 

jose_gonzalez
Databricks Employee
Databricks Employee

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