https://community.databricks.com/t5/data-engineering/issue-converting-the-datasets-into-json/m-p/23124#M15927 <P>Im a newbie to Databricks, I need to convert the data sets into JSON. i tried bth FOR JSON AUTO AND FOR JSON PATH, However im getting an issue - [PARSE_SYNTAX_ERROR] Syntax error at or near 'json'line </P><P></P><P>My Query works fine without FOR JSON AUTO AND FOR JSON PATH.</P><P></P><P>My Query:</P><P>Select ChecklistName as a from ***</P><P>FOR JSON AUTO</P><P></P><P>Can someone help me here.</P><P></P><P></P> Wed, 09 Nov 2022 02:07:34 GMT Kavin 2022-11-09T02:07:34Z https://community.databricks.com/t5/data-engineering/issue-converting-the-datasets-into-json/m-p/23124#M15927 <P>Im a newbie to Databricks, I need to convert the data sets into JSON. i tried bth FOR JSON AUTO AND FOR JSON PATH, However im getting an issue - [PARSE_SYNTAX_ERROR] Syntax error at or near 'json'line </P><P></P><P>My Query works fine without FOR JSON AUTO AND FOR JSON PATH.</P><P></P><P>My Query:</P><P>Select ChecklistName as a from ***</P><P>FOR JSON AUTO</P><P></P><P>Can someone help me here.</P><P></P><P></P> Wed, 09 Nov 2022 02:07:34 GMT https://community.databricks.com/t5/data-engineering/issue-converting-the-datasets-into-json/m-p/23124#M15927 Kavin 2022-11-09T02:07:34Z https://community.databricks.com/t5/data-engineering/issue-converting-the-datasets-into-json/m-p/23125#M15928 <P>Hi @Kavin Natarajan​&nbsp;, Could you please go through <A href="https://www.tutorialkart.com/apache-spark/spark-write-dataset-to-json-file-example/" alt="https://www.tutorialkart.com/apache-spark/spark-write-dataset-to-json-file-example/" target="_blank">https://www.tutorialkart.com/apache-spark/spark-write-dataset-to-json-file-example/</A> , looks like the steps are okay. </P> Wed, 09 Nov 2022 07:03:28 GMT https://community.databricks.com/t5/data-engineering/issue-converting-the-datasets-into-json/m-p/23125#M15928 Debayan 2022-11-09T07:03:28Z