[
https://issues.apache.org/jira/browse/TRAFODION-2830?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16279979#comment-16279979
]
ASF GitHub Bot commented on TRAFODION-2830:
-------------------------------------------
GitHub user SuJinpei opened a pull request:
https://github.com/apache/incubator-trafodion/pull/1325
fix TRAFODION-2830
odb will try to get max(splitby) and min(splitby) to split to multithread,
we can apply pwhere condition in this stage to improve performance.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/SuJinpei/incubator-trafodion trafodion-2830
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/1325.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #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)
