苏锦佩 created TRAFODION-2830:
------------------------------
Summary: 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.
[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
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
