HOW TO FIX ERROR THAT IS NOT CORRESPOND WITH MARIADB/MYSQL VERSION FOR THE RIGHT SYNTAX.. First error: SQLState: 42000 Error Code: 1064

10 views
Skip to first unread message

Anh Đức Vũ

unread,
Dec 27, 2021, 10:11:46 PM12/27/21
to sdc-user
My Streamset loading get this error but i don't know how to fix it. In detail, i paste the error and pineline image here. Many thanks for helping 

com.streamsets.pipeline.api.StageException: JDBC_77 - SQLSyntaxErrorException attempting to execute query 'SELECT ID AS product_id, AMOUNT AS amount, MODIFIED_DATE FROM TBL_PRODUCT WHERE MODIFIED_DATE > 2021-12-27 17:31:43 ORDER BY MODIFIED_DATE'. 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 MariaDB server version for the right syntax to use near '17:31:43 ORDER BY MODIFIED_DATE' at line 6 

Screen Shot 2021-12-28 at 10.07.35 AM.png

This error appear when i have verified and the pineline have run, the Mariadb database received full data successfully. But then this error came
Reply all
Reply to author
Forward
0 new messages