cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Help
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Failed_to_convert_the_JSON_string_'interval_day_to_second'_to_a_data_type

Sambit_S
New Contributor III

‎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.

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.

 

0 Kudos
2 REPLIES 2

Sambit_S
New Contributor III
In response to Retired_mod

‎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.

Sambit_S_0-1697181041398.png

 

0 Kudos

jose_gonzalez
Databricks Employee
Databricks Employee

‎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

0 Kudos

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.

If there isn’t a group near you, start one and help create a community that brings people together.

Request a New Group
Announcements