Created 08-26-2018 05:00 AM
@Shu @Geoffrey Shelton Okot @Matt Burgess
Hi,
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.
Environment:
Looking forward.
Created 08-27-2018 01:23 PM
This should be what you are looking for:
ROW FORMAT SERDE 'org.apache.hive.hcatalog.data.JsonSerDe'
https://github.com/rcongiu/Hive-JSON-Serde
https://stackoverflow.com/questions/41453646/loading-json-file-in-hive-table
And for XML:
https://github.com/dvasilen/Hive-XML-SerDe
https://github.com/dvasilen/Hive-XML-SerDe/wiki/XML-data-sources
If this answer is helpful, please choose ACCEPT to mark the question as answered.
Created 09-02-2018 07:25 AM
These SerDe(s) are not working with Hive3 in HDP3.0
Did you tested these with Hive3 or previous versions?