Skip to main content
VaibhavK
VaibhavK
Silver ⭐️⭐️
July 24, 2023
Solved

Dynamic Column insertion in hbase

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

SAMSAL
SAMSALAnswer
Platinum ⭐️⭐️⭐️
July 24, 2023

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-p/226223

 

If you find this is helpful please accept solution.

Thanks

 

View in thread

2 replies

SAMSAL
SAMSALAnswer
Platinum ⭐️⭐️⭐️
July 24, 2023

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-p/226223

 

If you find this is helpful please accept solution.

Thanks

 

Translate
    VaibhavK
    VaibhavKAuthor
    Silver ⭐️⭐️
    July 28, 2023

    Thanks @SAMSAL  it worked for me...

    Translate
    Terms & ConditionsAccessibility statement