Home > OS >  How map my custom data type with AWS Athena data type?
How map my custom data type with AWS Athena data type?

Time:09-21

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 - enter image description here

  • Related