@Shu @Geoffrey Shelton Okot @Matt Burgess
We have JSON and XML files in HDFS and need both SerDe(s), so we can use Hive External Tables to load into Hive Managed Partitioned Tables via NiFi.
@Mustafa Ali Qizilbash
This should be what you are looking for:
ROW FORMAT SERDE
And for XML:
If this answer is helpful, please choose ACCEPT to mark the question as answered.
These SerDe(s) are not working with Hive3 in HDP3.0
Did you tested these with Hive3 or previous versions?