AWS Athena（JSON）的SerDe属性列表 [英] SerDe properties list for AWS Athena (JSON)

问题描述

我正在测试AWS的Athena产品，到目前为止运行良好。但是我想知道SerDe属性的列表。我已经搜索了很多东西，却找不到。我使用的是这个例子，例如 ignore.malformed.json = true ，但是我很确定还有很多其他选项可以调整查询。

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.

例如，我找不到有关 path属性作用的信息，因此拥有完整列表将是一件很了不起的事情。

I couldn't find info for example, on what the "path" property does, so having the full list will be amazing.

我看过Apache Hive文档，但找不到，在AWS文档/论坛上也找不到。

I have looked at Apache Hive docs but couldn't find this, and neither on AWS docs/forums.

谢谢！

推荐答案

似乎您正在使用Openx-JsonSerDe

http://docs.aws.amazon.com/athena/latest/ug/json.html

It seems you are using the Openx-JsonSerDe
http://docs.aws.amazon.com/athena/latest/ug/json.html

// properties used in configuration
public static final String PROP_IGNORE_MALFORMED_JSON = "ignore.malformed.json";
public static final String PROP_DOTS_IN_KEYS = "dots.in.keys";
public static final String PROP_CASE_INSENSITIVE ="case.insensitive" ;

https://github.com/rcongiu/Hive-JSON-Serde/blob/ master / json-serde / src / main / java / org / openx / data / jsonserde / JsonSerDe.java

这篇关于AWS Athena（JSON）的SerDe属性列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！