Trying to read parquet data produced with Athena using SerDe below into Pandas. It uses Map types, but produces this error:
"Map keys must be annotated as required".
Other libraries also fail to read the parquet.
The Map key's use the '=' separator, and I'm assuming it's some SerDe config issue, but there's not much documentation about what is configurable in the parquet SerDe. Any help would be greatly appreciated.
CTAS...
Partitioned By...
...
ROW FORMAT SERDE
'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
STORED AS INPUTFORMAT
'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat'
OUTPUTFORMAT
'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'
LOCATION
's3://redacted/'
TBLPROPERTIES (
'has_encrypted_data'='false',
'parquet.compression'='GZIP',