https://linen.dev logo
Title
d

Didip Kerabat

05/25/2023, 4:15 PM
Anyone happened to know what this means?
ProgrammingError: Unknown exception (com.fasterxml.jackson.databind.RuntimeJsonMappingException): Cannot deserialize instance of `java.lang.String` out of VALUE_NULL token
 at [Source: (net.jpountz.lz4.LZ4BlockInputStream); line: -1, column: 4]
It seems to me that the column has null values but the devs said that there are no such nulls.
This happened when they try to use
array_agg()
function.
array_agg(coalesce(the_column, ''))
s

Saydul Bashar

05/25/2023, 4:50 PM
I think I came across something similar a while ago
Trying to dig out a bit more info about it. What happened was that there was a null character in my string. Languages like C++ use null characters to terminate strings whereas Java uses string length. So, this has the potential of having vulnerabilities. So, Druid SQL doesn't allow this. The solution was to use a regex to remove the null character
I haven't been able to find the relevant info yet but something like `
REPLACE(myString, Char(0x00), '')
` should work
d

Didip Kerabat

05/25/2023, 4:57 PM
ho thank you! I will give that a try.
s

Saydul Bashar

05/25/2023, 4:58 PM
You are welcome. You need to test out the regex a bit. I am not quite sure whether this is the right one or not.
@Didip Kerabat once you test it out please let me know whether it worked or not. I am curious to know 🙂.