[
https://issues.apache.org/jira/browse/TRAFODION-2830?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16291256#comment-16291256
]
ASF GitHub Bot commented on TRAFODION-2830:
-------------------------------------------
Github user asfgit closed the pull request at:
https://github.com/apache/incubator-trafodion/pull/1325
> odb export will scan full table with splitby column
> ---------------------------------------------------
>
> Key: TRAFODION-2830
> URL: https://issues.apache.org/jira/browse/TRAFODION-2830
> Project: Apache Trafodion
> Issue Type: Improvement
> Components: db-utility-odb
> Affects Versions: 2.1-incubating
> Reporter: 苏锦佩
> Assignee: 苏锦佩
> Fix For: 2.2-incubating
>
>
> use odb to extract data parallel with splitby column, when get min/max value
> from table, it will missing pwhere condition.
> step to reproduce:
> {code:java}
> odb64luo -u db__root -p xx -d traf -e "src=cdr:pwhere=[service_id >
> 100]:tgt=cdr.txt:parallel=4:splitby=service_id",
> {code}
> we can got the query to get min/max service_id,it is full table scan, the
> query missing the [service_id > 100] condition.
> {code:java}
> [trafodion@esggy-poc-n012 ~]$ offender -s active
> EsgynDB Advanced Conversational Interface 2.3.0
> Copyright (c) 2015-2017 Esgyn Corporation
> >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>+>+>+>+>+>+>+>+>+>+>+>+>+>
> CURRENT_TIMESTAMP LAST_ACTIVITY_SECS QUERY_ID EXECUTE_STATE SOURCE_TEXT
> -------------------------- --------------------
> --------------------------------------------------------------------------------
> 2017-12-05 11:58:34.230648 18
> MXID11003044725212379117598127226000000000206U3333308T150000000_32_SQL_CUR_13
> OPEN "SELECT MIN(SERVICE_ID), MAX(SERVICE_ID) FROM CDR
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
