I'm testing the Athena product of AWS, so far is working very good. But I want to know the list of SerDe properties. I've searched far and wide and couldn't find it. I'm using this one for example "ignore.malformed.json" = "true"
, but I'm pretty sure there are a ton of other options to tune the queries.
I couldn't find info for example, on what the "path" property does, so having the full list will be amazing.
I have looked at Apache Hive docs but couldn't find this, and neither on AWS docs/forums.
Thanks!
It seems you are using the Openx-JsonSerDe
http://docs.aws.amazon.com/athena/latest/ug/json.html
https://github.com/rcongiu/Hive-JSON-Serde/blob/master/json-serde/src/main/java/org/openx/data/jsonserde/JsonSerDe.java
As stated in release notes (see bullet #2 please), the JSON OpenX SerDe used in Athena has been improved. The improvements include, but are not limited to, the following:
For more information, see OpenX JSON SerDe in the Amazon Athena User Guide.