OpenXJsonSerDe
The OpenX SerDe. Used by Firehose for deserializing data, which means converting it from the JSON format in preparation for serializing it to the Parquet or ORC format. This is one of two deserializers you can choose, depending on which one offers the functionality you need. The other option is the native Hive / HCatalog JsonSerDe.
Contents
- CaseInsensitive
-
When set to
true
, which is the default, Firehose converts JSON keys to lowercase before deserializing them.Type: Boolean
Required: No
- ColumnToJsonKeyMappings
-
Maps column names to JSON keys that aren't identical to the column names. This is useful when the JSON contains keys that are Hive keywords. For example,
timestamp
is a Hive keyword. If you have a JSON key namedtimestamp
, set this parameter to{"ts": "timestamp"}
to map this key to a column namedts
.Type: String to string map
Key Length Constraints: Minimum length of 1. Maximum length of 1024.
Key Pattern:
^\S+$
Value Length Constraints: Minimum length of 1. Maximum length of 1024.
Value Pattern:
^(?!\s*$).+
Required: No
- ConvertDotsInJsonKeysToUnderscores
-
When set to
true
, specifies that the names of the keys include dots and that you want Firehose to replace them with underscores. This is useful because Apache Hive does not allow dots in column names. For example, if the JSON contains a key whose name is "a.b", you can define the column name to be "a_b" when using this option.The default is
false
.Type: Boolean
Required: No
See Also
For more information about using this API in one of the language-specific Amazon SDKs, see the following: