error in sparl SQL

[KKR]

Hi ,

If i comment NULL as TRX_PERIOD, NULL AS applied_period, mv is loading successfully, uncomment getting below error.

Please let me know what is the issue in the query

[RADSr]

What's you source DB?   I just tried it w/ SPARK SQL against an Incorta table and it worked fine.

Also - apologies for even asking - but are your comments allowing a serial comma in the SQL?   Burned me more than once  😉