Fix: S3 sink when using envelope did not handle messages with null Value correctly

5.0.0 Release

All Connectors

• Test Fixes and E2E Test Clean-up: Improved testing with bug fixes and end-to-end test clean-up.
• Code Optimization: Removed unused code and converted Java code and tests to Scala for enhanced performance. (TODO =
  it's not clear what performance enhancements it made by the Java to Scala)
• Ascii Art Loading Fix: Resolved issues related to ASCII art loading.
• Build System Updates: Implemented build system updates and improvements.
• Stream Reactor Integration: Integrated Kafka-connect-query-language inside of Stream Reactor for enhanced
  compatibility.
• STOREAS Consistency: Ensured consistent handling of backticks with STOREAS.

AWS S3 Connector

The source and sink has been the focus of this release.

S3 Source & Sink

• Full message backup. The S3 sink and source now supports full message backup. This is enabled by adding in the
  KCQL PROPERTIES('store.envelope'=true)
• Removed Bytes_*** storage format. For those users leveraging them there is a migration information below. Storing raw
  Kafka message the storage format should be AVRO/PARQUET/JSON(less ideal).
• Introduced support for BYTES storing single message as raw binary. Typically, storing images or videos are the use
  case
  for this. This is enabled by adding in the KCQL STOREAS BYTES
• Introduced support for PROPERTIES to drive new settings required to drive the connectors' behaviour. The KCQL looks
  like this: INSERT INTO ... SELECT ... FROM ... PROPERTIES(property=key, ...)

Sink

• Enhanced PARTITIONBY Support: expanded support for PARTITIONBY fields, now accommodating fields containing dots. For
  instance, you can use PARTITIONBY a, `field1.field2` for enhanced partitioning control.
• Advanced Padding Strategy: a more advanced padding strategy configuration. By default, padding is now enforced,
  significantly improving compatibility with S3 Source.
• Improved Error Messaging: Enhancements have been made to error messaging, providing clearer guidance, especially in
  scenarios with misaligned topic configurations (#978).
• Commit Logging Refactoring: Refactored and simplified the CommitPolicy for more efficient commit logging (#964).
• Comprehensive Testing: Added additional unit testing around configuration settings, removed redundancy from property
  names, and enhanced KCQL properties parsing to support Map structures.
• Consolidated Naming Strategies: Merged naming strategies to reduce code complexity and ensure consistency. This effort
  ensures that both hierarchical and custom partition modes share similar code paths, addressing issues related to
  padding and the inclusion of keys and values within the partition name.
• Optimized S3 API Calls: Switched from using deleteObjects to deleteObject for S3 API client calls (#957), enhancing
  performance and efficiency.
• JClouds Removal: The update removes the use of JClouds, streamlining the codebase.
• Legacy Offset Seek Removal: The release eliminates legacy offset seek operations, simplifying the code and enhancing
  overall efficiency

Source

• Expanded Text Reader Support: new text readers to enhance data processing flexibility, including:
  • Regex-Driven Text Reader: Allows parsing based on regular expressions.
  • Multi-Line Text Reader: Handles multi-line data.
  • Start-End Tag Text Reader: Processes data enclosed by start and end tags, suitable for XML content.
• Improved Parallelization: enhancements enable parallelization based on the number of connector tasks and available
  data partitions, optimizing data handling.
• Data Consistency: Resolved data loss and duplication issues when the connector is restarted, ensuring
  reliable data transfer.
• Dynamic Partition Discovery: No more need to restart the connector when new partitions are added; runtime partition
  discovery streamlines operations.
• Efficient Storage Handling: The connector now ignores the .indexes directory, allowing data storage in an S3 bucket
  without a prefix.
• Increased Default Records per Poll: the default limit on the number of records returned per poll was changed from 1024
  to 10000, improving data retrieval efficiency and throughput.
• Ordered File Processing: Added the ability to process files in date order. This feature is especially useful when S3
  files lack lexicographical sorting, and S3 API optimisation cannot be leveraged. Please note that it involves reading
  and sorting files in memory.
• Parquet INT96 Compatibility: The connector now allows Parquet INT96 to be read as a fixed array, preventing runtime
  failures.

Kudu and Hive

• The Kudu and Hive connectors are now deprecated and will be removed in a future release.

InfluxDB

• Fixed a memory issue with the InfluxDB writer.
• Upgraded to Influxdb2 client (note: doesn't yet support Influxdb2 connections).

S3 upgrade notes

Upgrading from 5.0.0 (preview) to 5.0.0

For installations that have been using the preview version of the S3 connector and are upgrading to the release, there
are a few important considerations:

Previously, default padding was enabled for both "offset" and "partition" values starting in June.

However, in version 5.0, the decision to apply default padding to the "offset" value only, leaving the "
partition" value without padding. This change was made to enhance compatibility with querying in Athena.

If you have been using a build from the master branch since June, your connectors might have been configured with a
different default padding setting.

To maintain consistency and ensure your existing connector configuration remains valid, you will need to use KCQL
configuration properties to customize the padding fields accordingly.

INSERT INTO $bucket[:$prefix]
SELECT *
FROM $topic
...
PROPERTIES(
  'padding.length.offset'=12,
  'padding.length.partition'=12
)

Upgrading from 4.x to 5.0.0

Starting with version 5.0.0, the following configuration keys have been replaced.

Upgrading from 4.1.* and 4.2.0

In version 4.1, padding options were available but were not enabled by default. At that time, the default padding
length, if not specified, was set to 8 characters.

However, starting from version 5.0, padding is now enabled by default, and the default padding length has been increased
to 12 characters.

Enabling padding has a notable advantage: it ensures that the files written are fully compatible with the Lenses Stream
Reactor S3 Source, enhancing interoperability and data integration.

Sinks created with 4.2.0 and 4.2.1 should retain the padding behaviour, and, therefore should disable padding:

INSERT INTO $bucket[:$prefix]
SELECT *
FROM $topic
...
PROPERTIES (
  'padding.type'=NoOp
)

If padding was enabled in 4.1, then the padding length should be specified in the KCQL statement:

INSERT INTO $bucket[:$prefix]
SELECT *
FROM $topic
...
PROPERTIES (
  'padding.length.offset'=12,
  'padding.length.partition'=12
)

Upgrading from 4.x to 5.0.0 only when STOREAS Bytes_*** is used

The Bytes_*** storage format has been removed. If you are using this storage format, you will need to install the
5.0.0-deprecated connector and upgrade the connector instances by changing the class name:

Source Before:

class.name=io.lenses.streamreactor.connect.aws.s3.source.S3SourceConnector 
...

Source After:

class.name=io.lenses.streamreactor.connect.aws.s3.source.S3SourceConnectorDeprecated
... 

Sink Before:

class.name=io.lenses.streamreactor.connect.aws.s3.sink.S3SinkConnector
...

Sink After:

class.name=io.lenses.streamreactor.connect.aws.s3.sink.S3SinkConnectorDeprecated
connect.s3.padding.strategy=NoOp
...

The deprecated connector won't be developed any further and will be removed in a future release.
If you want to talk to us about a migration plan, please get in touch with us at [email protected].

Upgrade a connector configuration

To migrate to the new configuration, please follow the following steps:

• stop all running instances of the S3 connector
• upgrade the connector to 5.0.0
• update the configuration to use the new properties
• resume the stopped connectors

3.0.1

3.0.0

2.1.3

2.1.2

2.1.1

2.1.0

2.0.0

1.2.7

1.2.6

1.2.5

Bug fixes

• JMS Source

  Ack the JMS messages was not always possible. Also there was an issue with producing the messages to Kafka out of order from the JMS queue.
  Changes:

  • Queue messages order are retained when published to Kafka (although they might be routed to different partitions)
  • Ack happens for each message. This is a change from previous behaviour.
  • Records which fail to be committed to Kafka are not ack-ed on JMS side

Release Notes:

Features

Influx

• Support for referencing _key values
• Support Unix timestamp as double

MQTT

• Replicate shared subscription to all tasks
• Add sink config to specify retained messages
• Add a config to specify retained messages

Hazelcast

• SSL support

MongoDB

• SSL support
• Removing database name dashes restriction

FTP

• FTPS support

Bug fixes

Hive:

• Fix for writing nested structures to Hive
• Improves the code for the async function call to use the CAS

Release Notes:

Features

Redis

• TTL Support
• SSL support
• AWS ElasticCache support
• GEOADD support
• PUB/SUB support

MQTT

• Multi server connection
• Dynamic Target support

Hive

• Kerberos support

Kudu

• Comma separated master endpoints

Bug fixes

Redis:

• Topic regex

JMS:

• Filters out Kafka records with null value

Cassandra:

• Timestamp comparison

Mongo:

• Memory leak

Cassandra

• PK check for incremental

1.2.1