Specify your own path extractors - Amazon Athena
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

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.