Symptom
- When IQ uses multi threads on LOAD TABLE, rowids of imported data may be discontinuous. Below is the result of ' SELECT *, rowid(test) RI from test ORDER BY RI asc' after LOAD TABLE, the last column shows rowids. Rowid jumps from 13892 to 67108865.
'1' '4276558271' '2015-08-09' 'A.E.49' 1700 201508 '1073' 13891
'1' '4101800464' '2015-08-09' 490 201508 '0192' '3162' 13892
'9' '4943674221646' '2015-08-08' 'WPCR-16887' 2457 201510 'NONE' 'NONE' 67108865
'9' '4943674221783' '2015-08-08' 'WPCR-16889' 2200 201510 'NONE' 'NONE' 67108866
'9' '4943674217649' '2015-08-08' 'WPCS-13241' 2600 201510 'NONE' 'NONE' 67108867
- And there is possibility that rowids of imported data may not match the row order in original data file. Below is the result of ' SELECT *, rowid(test) RI from test ORDER BY RI asc' after LOAD TABLE, the last column shows rowids.
'9' '4988001777847' '2015-08-08' 'COCB-54176' 2800 201507 'NONE' 'NONE' 3969
'9' '4988001778356' '2015-08-08' 'COCB-54179' 3000 201507 'NONE' 'NONE' 3970
'9' '4988001777977' '2015-08-08' 'COCP-39180' 2200 201507 'NONE' 'NONE' 3971
'9' '4988001777984' '2015-08-08' 'COCP-39181' 2200 201507 'NONE' 'NONE' 3972
'9' '4988001778011' '2015-08-08' 'COCP-39182' 3241 201507 'NONE' 'NONE' 3973
'9' '4988001778028' '2015-08-08' 'COCP-39184' 3241 201507 'NONE' 'NONE' 3974
The original row order in data file, from row 3969 to row 3974, which are completely different from imported data.
9~4988002316014~20150808~VICL-8129~0002718~199506~NONE~NONE 3969
9~4988002387809~20150808~VICL-41072~0002400~199908~NONE~NONE 3970
9~4988002388196~20150808~VICL-41085~0002200~199908~NONE~NONE 3971
9~4988002353408~20150808~VICL-60049~0001900~199706~NONE~NONE 3972
9~4988002354603~20150808~VICL-60072~0002900~199709~NONE~NONE 3973
9~4988002369720~20150808~VICL-60253~0002900~199807~NONE~NONE 3974
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Read more...
Environment
- SAP IQ 16.0
Product
SAP IQ 16.0
Keywords
load table, rowid, thread, query plan, order , KBA , BC-SYB-IQ , Sybase IQ , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.