Hello Empty string if the field is present but empty.
I’ll have to check but it seems there is another problem with null value Jason field, set as string « null » in the database. Thanks. Envoyé de mon iPhone Le 3 févr. 2019 à 22:39, Pierre Villard <[email protected]<mailto:[email protected]>> a écrit : Hey, By no mean an expert on the subject, but, just to be sure, would expect the null value to be added in the database or do you really want the empty string? Pierre Le ven. 1 févr. 2019 à 16:37, DEHAY Aurelien <[email protected]<mailto:[email protected]>> a écrit : 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. 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.
