There is an Athena table in which 2 of those columns contains values as json data.

I am trying to multiply the existing value with some constant value o.1876. the output of the data is looks like

I have a Athenna sql query where i am calculating some delivery date like below.

I have a bunch of small text files with multi-line, unstructured data, stored in S3.
Since these files don’t have a regular format, I’d like to create an Athena table where every file is parsed as a single record.