We have tables which are basically mapping of relationships between different entities as such these tables just include UUID columns representing the relationships. We are unable to read these tables from JDBC multitable consumer as it gives offset error as below. How do we make them work for such tables.
Error:
START_ERROR: JDBC_69 - Unsupported Offset Column Types. <Column-name> - 1111.
Data Collector Enginer Version: 4.0.1
StreamSets Control Hub: 3.22.3
Is it possible that there are null values in that column,
it’s a postgresql column, the data type is UUID.
Is it possible that there are null values in that column,
it’s a non-null column.
Are you absolutely certain that no rows in your table have a null value for that column?
Yes, it’s a non-null column, this table works fine with JDBC Query Consumer, however with JDBC multitable it throws that error mentioned.
Gotcha. Please open a support ticket so that our engineers can take a closer look.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.