Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

I upgraded hbase to 1.3.1 version and apache phoenix to apache-phoenix-4.12.0-HBase-1.3-bin, then tried again with JDBC Producer destination, it shows the following error. I guess apache phoenix doesn't support "INSERT" and "UPDATE" statements but only "UPSERT" statement. So, How can I work around it? Thanks!

Ps: I also tried config "Default Operation" as "UPDATE", a new error occurs: "Pipeline Status: RUNNING_ERROR: com.streamsets.pipeline.api.StageException: JDBC_14 - Error processing batch. java.util.concurrent.ExecutionException: org.apache.phoenix.exception.PhoenixParserException: ERROR 602 (42P00): Syntax error. Missing "STATISTICS" at line 1, column 8."

image description