[ 
https://issues.apache.org/jira/browse/APEXMALHAR-2172?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15405726#comment-15405726
 ] 

ASF GitHub Bot commented on APEXMALHAR-2172:
--------------------------------------------

Github user bhupeshchawda commented on a diff in the pull request:

    https://github.com/apache/apex-malhar/pull/358#discussion_r73319381
  
    --- Diff: 
library/src/main/java/com/datatorrent/lib/db/jdbc/AbstractJdbcPollInputOperator.java
 ---
    @@ -51,22 +64,22 @@
     import com.datatorrent.lib.util.KryoCloneUtils;
     import com.datatorrent.netlet.util.DTThrowable;
     
    +import static java.sql.ResultSet.CONCUR_READ_ONLY;
    +import static java.sql.ResultSet.TYPE_FORWARD_ONLY;
    +import static org.jooq.impl.DSL.field;
    +
     /**
      * Abstract operator for for consuming data using JDBC interface<br>
    - * User needs User needs to provide
    - * tableName,dbConnection,setEmitColumnList,look-up key <br>
    - * Optionally batchSize,pollInterval,Look-up key and a where clause can be 
given
    - * <br>
    + * User needs to provide tableName, dbConnection, columnsExpression, 
look-up key<br>
    + * Optionally batchSize, pollInterval and a where clause can be given <br>
      * This operator uses static partitioning to arrive at range queries for 
exactly
      * once reads<br>
      * This operator will create a configured number of non-polling static
      * partitions for fetching the existing data in the table. And an 
additional
      * single partition for polling additive data. Assumption is that there is 
an
      * ordered column using which range queries can be formed<br>
    - * If an emitColumnList is provided, please ensure that the keyColumn is 
the
    + * If an columnsExpression is provided, please ensure that the keyColumn 
is the
    --- End diff --
    
    If this is a list, better to call it a list, and not an expression


> Update JDBC poll input operator to fix issues
> ---------------------------------------------
>
>                 Key: APEXMALHAR-2172
>                 URL: https://issues.apache.org/jira/browse/APEXMALHAR-2172
>             Project: Apache Apex Malhar
>          Issue Type: Improvement
>            Reporter: Priyanka Gugale
>            Assignee: Priyanka Gugale
>
> Update JDBCPollInputOperator to:
> 1. Fix small bugs
> 2. Use jooq query dsl library to construct sql queries
> 3. Make code more readable
> 4. Use row counts rather than key column values to partition reads



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to