I am uploading the below JSON format data into the AWS S3 bucket.
{
"time": 1663090620000,
"data": [
[
1,
[
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
]
]
]
}
I have data types in my object for the fields in the JSON as mentioned below.
time - Long
data - List<List<Object>>
I tried creating the below schema in Athena with partition projection by pointing to S3 bucket but I am not able to map the data field in my JSON data with amazon Athena supported data types -