Question

JDBC Multitable consumer throws error for UUID format offset column


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


7 replies

Userlevel 3
Badge

Is it possible that there are null values in that column, @ramakrishna_rao? What is the column’s data type?

it’s a postgresql column, the data type is UUID.

Userlevel 3
Badge

Is it possible that there are null values in that column, @ramakrishna_rao?

it’s a non-null column.

Userlevel 3
Badge

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.

Userlevel 3
Badge

Gotcha. Please open a support ticket so that our engineers can take a closer look. 

Reply