OpenXJsonSerDe Class | AWS SDK for .NET V3

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.

Inheritance Hierarchy

System.Object
Amazon.KinesisFirehose.Model.OpenXJsonSerDe

Namespace: Amazon.KinesisFirehose.Model
Assembly: AWSSDK.KinesisFirehose.dll
Version: 3.x.y.z

Syntax

public class OpenXJsonSerDe

The OpenXJsonSerDe type exposes the following members

Constructors

	Name	Description
	OpenXJsonSerDe()

Properties

Name Type Description

Name	Type	Description
CaseInsensitive	System.Boolean	Gets and sets the property CaseInsensitive. When set to `true`, which is the default, Firehose converts JSON keys to lowercase before deserializing them.
ColumnToJsonKeyMappings	System.Collections.Generic.Dictionary<System.String, System.String>	Gets and sets the property 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 named `timestamp`, set this parameter to `{"ts": "timestamp"}` to map this key to a column named `ts`.
ConvertDotsInJsonKeysToUnderscores	System.Boolean	Gets and sets the property 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`.

CaseInsensitive

System.Boolean

Gets and sets the property CaseInsensitive.

When set to true, which is the default, Firehose converts JSON keys to lowercase before deserializing them.

ColumnToJsonKeyMappings

System.Collections.Generic.Dictionary<System.String, System.String>

Gets and sets the property 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 named timestamp, set this parameter to {"ts": "timestamp"} to map this key to a column named ts.

ConvertDotsInJsonKeysToUnderscores

System.Boolean

Gets and sets the property 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.

Version Information

.NET Core App:
Supported in: 3.1

.NET Standard:
Supported in: 2.0

.NET Framework:
Supported in: 4.5, 4.0, 3.5