https://community.incorta.com/t5/data-schema-discussions/error-in-sparl-sql/m-p/5850#M503 <P>What's you source DB?&nbsp; &nbsp;I just tried it w/ SPARK SQL against an Incorta table and it worked fine.</P><P>Also - apologies for even asking - but are your comments allowing a serial comma in the SQL?&nbsp; &nbsp;Burned me more than once&nbsp; <span class="lia-unicode-emoji" title=":winking_face:">😉</span>&nbsp; &nbsp;&nbsp;</P> Wed, 19 Jun 2024 18:45:31 GMT RADSr 2024-06-19T18:45:31Z https://community.incorta.com/t5/data-schema-discussions/error-in-sparl-sql/m-p/5846#M502 <P>Hi ,</P><P>If i comment NULL as TRX_PERIOD, NULL AS applied_period, mv is loading successfully, uncomment getting below error.</P><P>Please let me know what is the issue in the query</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="KKR_0-1718282660161.png" style="width: 400px;"><img src="https://community.incorta.com/t5/image/serverpage/image-id/2653i41BA4A889AFECCAB/image-size/medium?v=v2&amp;px=400" role="button" title="KKR_0-1718282660161.png" alt="KKR_0-1718282660161.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="KKR_0-1718282393734.png" style="width: 400px;"><img src="https://community.incorta.com/t5/image/serverpage/image-id/2651i6775E7EE08DFBAE4/image-size/medium?v=v2&amp;px=400" role="button" title="KKR_0-1718282393734.png" alt="KKR_0-1718282393734.png" /></span></P><P>&nbsp;</P> Thu, 13 Jun 2024 12:45:17 GMT https://community.incorta.com/t5/data-schema-discussions/error-in-sparl-sql/m-p/5846#M502 KKR 2024-06-13T12:45:17Z https://community.incorta.com/t5/data-schema-discussions/error-in-sparl-sql/m-p/5850#M503 <P>What's you source DB?&nbsp; &nbsp;I just tried it w/ SPARK SQL against an Incorta table and it worked fine.</P><P>Also - apologies for even asking - but are your comments allowing a serial comma in the SQL?&nbsp; &nbsp;Burned me more than once&nbsp; <span class="lia-unicode-emoji" title=":winking_face:">😉</span>&nbsp; &nbsp;&nbsp;</P> Wed, 19 Jun 2024 18:45:31 GMT https://community.incorta.com/t5/data-schema-discussions/error-in-sparl-sql/m-p/5850#M503 RADSr 2024-06-19T18:45:31Z