Member since
02-05-2016
6
Posts
1
Kudos Received
0
Solutions
04-03-2020
02:46 PM
It seems ExtractHL7Attributes will extract the multiple segments in some cases (e.g. multiple OBX for ORU^R01 messgae type) but extracts only one instance of segments in most other cases (extracts only one of multiple OBX segments for ORU^R03 messgae type, or only one DG1 segment in ADT^A08 or only one NTE segment in any messagetype).
Is there some standard that is being followed to define now many segment instances to expect? Can I create a custom version of this processor to allow multiple segments and if so then where exactly would I be making changes??
Regards,
Gopal Krishan
... View more
Labels:
12-17-2019
12:06 PM
In my hbase table for eg if table is key , CF (column family) and CF has columns created as a1,b1,c1,a2,b2,c2
Key CF:a1, CF:b1,CF:c1,CF:a2,CF:b2,CF:c2
xyz 1 1 1 2 2 2
I want to create a table in Hive which would look like (no uniqueness on Key)
Table - HB_TABLE
Key ColA ColB ColC
xyz 1 1 1
xyz 2 2 2
Best case scenario would be a table
Key SEQ ColA ColB ColC
xyz 1 1 1 1
xyz 2 2 2 2
Any way of doing it?? Current Hbase table has millions of records currently.
Thanks and Regards,
... View more
Labels:
12-16-2019
02:27 PM
To add .. The example shows 2 sequences, but there could be many more .. I am planning to put data in Kudu in table and need to put down each sequence combination as a row.
... View more
12-16-2019
02:24 PM
Thanks for helping out .. It worked.
... View more
12-16-2019
02:21 PM
1 Kudo
I have been trying to transform the following JSON
{
"controlid": "65363_738_VI",
"MSH_1.AcceptAcknowledgementType": "AL",
"MSH_1.SendingFacility.NamespaceID": "6",
"MSH_1.SendingApplication.NamespaceID": "HOSP",
"MSH_2.AcceptAcknowledgementType": "AK",
"MSH_2.SendingFacility.NamespaceID": "7",
"MSH_2.SendingApplication.NamespaceID": "HOSP"
}
I am looking for output like
{
"msh" : [{
"controlid" : "65363_738_VI",
"seq" : "1",
"AcceptAcknowledgementType" : "AL",
"SendingFacility.NamespaceID" : "6",
"SendingApplication.NamespaceID" : "HOSP"
},
{
"controlid" : "65363_738_VI",
"seq" : "2"
"AcceptAcknowledgementType" : "AK" ,
"SendingFacility.NamespaceID" : "7" ,
"SendingApplication.NamespaceID" : "HOSP"
}
}
I had the spec as
[
{
"operation": "shift",
"spec": {
"controlid": "msh.&(0,0)",
"*.*": {
"@0": "msh.&(0,2)"
}
}
}
]
The final output I got was
{
"msh" : {
"controlid" : "65363_738_VI",
"AcceptAcknowledgementType" : [ "AL", "AK" ],
"SendingFacility.NamespaceID" : [ "6", "7" ],
"SendingApplication.NamespaceID" : [ "HOSP", "HOSP" ]
}
}
... View more
Labels:
11-22-2019
04:15 PM
Installed CFM (Nifi) on Cloudera 6.2 using parcels. I see default 512 M being allocated for Heap size and want to increase it. I did not see nifi.properties file where I could do the same...
Any guidance would be appreciated..
... View more
Labels: