Hello everyone! I’m having problem passing data from

MYSQL

(AWS Aurora) to

S3

(AWS). When a table has a field with the

TIME

type, an error occurs when reading the

PARQUET

file. Here’s the error:

Unable to create Parquet converter for data type "timestamp" whose Parquet type is optional int64 member0 (TIME(MICROS,true))

The field is mapped as Struct and a dictionary is created with the timestamp and the string that would be the timezone.

{
  "expire_timeofday": {
    "member0": "timestamp",
    "member1": "string"
  }
}

I try to convert the field to String but there is an error in the conversion. Wouldn’t it be possible to select the type of field to be saved in the Destination?

Hello Felipe Cosse, it's been a while without an update from us. Are you still having problems or did you find a solution?

Hello Marcos! I changed the Parquet for JSON, then it worked correctly. Thanks!