Dynamic Column insertion in hbase

[#1]

Hi,

I am a newbiee to nifi and its processors.  

Want to understand what would be the jolt specification for the following input/output? Or can anyone suggest any other processor .

Input JSON:

{"cells": {"deviceindicators:1234_32456_789023":"0", "deviceindicators:5678_89213_875943":"110"}}

Output JSON:

{"cells": {"1234_32456_789023":"0", "5678_89213_875943":"110"}}

Want to remove "deviceindicators:" from the key using JoltJSONtransformation.. Please advice

[#2 · Accepted solution]

Hi @VaibhavK ,

You can try the following spec:

[
  {
    "operation": "shift",
    "spec": {
      "cells": {
        "*:*": "&(0,2)"
      }
    }
  }
]

ref:

https://community.cloudera.com/t5/Support-Questions/Dynamically-renaming-JSON-field-names-in-NiFi/td...

If you find this is helpful please accept solution.

Thanks

[#3]

Thanks @SAMSAL  it worked for me...