search

logstash-plugins / logstash-filter-jdbc_static

Loads a DB query's result set in memory and uses it as lookup table for events.
Apache License 2.0
11 stars 12 forks source link

'NULL' string for null columns in SQL Server #40

Open bugejakurt opened 6 years ago

bugejakurt commented 6 years ago

Querying a table with a null column value from SQL Server converts to "NULL" string in local_lookups. Can this stay as null?

mhunsber commented 5 years ago

I have a similar issue, but with integers from a postgresql server. However, since it expects an integer field, the import fails because "NULL" is not an integer. I posted a discussion question here: https://discuss.elastic.co/t/load-table-with-jdbc-static-filter-with-null-integers/159391

it looks like the csv file isn't being populated correctly: http://db.apache.org/derby/docs/10.4/tools/ctoolsimportnulls.html