question Re: Dynamic Column insertion in hbase in Support Questions

Dynamic Column insertion in hbase

VaibhavK — Mon, 24 Jul 2023 10:06:36 GMT

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 — Mon, 24 Jul 2023 13:36:22 GMT

You can try the following spec:

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

ref:

If you find this is helpful please accept solution.

Thanks

VaibhavK — Fri, 28 Jul 2023 08:00:05 GMT

Thanks @SAMSAL it worked for me...