https://community.databricks.com/t5/data-engineering/failed-to-convert-the-json-string-interval-day-to-second-to-a/m-p/49066#M28459 <P>Hi&nbsp;<a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/90818">@Sambit_S</a>&nbsp;,</P> <P>did you have time to check Kaniz's response? could you please verity it and let us know if you still need help</P> Thu, 12 Oct 2023 22:31:48 GMT jose_gonzalez 2023-10-12T22:31:48Z https://community.databricks.com/t5/data-engineering/failed-to-convert-the-json-string-interval-day-to-second-to-a/m-p/48381#M28302 <P>I am trying to access a delta share table which has a field of datatype&nbsp;<STRONG>interval day to second below.</STRONG></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sambit_S_0-1696512262555.png" style="width: 400px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/4280iFEF842D2D263D0B8/image-size/medium/is-moderation-mode/true?v=v2&amp;px=400" role="button" title="Sambit_S_0-1696512262555.png" alt="Sambit_S_0-1696512262555.png" /></span></P><P><U><STRONG>Sample data in the table:-</STRONG></U></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sambit_S_1-1696512337390.png" style="width: 400px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/4281i9BAA474F28F0347B/image-size/medium/is-moderation-mode/true?v=v2&amp;px=400" role="button" title="Sambit_S_1-1696512337390.png" alt="Sambit_S_1-1696512337390.png" /></span></P><P>&nbsp;</P><P>The above table while accessing through delta share giving error as below.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sambit_S_2-1696512405641.png" style="width: 400px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/4282i02092B1E8F839C34/image-size/medium/is-moderation-mode/true?v=v2&amp;px=400" role="button" title="Sambit_S_2-1696512405641.png" alt="Sambit_S_2-1696512405641.png" /></span></P><P>Any help in resolving this issue will be appreciated. Thanks.</P><P>&nbsp;</P> Thu, 05 Oct 2023 13:27:20 GMT https://community.databricks.com/t5/data-engineering/failed-to-convert-the-json-string-interval-day-to-second-to-a/m-p/48381#M28302 Sambit_S 2023-10-05T13:27:20Z https://community.databricks.com/t5/data-engineering/failed-to-convert-the-json-string-interval-day-to-second-to-a/m-p/49066#M28459 <P>Hi&nbsp;<a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/90818">@Sambit_S</a>&nbsp;,</P> <P>did you have time to check Kaniz's response? could you please verity it and let us know if you still need help</P> Thu, 12 Oct 2023 22:31:48 GMT https://community.databricks.com/t5/data-engineering/failed-to-convert-the-json-string-interval-day-to-second-to-a/m-p/49066#M28459 jose_gonzalez 2023-10-12T22:31:48Z https://community.databricks.com/t5/data-engineering/failed-to-convert-the-json-string-interval-day-to-second-to-a/m-p/49079#M28469 <P>The issue was indeed with the&nbsp;<SPAN>specific data type&nbsp;</SPAN>interval day to second<SPAN>&nbsp;in my Delta Share table.</SPAN></P><P><SPAN>I casted the column from&nbsp;<EM><STRONG>interval day to second to string</STRONG></EM></SPAN>&nbsp;in my Delta Share table and I am able to access the table and data now.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sambit_S_0-1697181041398.png" style="width: 400px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/4396i12EEEC5E877EC1F9/image-size/medium/is-moderation-mode/true?v=v2&amp;px=400" role="button" title="Sambit_S_0-1697181041398.png" alt="Sambit_S_0-1697181041398.png" /></span></P><P>&nbsp;</P> Fri, 13 Oct 2023 07:13:10 GMT https://community.databricks.com/t5/data-engineering/failed-to-convert-the-json-string-interval-day-to-second-to-a/m-p/49079#M28469 Sambit_S 2023-10-13T07:13:10Z