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

Storing HL7 v2 messsage

Storing HL7 v2 messsage

New Contributor

I want to store Hl7 v2 messages in a such way that i can query based on  OBX-3 (Identifier normally mdc code ) and it should return OBX-5 along with  other OBX fields and also OBR fields.

I am getting around 200 gb of ORU_R01, ORU_R40, ADT messages, Lab and Examination message.Here Only ORU_R01 is query able based on OBX-3 which in my case has MDC codes.

I am planning to store patient wise.


I have explored some option like Apache Hive/parquet, postgresql and Graphdb.

Could please Whats is the best way to store it. 



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