Specify your own path extractors - Amazon Athena
Services or capabilities described in AWS documentation might vary by Region. To see the differences applicable to the AWS European Sovereign Cloud Region, see the AWS European Sovereign Cloud User Guide.

Specify your own path extractors

If your Amazon Ion fields do not map neatly to Hive columns, you can specify your own path extractors. In the WITH SERDEPROPERTIES clause of your CREATE TABLE statement, use the following syntax.

WITH SERDEPROPERTIES (
   "ion.path_extractor.case_sensitive" = "<Boolean>", 
   "ion.<column_name>.path_extractor" = "<path_extractor_expression>"
)
Note

By default, path extractors are case insensitive. To override this setting, set the ion.path_extractor.case_sensitive SerDe property to true.