I have a sql table to read and to filter rows where the timestamp is within open hours of a place and then write the filtered rows to a new table.

The timestamp column looks like this: 2019-08-23T18:17:44-04:00. (So need to remove the -04:00.)

And the open hours column looks like this: {“fri”: [[“16:00:00”, “23:59:59”]], “mon”: [[“16:00:00”, “23:59:59”], [“00:00:00”, “02:00:00”]], “sat”: [[“16:00:00”, “23:59:59”]], “sun”: [[“00:00:00”, “02:00:00”], [“16:00:00”, “23:59:59”]], “thu”: [], “tue”: [], “wed”: []}.

Any ideas how to do it without running into this issue:
TrinoUserError(type=USER_ERROR, name=NOT_SUPPORTED, message="Unsupported Hive type: json")