Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Hive3: JSON and XML SerDe?

Highlighted

Hive3: JSON and XML SerDe?

@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:

  • HDP 3.0 (hive3)
  • HDF 3.2
  • Tableau

Looking forward.

2 REPLIES 2
Highlighted

Re: Hive3: JSON and XML SerDe?

Master Collaborator

@Mustafa Ali Qizilbash

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.

 


 


If this answer resolves your issue or allows you to move forward, please choose to ACCEPT this solution and close this topic. If you have further dialogue on this topic please comment here or feel free to private message me. If you have new questions related to your Use Case please create separate topic and feel free to tag me in your post.  


 


Thanks,



Steven

Re: Hive3: JSON and XML SerDe?

@Steven Matison

These SerDe(s) are not working with Hive3 in HDP3.0

Did you tested these with Hive3 or previous versions?

Don't have an account?
Coming from Hortonworks? Activate your account here