Retrieving structured data from complex type column

[eatonphil]

Version of AWS SDK for Go?

1.19.0

Version of Go (go version)?

go version go1.12 linux/amd64

What issue did you see?

The VarCharValue field on the Datum struct does not appear to be parseable when dealing with maps. Here is example output of some Datum's VarCharValue field:

{message_fields={message=An illegitimate escalation of privileges was detected in the program "/usr/sbin/sshd", which violated the policy., uuid=458cf903-929b-4522-9ef2-397334856a05, timestamp=2019-07-04T14:13:46.65326686Z}

String values are not quoted even when they contain spaces and commas (see the message field). So it does not seem possible to retrieve structured data from a Datum value. (Would have
same issue if an Array's value contained a comma and space.)

Am I misunderstanding the API? Is there another way to pull structured data from a Datum value? Or are there parsing rules that I am not picking up?

Thank you!

Steps to reproduce

Populate an athena table with a map column and attempt to query it using the Go api. Have key-value pair where the value contains a comma followed by a space. The VarCharValue field is not parseable since strings are not quoted.

[diehlaws]

Thanks for reaching out to us @eatonphil. Is the field you've included a VARCHAR in its entirety, or is a specific component of this field being cast as a VARCHAR? If the data type of the provided field is a MAP you should be able to select each member of the map independently in the query, or cast each member of the map as a given data type to then parse individually. Seeing a code sample would allow us to better understand how exactly you're interacting with Athena using the AWS SDK for Go to retrieve this data so we can better assist with this.