Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Can't JDBC Query Consumer incremental mode work with DateTime type offset?

image description

Can't JDBC Query Consumer incremental mode work with DateTime type offset?

After click "Run" button, the pipeline worked well and the data ingested into HBase as expected, but after drift all records in MySQL and no more new records in, it complains the following error message: Pipeline Status: RUNNING_ERROR: com.streamsets.pipeline.api.StageException: JDBC_77 - MySQLSyntaxErrorException attempting to execute query 'SELECT * FROM d_landa_yys_info WHERE updated_at > 2017-11-06 14:20:08.0 ORDER BY updated_at'. Giving up after 1 errors as per stage configuration. First error: SQLState: 42000 Error Code: 1064 Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '14:20:08.0 ORDER BY updated_at' at line 1

image description

Can't JDBC Query Consumer incremental mode work with DateTime type offset?

After click "Run" button, the pipeline worked well and the data ingested into HBase as expected, but after drift all records in MySQL and no more new records in, it complains the following error message: message:

Pipeline Status: RUNNING_ERROR: com.streamsets.pipeline.api.StageException: JDBC_77 - MySQLSyntaxErrorException attempting to execute query 'SELECT * FROM d_landa_yys_info WHERE updated_at > 2017-11-06 14:20:08.0 ORDER BY updated_at'. Giving up after 1 errors as per stage configuration. First error: SQLState: 42000 Error Code: 1064 Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '14:20:08.0 ORDER BY updated_at' at line 1

image description

Can't JDBC Query Consumer incremental mode work with DateTime type offset?

After click "Run" button, the pipeline worked well and the data ingested into HBase as expected, but after drift all records in MySQL and no more new records in, it complains the following error message:

Pipeline Status: RUNNING_ERROR: com.streamsets.pipeline.api.StageException: JDBC_77 - MySQLSyntaxErrorException attempting to execute query 'SELECT * FROM d_landa_yys_info WHERE updated_at > 2017-11-06 14:20:08.0 ORDER BY updated_at'. Giving up after 1 errors as per stage configuration. First error: SQLState: 42000 Error Code: 1064 Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '14:20:08.0 ORDER BY updated_at' at line 1

image description

Can't JDBC Query Consumer incremental mode work with DateTime type offset?offset column?

After click "Run" button, the pipeline worked well and the data ingested into HBase as expected, but after drift all records in MySQL and no more new records come in, it complains the following error message:

Pipeline Status: RUNNING_ERROR: com.streamsets.pipeline.api.StageException: JDBC_77 - MySQLSyntaxErrorException attempting to execute query 'SELECT * FROM d_landa_yys_info WHERE updated_at > 2017-11-06 14:20:08.0 ORDER BY updated_at'. Giving up after 1 errors as per stage configuration. First error: SQLState: 42000 Error Code: 1064 Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '14:20:08.0 ORDER BY updated_at' at line 1

image description