[TRAFODION-2830] odb export will scan full table with splitby column

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.1-incubating
• Fix Version/s: 2.4
• Component/s: db-utility-odb
• Assignee: 苏锦佩
• Reporter: 苏锦佩
• Created: 06/Dec/17 08:42
• Updated: 16/Apr/20 02:19

Description

use odb to extract data parallel with splitby column, when get min/max value from table, it will missing pwhere condition.

step to reproduce:

odb64luo -u db__root -p xx -d traf -e "src=cdr:pwhere=[service_id > 100]:tgt=cdr.txt:parallel=4:splitby=service_id",

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

Issue Links

• links to: GitHub Pull Request #1325