Indexing of complex JSON data types fails

Description

While trying to ingest and index the provided json sample file (containing a array), the indexing fails due to org.apache.nifi.processor.exception.ProcessException: java.sql.SQLException: Method not supported; routing to failure: {}

Data can be queried successfully from the Table UI or Visual Query (even using the array index, eg: cat[0])

If we try with a JSON containing a structure(map), it fails due to java.lang.IllegalArgumentException: createSchema: Unknown SQL type 2002 cannot be converted to Avro type; rolling back session: {}

The issue happens in the Extract Feed Data (ExecuteHQL) processor

You can find attached the logs for the 2 cases and the json sample with a structure.

Environment

None

Status

Assignee

Unassigned

Reporter

Claudiu Stanciu

Labels

None

Reviewer

None

Story point estimate

None

Affects versions

0.8.3

Priority

High