how to create external table in athena on the top of xml data

[#1]

Hi Team,

I want to create table in athena on the top of xml data, I am able to create in hive.

Any leads would be helpful...

Thanks

Vishal

[#2]

@kumar993498 : Amazon Athena uses Presto, supports a wide variety of data formats like CSV, TSV, JSON, or Textfiles and also supports open source columnar formats such as Apache ORC and Apache Parquet. Athena also supports compressed data in Snappy, Zlib, LZO, and GZIP formats. By compressing, partitioning, and using columnar formats you can improve performance and reduce your costs.

following SerDes:

1. Apache Web Logs: "org.apache.hadoop.hive.serde2.RegexSerDe"
2. CSV: "org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe"
3. TSV: "org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe"
4. Custom Delimiters: "org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe"
5. Parquet: "org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe"
6. Orc: "org.apache.hadoop.hive.ql.io.orc.OrcSerde"
7. JSON: “org.apache.hive.hcatalog.data.JsonSerDe” OR org.openx.data.jsonserde.JsonSerDe

Hope this helps you. 

[#3]

Yes, This is very informative.

Thanks