So, if anyone is using Apache NiFi in their projects, do not update from version 1.12.1 if you're doing AvroRecordReader => AvroRecordWriter combo for your ETL.
It is f*cked up.
At least for MySQL UTF8 string data.
Just wasted 1.5 days of dev time (x2 people!) on it.
"Programming is Chaos, Art and Science. It is a curse, a blessing, and progress. It all depends on who uses programming, how they use it, and to what purpose. And code is everywhere. All around us. Easily accessible. It is enough to stretch out one’s hand. See? I’m stretching out my hand.”
― Yennefer of Vengerberg, the Software Engineer
SQL Server has MERGE.
MySQL has REPLACE INTO.
PostgreSQL has UPSERT.
They all do more or less the same thing.
we are here on a spinning rock in a decaying body in the middle of nowhere and no one knows how or why
Fosstodon is an English speaking Mastodon instance that is open to anyone who is interested in technology; particularly free & open source software.