I have this simple situation:
I have data in parquet stored on HDFS.
One of the columns is a JSON message.
When previewing the data I can see that the JSON field is indicated as a ‘text’ column… I don’t want that so I convert the column to JSON using: convert_from(payload, ‘JSON’) AS payload
When running the query (in preview and also in full run mode) I receive the following error:
Failed to load results for job 21aae688-eb79-46dd-d70d-9935bc8ee000
However when I look in the jobs I can see a completely successful job run…