Getting JsonParseException: Unexpected character ('<' (code 60))

Data_Analytics1 — Tue, 20 Jun 2023 10:33:52 GMT

I have a scheduled job that is executed using a notebook. Within one of the notebook cells, there is a check to determine if a table exists. However, even when the table does exist, it incorrectly identifies it as non-existent and proceeds to execute the subsequent code.

spark.sql("CREATE SCHEMA IF NOT EXIST schema_name")

While executing the above code, it throws the below error:

shaded.v245.com.fasterxml.jackson.core.JsonParseException: Unexpected character ('<' (code 60)): expected a valid value (number, String, array, object, 'true', 'false' or 'null')

Even though I haven't used the "<" character in the code, it is still throwing the same error. Error is only for 5-6 runs in a whole day, rest of the time it is working fine. How to avoid this kind of error?

Note: I am using Job Compute cluster to run this job.

Re: Getting JsonParseException: Unexpected character ('<' (code 60))

Anonymous — Wed, 21 Jun 2023 03:20:39 GMT

Hi @Mahesh Chahare

Great to meet you, and thanks for your question!

Let's see if your peers in the community have an answer to your question. Thanks.

topic Getting JsonParseException: Unexpected character ('<' (code 60)) in Data Engineering

Getting JsonParseException: Unexpected character ('<' (code 60))

Re: Getting JsonParseException: Unexpected character ('<' (code 60))