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

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