Hello.
We're trying to inject json data into impala (via jdbc connection and a
DBCPConnectionPool) in Nifi 1.8.0.
Given the following json (note the empty fields event):
{
"_msgid": "5c40a721b02db11867a3db95",
"event": ""
}
PutDataBaseRecord or ConvertJsonToSQL+PutSQL is generating the following sql
statement, and fails with
ERROR processing query/statement. Error Code: 0, SQL state:
TStatus(statusCode:ERROR_STATUS, sqlState:HY000,
errorMessage:AnalysisException: Char size must be > 0: 0
INSERT INTO `e_cycletime_rfid_event`
(`_msgid`, `event`) VALUES (
CAST('5c40a721b02db11867a3db95' AS CHAR(24)),
CAST('' AS CHAR(0))
)
Is there a way to mitigate the issue, should I open a JIRA on nifi site or to
Cloudera support?
Thanks.
This electronic transmission (and any attachments thereto) is intended solely
for the use of the addressee(s). It may contain confidential or legally
privileged information. If you are not the intended recipient of this message,
you must delete it immediately and notify the sender. Any unauthorized use or
disclosure of this message is strictly prohibited. Faurecia does not guarantee
the integrity of this transmission and shall therefore never be liable if the
message is altered or falsified nor for any virus, interception or damage to
your system.
