Unable to load JSON record type as Array into hive/impala

Hi - Has anyone tried loading a JSON type record which has nested arrays into big data environment (Impala/Hive) ? I would like to load a JSON into impala table with Array data type. and tried using output mapping in the DB loader node but there is no mapping for JSON to Array.

Json type is not always convertible to array because it’s potentially a more complex structure. So you have to write a transformation rule.
Can you post a little json part as example?
You have to transform it by Json Transformer or JsonPath.

2 Likes