[
https://issues.apache.org/jira/browse/CASSANDRA-6137?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13795695#comment-13795695
]
Constance Eustace edited comment on CASSANDRA-6137 at 10/15/13 9:54 PM:
------------------------------------------------------------------------
FAILURES:
ID: f924f134-31e0-11e3-b605-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_name, __CPSYS_type, urn@bby@pcm@job@ingest@content@warn@count] to
[__CPSYS_links, __CPSYS_name, __CPSYS_type] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'f924f134-31e0-11e3-b605-001c42000009-CJOB' AND p_prop IN
('__CPSYS_type','__CPSYS_name','urn@bby@pcm@job@ingest@content@warn@count','__CPSYS_links')
ID: b529bc94-31e5-11e3-9bd1-001c42000009-CJOB NOMATCH: [__CPSYS_name,
__CPSYS_type, subPropA@filttest@sdf,
urn@bby@pcm@job@ingest@content@complete@count] to [__CPSYS_name, __CPSYS_type,
subPropA@filttest@sdf] CQL: SELECT * FROM wayfair_submission.entity_job WHERE
e_entid = 'b529bc94-31e5-11e3-9bd1-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@job@ingest@content@complete@count','subPropA@filttest@sdf','__CPSYS_name','__CPSYS_type')
ID: a4a023f3-31ef-11e3-84cd-001c42000009-CJOB NOMATCH: [__CPSYS_type,
urn@bby@pcm@ingest@status, urn@bby@pcm@job@ingest@content@complete@count,
urn@bby@pcm@job@sourceparty@reference@id] to [__CPSYS_type,
urn@bby@pcm@ingest@status, urn@bby@pcm@job@sourceparty@reference@id] CQL:
SELECT * FROM wayfair_submission.entity_job WHERE e_entid =
'a4a023f3-31ef-11e3-84cd-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@job@ingest@content@complete@count','urn@bby@pcm@ingest@status','__CPSYS_type','urn@bby@pcm@job@sourceparty@reference@id')
ID: b81e318b-31f2-11e3-bc88-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_name, __CPSYS_type, urn@bby@pcm@job@ingest@content@complete@count] to
[__CPSYS_links, __CPSYS_name, __CPSYS_type] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'b81e318b-31f2-11e3-bc88-001c42000009-CJOB' AND p_prop IN
('__CPSYS_links','__CPSYS_name','__CPSYS_type','urn@bby@pcm@job@ingest@content@complete@count')
ID: 58a032e8-31f1-11e3-84cd-001c42000009-CJOB NOMATCH: [__CPSYS_links,
subPropA@filttest@sdf, urn@bby@pcm@ingest@data,
urn@bby@pcm@job@sourceparty@reference@id] to [__CPSYS_links,
subPropA@filttest@sdf, urn@bby@pcm@job@sourceparty@reference@id] CQL: SELECT *
FROM wayfair_submission.entity_job WHERE e_entid =
'58a032e8-31f1-11e3-84cd-001c42000009-CJOB' AND p_prop IN
('subPropA@filttest@sdf','urn@bby@pcm@ingest@data','__CPSYS_links','urn@bby@pcm@job@sourceparty@reference@id')
ID: 4a3ba684-31e2-11e3-9fbe-001c42000009-CJOB NOMATCH: [__CPSYS_name,
__CPSYS_type, subPropA@filttest@sdf,
urn@bby@pcm@job@ingest@content@complete@count] to [__CPSYS_name, __CPSYS_type,
subPropA@filttest@sdf] CQL: SELECT * FROM wayfair_submission.entity_job WHERE
e_entid = '4a3ba684-31e2-11e3-9fbe-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@job@ingest@content@complete@count','subPropA@filttest@sdf','__CPSYS_type','__CPSYS_name')
ID: 4a456a81-31e2-11e3-9fbe-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_type, subPropA@filttest@sdf, urn@bby@pcm@job@ingest@content@hold@count]
to [__CPSYS_links, __CPSYS_type, subPropA@filttest@sdf] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'4a456a81-31e2-11e3-9fbe-001c42000009-CJOB' AND p_prop IN
('__CPSYS_type','subPropA@filttest@sdf','__CPSYS_links','urn@bby@pcm@job@ingest@content@hold@count')
ID: b51ff891-31e5-11e3-9bd1-001c42000009-CJOB NOMATCH: [__CPSYS_name,
__CPSYS_type, urn@bby@pcm@job@ingest@content@complete@count,
urn@bby@pcm@job@ingest@content@fail@count] to [__CPSYS_name, __CPSYS_type,
urn@bby@pcm@job@ingest@content@fail@count] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'b51ff891-31e5-11e3-9bd1-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@job@ingest@content@fail@count','__CPSYS_name','__CPSYS_type','urn@bby@pcm@job@ingest@content@complete@count')
ID: b96383c2-31e7-11e3-9392-001c42000009-CJOB NOMATCH: [__CPSYS_name,
__CPSYS_type, urn@bby@pcm@ingest@data,
urn@bby@pcm@job@ingest@content@complete@count] to [__CPSYS_name, __CPSYS_type,
urn@bby@pcm@ingest@data] CQL: SELECT * FROM wayfair_submission.entity_job WHERE
e_entid = 'b96383c2-31e7-11e3-9392-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@ingest@data','__CPSYS_name','urn@bby@pcm@job@ingest@content@complete@count','__CPSYS_type')
ID: f6748b53-31ed-11e3-ab0d-001c42000009-CJOB NOMATCH: [__CPSYS_type,
urn@bby@pcm@ingest@status, urn@bby@pcm@job@ingest@content@fail@count,
urn@bby@pcm@job@sourceparty@reference@id] to [__CPSYS_type,
urn@bby@pcm@ingest@status, urn@bby@pcm@job@sourceparty@reference@id] CQL:
SELECT * FROM wayfair_submission.entity_job WHERE e_entid =
'f6748b53-31ed-11e3-ab0d-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@job@sourceparty@reference@id','urn@bby@pcm@ingest@status','urn@bby@pcm@job@ingest@content@fail@count','__CPSYS_type')
ID: b951d081-31e7-11e3-9392-001c42000009-CJOB NOMATCH:
[DISABLED__SYSTEM__BYPASS__PROP__SUBSET__, __CPSYS_links,
subPropA@filttest@sdf, urn@bby@pcm@job@ingest@content@success@count] to
[DISABLED__SYSTEM__BYPASS__PROP__SUBSET__, __CPSYS_links,
subPropA@filttest@sdf] CQL: SELECT * FROM wayfair_submission.entity_job WHERE
e_entid = 'b951d081-31e7-11e3-9392-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@job@ingest@content@success@count','DISABLED__SYSTEM__BYPASS__PROP__SUBSET__','subPropA@filttest@sdf','__CPSYS_links')
ID: 6bc17ea0-31ed-11e3-89d8-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_name, __CPSYS_type, urn@bby@pcm@ingest@data] to [__CPSYS_links,
__CPSYS_name, __CPSYS_type] CQL: SELECT * FROM wayfair_submission.entity_job
WHERE e_entid = '6bc17ea0-31ed-11e3-89d8-001c42000009-CJOB' AND p_prop IN
('__CPSYS_type','__CPSYS_name','__CPSYS_links','urn@bby@pcm@ingest@data')
ID: d4241266-31f1-11e3-b75f-001c42000009-CJOB NOMATCH: [__CPSYS_name,
__CPSYS_type, subPropA@filttest@sdf, urn@bby@pcm@job@ingest@content@warn@count]
to [__CPSYS_name, __CPSYS_type, subPropA@filttest@sdf] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'd4241266-31f1-11e3-b75f-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@job@ingest@content@warn@count','__CPSYS_name','__CPSYS_type','subPropA@filttest@sdf')
ID: d7312824-31ed-11e3-961d-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_name, subPropA@filttest@sdf,
urn@bby@pcm@job@ingest@content@success@count] to [__CPSYS_links, __CPSYS_name,
subPropA@filttest@sdf] CQL: SELECT * FROM wayfair_submission.entity_job WHERE
e_entid = 'd7312824-31ed-11e3-961d-001c42000009-CJOB' AND p_prop IN
('subPropA@filttest@sdf','__CPSYS_links','__CPSYS_name','urn@bby@pcm@job@ingest@content@success@count')
ID: 0164c793-31f4-11e3-a64e-001c42000009-CJOB NOMATCH: [__CPSYS_name,
__CPSYS_type, urn@bby@pcm@ingest@data,
urn@bby@pcm@job@sourceparty@reference@id] to [__CPSYS_name, __CPSYS_type,
urn@bby@pcm@job@sourceparty@reference@id] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'0164c793-31f4-11e3-a64e-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@ingest@data','__CPSYS_name','__CPSYS_type','urn@bby@pcm@job@sourceparty@reference@id')
ID: f923dfc1-31e0-11e3-b605-001c42000009-CJOB NOMATCH: [__CPSYS_name,
__CPSYS_type, urn@bby@pcm@ingest@data,
urn@bby@pcm@job@ingest@content@hold@count] to [__CPSYS_name, __CPSYS_type,
urn@bby@pcm@ingest@data] CQL: SELECT * FROM wayfair_submission.entity_job WHERE
e_entid = 'f923dfc1-31e0-11e3-b605-001c42000009-CJOB' AND p_prop IN
('__CPSYS_type','__CPSYS_name','urn@bby@pcm@ingest@data','urn@bby@pcm@job@ingest@content@hold@count')
ID: d6e5bdb7-31e1-11e3-9912-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_type, subPropA@filttest@sdf, urn@bby@pcm@job@ingest@content@warn@count]
to [__CPSYS_links, __CPSYS_type, subPropA@filttest@sdf] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'd6e5bdb7-31e1-11e3-9912-001c42000009-CJOB' AND p_prop IN
('__CPSYS_type','__CPSYS_links','urn@bby@pcm@job@ingest@content@warn@count','subPropA@filttest@sdf')
ID: c8955af0-31e5-11e3-a033-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_name, __CPSYS_type, urn@bby@pcm@ingest@data] to [__CPSYS_links,
__CPSYS_name, __CPSYS_type] CQL: SELECT * FROM wayfair_submission.entity_job
WHERE e_entid = 'c8955af0-31e5-11e3-a033-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@ingest@data','__CPSYS_name','__CPSYS_links','__CPSYS_type')
ID: 2a370676-31f3-11e3-bf8b-001c42000009-CJOB NOMATCH: [__CPSYS_links,
subPropA@filttest@sdf, urn@bby@pcm@job@ingest@content@complete@count,
urn@bby@pcm@job@sourceparty@reference@id] to [__CPSYS_links,
subPropA@filttest@sdf, urn@bby@pcm@job@sourceparty@reference@id] CQL: SELECT *
FROM wayfair_submission.entity_job WHERE e_entid =
'2a370676-31f3-11e3-bf8b-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@job@ingest@content@complete@count','urn@bby@pcm@job@sourceparty@reference@id','subPropA@filttest@sdf','__CPSYS_links')
ID: 63e93721-31ef-11e3-b50f-001c42000009-CJOB NOMATCH: [__CPSYS_type,
urn@bby@pcm@ingest@status, urn@bby@pcm@job@ingest@content@fail@count,
urn@bby@pcm@job@sourceparty@reference@id] to [__CPSYS_type,
urn@bby@pcm@ingest@status, urn@bby@pcm@job@sourceparty@reference@id] CQL:
SELECT * FROM wayfair_submission.entity_job WHERE e_entid =
'63e93721-31ef-11e3-b50f-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@job@sourceparty@reference@id','urn@bby@pcm@job@ingest@content@fail@count','urn@bby@pcm@ingest@status','__CPSYS_type')
ID: a3aa36c4-31e5-11e3-ad9c-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_name, __CPSYS_type, urn@bby@pcm@job@ingest@content@hold@count] to
[__CPSYS_links, __CPSYS_name, __CPSYS_type] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'a3aa36c4-31e5-11e3-ad9c-001c42000009-CJOB' AND p_prop IN
('__CPSYS_type','urn@bby@pcm@job@ingest@content@hold@count','__CPSYS_links','__CPSYS_name')
ID: 9b9fb120-31e6-11e3-a6c8-001c42000009-CJOB NOMATCH: [__CPSYS_name,
subPropA@filttest@sdf, urn@bby@pcm@ingest@data,
urn@bby@pcm@job@sourceparty@uid] to [__CPSYS_name, subPropA@filttest@sdf,
urn@bby@pcm@job@sourceparty@uid] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'9b9fb120-31e6-11e3-a6c8-001c42000009-CJOB' AND p_prop IN
('subPropA@filttest@sdf','urn@bby@pcm@ingest@data','__CPSYS_name','urn@bby@pcm@job@sourceparty@uid')
ID: f4d19773-31f2-11e3-b478-001c42000009-CJOB NOMATCH: [__CPSYS_name,
__CPSYS_type, subPropA@filttest@sdf, urn@bby@pcm@ingest@data] to [__CPSYS_name,
__CPSYS_type, subPropA@filttest@sdf] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'f4d19773-31f2-11e3-b478-001c42000009-CJOB' AND p_prop IN
('__CPSYS_name','subPropA@filttest@sdf','urn@bby@pcm@ingest@data','__CPSYS_type')
ID: bc6c9cb3-31f5-11e3-a5b8-001c42000009-CJOB NOMATCH: [__CPSYS_type,
subPropA@filttest@sdf, urn@bby@pcm@ingest@status,
urn@bby@pcm@job@ingest@content@success@count] to [__CPSYS_type,
subPropA@filttest@sdf, urn@bby@pcm@ingest@status] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'bc6c9cb3-31f5-11e3-a5b8-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@job@ingest@content@success@count','urn@bby@pcm@ingest@status','subPropA@filttest@sdf','__CPSYS_type')
ID: 043b4025-31f4-11e3-a64e-001c42000009-CJOB NOMATCH: [__CPSYS_name,
__CPSYS_type, urn@bby@pcm@job@ingest@content@hold@count,
urn@bby@pcm@job@ingest@content@success@count] to [__CPSYS_name, __CPSYS_type,
urn@bby@pcm@job@ingest@content@hold@count] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'043b4025-31f4-11e3-a64e-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@job@ingest@content@success@count','urn@bby@pcm@job@ingest@content@hold@count','__CPSYS_name','__CPSYS_type')
ID: b95c30c3-31e7-11e3-9392-001c42000009-CJOB NOMATCH: [__CPSYS_type,
subPropA@filttest@sdf, urn@bby@pcm@job@ingest@content@success@count,
urn@bby@pcm@job@ingest@content@warn@count] to [__CPSYS_type,
subPropA@filttest@sdf, urn@bby@pcm@job@ingest@content@success@count] CQL:
SELECT * FROM wayfair_submission.entity_job WHERE e_entid =
'b95c30c3-31e7-11e3-9392-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@job@ingest@content@success@count','subPropA@filttest@sdf','__CPSYS_type','urn@bby@pcm@job@ingest@content@warn@count')
ID: 4a44f552-31e2-11e3-9fbe-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_name, subPropA@filttest@sdf,
urn@bby@pcm@job@ingest@content@success@count] to [__CPSYS_links, __CPSYS_name,
subPropA@filttest@sdf] CQL: SELECT * FROM wayfair_submission.entity_job WHERE
e_entid = '4a44f552-31e2-11e3-9fbe-001c42000009-CJOB' AND p_prop IN
('__CPSYS_links','subPropA@filttest@sdf','__CPSYS_name','urn@bby@pcm@job@ingest@content@success@count')
ID: 9b93a333-31e6-11e3-a6c8-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_name, subPropA@filttest@sdf, urn@bby@pcm@job@ingest@content@warn@count]
to [__CPSYS_links, __CPSYS_name, subPropA@filttest@sdf] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'9b93a333-31e6-11e3-a6c8-001c42000009-CJOB' AND p_prop IN
('subPropA@filttest@sdf','__CPSYS_links','__CPSYS_name','urn@bby@pcm@job@ingest@content@warn@count')
ID: 559c1dd4-31f5-11e3-9684-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_name, urn@bby@pcm@ingest@status,
urn@bby@pcm@job@ingest@content@success@count] to [__CPSYS_links, __CPSYS_name,
urn@bby@pcm@ingest@status] CQL: SELECT * FROM wayfair_submission.entity_job
WHERE e_entid = '559c1dd4-31f5-11e3-9684-001c42000009-CJOB' AND p_prop IN
('__CPSYS_links','urn@bby@pcm@ingest@status','urn@bby@pcm@job@ingest@content@success@count','__CPSYS_name')
ID: 014e8073-31f4-11e3-a64e-001c42000009-CJOB NOMATCH: [__CPSYS_links,
subPropA@filttest@sdf, urn@bby@pcm@ingest@status,
urn@bby@pcm@job@ingest@content@complete@count] to [__CPSYS_links,
subPropA@filttest@sdf, urn@bby@pcm@ingest@status] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'014e8073-31f4-11e3-a64e-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@job@ingest@content@complete@count','urn@bby@pcm@ingest@status','__CPSYS_links','subPropA@filttest@sdf')
ID: 8a715897-31e6-11e3-9d0e-001c42000009-CJOB NOMATCH: [__CPSYS_links,
subPropA@filttest@sdf, urn@bby@pcm@ingest@data,
urn@bby@pcm@job@ingest@content@complete@count] to [__CPSYS_links,
subPropA@filttest@sdf] CQL: SELECT * FROM wayfair_submission.entity_job WHERE
e_entid = '8a715897-31e6-11e3-9d0e-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@ingest@data','__CPSYS_links','urn@bby@pcm@job@ingest@content@complete@count','subPropA@filttest@sdf')
ID: b96a1372-31e7-11e3-9392-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_name, __CPSYS_type, urn@bby@pcm@job@ingest@content@complete@count] to
[__CPSYS_links, __CPSYS_name, __CPSYS_type] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'b96a1372-31e7-11e3-9392-001c42000009-CJOB' AND p_prop IN
('__CPSYS_name','__CPSYS_links','urn@bby@pcm@job@ingest@content@complete@count','__CPSYS_type')
ID: 6bbc9ca1-31ed-11e3-89d8-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_name, urn@bby@pcm@job@ingest@content@hold@count,
urn@bby@pcm@job@ingest@content@success@count] to [__CPSYS_links, __CPSYS_name,
urn@bby@pcm@job@ingest@content@success@count] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'6bbc9ca1-31ed-11e3-89d8-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@job@ingest@content@hold@count','__CPSYS_name','__CPSYS_links','urn@bby@pcm@job@ingest@content@success@count')
ID: a1731f91-31f2-11e3-bc88-001c42000009-CJOB NOMATCH: [__CPSYS_links,
subPropA@filttest@sdf, urn@bby@pcm@ingest@status,
urn@bby@pcm@job@ingest@content@success@count] to [__CPSYS_links,
subPropA@filttest@sdf, urn@bby@pcm@ingest@status] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'a1731f91-31f2-11e3-bc88-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@ingest@status','__CPSYS_links','subPropA@filttest@sdf','urn@bby@pcm@job@ingest@content@success@count')
ID: b95d4232-31e7-11e3-9392-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_type, subPropA@filttest@sdf, urn@bby@pcm@job@ingest@content@fail@count]
to [__CPSYS_links, __CPSYS_type, subPropA@filttest@sdf] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'b95d4232-31e7-11e3-9392-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@job@ingest@content@fail@count','subPropA@filttest@sdf','__CPSYS_links','__CPSYS_type')
ID: a49d16b1-31ef-11e3-84cd-001c42000009-CJOB NOMATCH: [__CPSYS_name,
subPropA@filttest@sdf, urn@bby@pcm@ingest@status,
urn@bby@pcm@job@ingest@content@success@count] to [__CPSYS_name,
subPropA@filttest@sdf, urn@bby@pcm@ingest@status] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'a49d16b1-31ef-11e3-84cd-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@ingest@status','__CPSYS_name','urn@bby@pcm@job@ingest@content@success@count','subPropA@filttest@sdf')
ID: a4c49be4-31ef-11e3-84cd-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_name, __CPSYS_type, urn@bby@pcm@job@ingest@content@success@count] to
[__CPSYS_links, __CPSYS_name, __CPSYS_type] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'a4c49be4-31ef-11e3-84cd-001c42000009-CJOB' AND p_prop IN
('__CPSYS_name','__CPSYS_type','__CPSYS_links','urn@bby@pcm@job@ingest@content@success@count')
ID: 26d00223-31fd-11e3-82e6-001c42000009-CJOB NOMATCH: [subPropA:filttest:sdf,
urn:bby:pcm:ingest:status, urn@bby@pcm@job@ingest@content@complete@count,
urn@bby@pcm@job@ingest@content@fail@count] to [subPropA:filttest:sdf,
urn:bby:pcm:ingest:status, urn@bby@pcm@job@ingest@content@fail@count] CQL:
SELECT * FROM wayfair_submission.entity_job WHERE e_entid =
'26d00223-31fd-11e3-82e6-001c42000009-CJOB' AND p_prop IN
('subPropA:filttest:sdf','urn@bby@pcm@job@ingest@content@fail@count','urn@bby@pcm@job@ingest@content@complete@count','urn:bby:pcm:ingest:status')
ID: f67e4f54-31ed-11e3-ab0d-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_name, subPropA@filttest@sdf,
urn@bby@pcm@job@ingest@content@complete@count] to [__CPSYS_links, __CPSYS_name,
subPropA@filttest@sdf] CQL: SELECT * FROM wayfair_submission.entity_job WHERE
e_entid = 'f67e4f54-31ed-11e3-ab0d-001c42000009-CJOB' AND p_prop IN
('subPropA@filttest@sdf','urn@bby@pcm@job@ingest@content@complete@count','__CPSYS_name','__CPSYS_links')
ID: a38879c3-31ec-11e3-b2d5-001c42000009-CJOB NOMATCH: [subPropA@filttest@sdf,
urn:bby:pcm:job:sourceparty:reference:id,
urn@bby@pcm@job@ingest@content@fail@count,
urn@bby@pcm@job@sourceparty@reference@id] to [subPropA@filttest@sdf,
urn:bby:pcm:job:sourceparty:reference:id,
urn@bby@pcm@job@sourceparty@reference@id] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'a38879c3-31ec-11e3-b2d5-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@job@sourceparty@reference@id','subPropA@filttest@sdf','urn@bby@pcm@job@ingest@content@fail@count','urn:bby:pcm:job:sourceparty:reference:id')
ID: 97233243-31fd-11e3-97f7-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_name, subPropA:filttest:sdf, urn@bby@pcm@ingest@data] to
[__CPSYS_links, __CPSYS_name, subPropA:filttest:sdf] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'97233243-31fd-11e3-97f7-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@ingest@data','subPropA:filttest:sdf','__CPSYS_links','__CPSYS_name')
ID: f9142853-31e0-11e3-b605-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_type, subPropA@filttest@sdf, urn@bby@pcm@job@ingest@content@fail@count]
to [__CPSYS_links, __CPSYS_type, subPropA@filttest@sdf] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'f9142853-31e0-11e3-b605-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@job@ingest@content@fail@count','__CPSYS_type','__CPSYS_links','subPropA@filttest@sdf')
ID: 2170bdd3-31e7-11e3-a934-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_name, urn@bby@pcm@ingest@status,
urn@bby@pcm@job@ingest@content@warn@count] to [__CPSYS_links, __CPSYS_name,
urn@bby@pcm@ingest@status] CQL: SELECT * FROM wayfair_submission.entity_job
WHERE e_entid = '2170bdd3-31e7-11e3-a934-001c42000009-CJOB' AND p_prop IN
('__CPSYS_links','urn@bby@pcm@ingest@status','urn@bby@pcm@job@ingest@content@warn@count','__CPSYS_name')
ID: d0c65120-31e0-11e3-aa5a-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_name, subPropA@filttest@sdf,
urn@bby@pcm@job@ingest@content@complete@count] to [__CPSYS_links, __CPSYS_name,
subPropA@filttest@sdf] CQL: SELECT * FROM wayfair_submission.entity_job WHERE
e_entid = 'd0c65120-31e0-11e3-aa5a-001c42000009-CJOB' AND p_prop IN
('__CPSYS_name','subPropA@filttest@sdf','__CPSYS_links','urn@bby@pcm@job@ingest@content@complete@count')
ID: f4dedde4-31f2-11e3-b478-001c42000009-CJOB NOMATCH: [__CPSYS_name,
urn:bby:pcm:ingest:status, urn@bby@pcm@ingest@data,
urn@bby@pcm@job@sourceparty@reference@id] to [__CPSYS_name,
urn:bby:pcm:ingest:status, urn@bby@pcm@job@sourceparty@reference@id] CQL:
SELECT * FROM wayfair_submission.entity_job WHERE e_entid =
'f4dedde4-31f2-11e3-b478-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@ingest@data','__CPSYS_name','urn:bby:pcm:ingest:status','urn@bby@pcm@job@sourceparty@reference@id')
ID: 4c8eebb3-31ea-11e3-9c73-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_name, bby@submission@SourceIP, urn@bby@pcm@ingest@data] to
[__CPSYS_links, __CPSYS_name, bby@submission@SourceIP] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'4c8eebb3-31ea-11e3-9c73-001c42000009-CJOB' AND p_prop IN
('__CPSYS_name','bby@submission@SourceIP','__CPSYS_links','urn@bby@pcm@ingest@data')
ID: b61aa4e2-31e8-11e3-8ea5-001c42000009-CJOB NOMATCH: [__CPSYS_name,
__CPSYS_type, subPropA@filttest@sdf, urn@bby@pcm@job@ingest@content@warn@count]
to [__CPSYS_name, __CPSYS_type, subPropA@filttest@sdf] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'b61aa4e2-31e8-11e3-8ea5-001c42000009-CJOB' AND p_prop IN
('subPropA@filttest@sdf','urn@bby@pcm@job@ingest@content@warn@count','__CPSYS_type','__CPSYS_name')
ID: d0c2ceb0-31e0-11e3-aa5a-001c42000009-CJOB NOMATCH: [__CPSYS_name,
__CPSYS_type, subPropA@filttest@sdf, urn@bby@pcm@job@ingest@content@warn@count]
to [__CPSYS_name, __CPSYS_type, subPropA@filttest@sdf] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'd0c2ceb0-31e0-11e3-aa5a-001c42000009-CJOB' AND p_prop IN
('subPropA@filttest@sdf','__CPSYS_name','urn@bby@pcm@job@ingest@content@warn@count','__CPSYS_type')
ID: 21759fd4-31e7-11e3-a934-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_name, subPropA@filttest@sdf,
urn@bby@pcm@job@ingest@content@complete@count] to [__CPSYS_links, __CPSYS_name,
subPropA@filttest@sdf] CQL: SELECT * FROM wayfair_submission.entity_job WHERE
e_entid = '21759fd4-31e7-11e3-a934-001c42000009-CJOB' AND p_prop IN
('subPropA@filttest@sdf','__CPSYS_links','urn@bby@pcm@job@ingest@content@complete@count','__CPSYS_name')
ID: 6efa2222-31f2-11e3-b7b8-001c42000009-CJOB NOMATCH: [__CPSYS_name,
subPropA@filttest@sdf, urn@bby@pcm@ingest@status,
urn@bby@pcm@job@ingest@content@fail@count] to [__CPSYS_name,
subPropA@filttest@sdf, urn@bby@pcm@ingest@status] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'6efa2222-31f2-11e3-b7b8-001c42000009-CJOB' AND p_prop IN
('__CPSYS_name','subPropA@filttest@sdf','urn@bby@pcm@job@ingest@content@fail@count','urn@bby@pcm@ingest@status')
ID: f9120571-31e0-11e3-b605-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_type, subPropA@filttest@sdf, urn@bby@pcm@ingest@data] to
[__CPSYS_links, __CPSYS_type, subPropA@filttest@sdf] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'f9120571-31e0-11e3-b605-001c42000009-CJOB' AND p_prop IN
('__CPSYS_type','__CPSYS_links','subPropA@filttest@sdf','urn@bby@pcm@ingest@data')
ID: 0c39c361-31e9-11e3-87e6-001c42000009-CJOB NOMATCH: [__CPSYS_type,
subPropA@filttest@sdf, urn@bby@pcm@ingest@status,
urn@bby@pcm@job@ingest@content@fail@count] to [__CPSYS_type,
subPropA@filttest@sdf, urn@bby@pcm@ingest@status] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'0c39c361-31e9-11e3-87e6-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@job@ingest@content@fail@count','__CPSYS_type','urn@bby@pcm@ingest@status','subPropA@filttest@sdf')
ID: c8933813-31e5-11e3-a033-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_name, subPropA@filttest@sdf, urn@bby@pcm@ingest@data] to
[__CPSYS_links, __CPSYS_name, subPropA@filttest@sdf] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'c8933813-31e5-11e3-a033-001c42000009-CJOB' AND p_prop IN
('subPropA@filttest@sdf','__CPSYS_name','__CPSYS_links','urn@bby@pcm@ingest@data')
ID: 559b0c62-31f5-11e3-9684-001c42000009-CJOB NOMATCH: [__CPSYS_name,
urn@bby@pcm@ingest@status, urn@bby@pcm@job@ingest@content@success@count,
urn@bby@pcm@job@sourceparty@reference@id] to [__CPSYS_name,
urn@bby@pcm@ingest@status, urn@bby@pcm@job@sourceparty@reference@id] CQL:
SELECT * FROM wayfair_submission.entity_job WHERE e_entid =
'559b0c62-31f5-11e3-9684-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@job@ingest@content@success@count','urn@bby@pcm@job@sourceparty@reference@id','__CPSYS_name','urn@bby@pcm@ingest@status')
ID: b81fdf39-31f2-11e3-bc88-001c42000009-CJOB NOMATCH: [__CPSYS_name,
__CPSYS_type, urn@bby@pcm@ingest@status,
urn@bby@pcm@job@ingest@content@success@count] to [__CPSYS_name, __CPSYS_type,
urn@bby@pcm@ingest@status] CQL: SELECT * FROM wayfair_submission.entity_job
WHERE e_entid = 'b81fdf39-31f2-11e3-bc88-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@job@ingest@content@success@count','__CPSYS_name','__CPSYS_type','urn@bby@pcm@ingest@status')
ID: f92629b1-31e0-11e3-b605-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_name, __CPSYS_type, urn@bby@pcm@job@ingest@content@complete@count] to
[__CPSYS_links, __CPSYS_name, __CPSYS_type] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'f92629b1-31e0-11e3-b605-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@job@ingest@content@complete@count','__CPSYS_name','__CPSYS_links','__CPSYS_type')
ID: 6ef89b88-31f2-11e3-b7b8-001c42000009-CJOB NOMATCH: [__CPSYS_links,
urn@bby@pcm@ingest@status, urn@bby@pcm@job@ingest@content@complete@count,
urn@bby@pcm@job@sourceparty@reference@id] to [__CPSYS_links,
urn@bby@pcm@ingest@status, urn@bby@pcm@job@sourceparty@reference@id] CQL:
SELECT * FROM wayfair_submission.entity_job WHERE e_entid =
'6ef89b88-31f2-11e3-b7b8-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@job@ingest@content@complete@count','urn@bby@pcm@ingest@status','urn@bby@pcm@job@sourceparty@reference@id','__CPSYS_links')
ID: 03995bd0-31e9-11e3-aa9a-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_type, subPropA@filttest@sdf, urn@bby@pcm@job@ingest@content@warn@count]
to [__CPSYS_links, __CPSYS_type, subPropA@filttest@sdf] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'03995bd0-31e9-11e3-aa9a-001c42000009-CJOB' AND p_prop IN
('subPropA@filttest@sdf','__CPSYS_type','__CPSYS_links','urn@bby@pcm@job@ingest@content@warn@count')
ID: a3a70275-31e5-11e3-ad9c-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_type, subPropA@filttest@sdf,
urn@bby@pcm@job@ingest@content@success@count] to [__CPSYS_links, __CPSYS_type,
subPropA@filttest@sdf] CQL: SELECT * FROM wayfair_submission.entity_job WHERE
e_entid = 'a3a70275-31e5-11e3-ad9c-001c42000009-CJOB' AND p_prop IN
('__CPSYS_links','subPropA@filttest@sdf','urn@bby@pcm@job@ingest@content@success@count','__CPSYS_type')
ID: 2a318832-31f3-11e3-bf8b-001c42000009-CJOB NOMATCH: [__CPSYS_links,
subPropA@filttest@sdf, urn@bby@pcm@ingest@data,
urn@bby@pcm@job@sourceparty@reference@id] to [__CPSYS_links,
subPropA@filttest@sdf, urn@bby@pcm@job@sourceparty@reference@id] CQL: SELECT *
FROM wayfair_submission.entity_job WHERE e_entid =
'2a318832-31f3-11e3-bf8b-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@ingest@data','urn@bby@pcm@job@sourceparty@reference@id','subPropA@filttest@sdf','__CPSYS_links')
ID: 2c23bb46-31f3-11e3-bf8b-001c42000009-CJOB NOMATCH: [__CPSYS_links,
urn@bby@pcm@job@ingest@content@hold@count,
urn@bby@pcm@job@ingest@content@success@count,
urn@bby@pcm@job@sourceparty@reference@id] to [__CPSYS_links,
urn@bby@pcm@job@ingest@content@hold@count,
urn@bby@pcm@job@sourceparty@reference@id] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'2c23bb46-31f3-11e3-bf8b-001c42000009-CJOB' AND p_prop IN
('__CPSYS_links','urn@bby@pcm@job@ingest@content@success@count','urn@bby@pcm@job@sourceparty@reference@id','urn@bby@pcm@job@ingest@content@hold@count')
ID: 25c066e0-31fd-11e3-82e6-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_name, urn:bby:pcm:job:sourceparty:reference:id,
urn@bby@pcm@job@ingest@content@complete@count] to [__CPSYS_links, __CPSYS_name,
urn:bby:pcm:job:sourceparty:reference:id] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'25c066e0-31fd-11e3-82e6-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@job@ingest@content@complete@count','__CPSYS_links','__CPSYS_name','urn:bby:pcm:job:sourceparty:reference:id')
ID: b95c09b0-31e7-11e3-9392-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_type, subPropA@filttest@sdf,
urn@bby@pcm@job@ingest@content@complete@count] to [__CPSYS_links, __CPSYS_type,
subPropA@filttest@sdf] CQL: SELECT * FROM wayfair_submission.entity_job WHERE
e_entid = 'b95c09b0-31e7-11e3-9392-001c42000009-CJOB' AND p_prop IN
('subPropA@filttest@sdf','__CPSYS_links','__CPSYS_type','urn@bby@pcm@job@ingest@content@complete@count')
ID: 6efa9758-31f2-11e3-b7b8-001c42000009-CJOB NOMATCH: [__CPSYS_type,
subPropA@filttest@sdf, urn@bby@pcm@ingest@status,
urn@bby@pcm@job@ingest@content@warn@count] to [__CPSYS_type,
subPropA@filttest@sdf, urn@bby@pcm@ingest@status] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'6efa9758-31f2-11e3-b7b8-001c42000009-CJOB' AND p_prop IN
('subPropA@filttest@sdf','__CPSYS_type','urn@bby@pcm@ingest@status','urn@bby@pcm@job@ingest@content@warn@count')
ID: 3b3612a1-31e8-11e3-af24-001c42000009-CJOB NOMATCH: [__CPSYS_links,
subPropA@filttest@sdf, urn@bby@pcm@job@ingest@content@fail@count,
urn@bby@pcm@job@ingest@content@warn@count] to [__CPSYS_links,
subPropA@filttest@sdf, urn@bby@pcm@job@ingest@content@fail@count] CQL: SELECT *
FROM wayfair_submission.entity_job WHERE e_entid =
'3b3612a1-31e8-11e3-af24-001c42000009-CJOB' AND p_prop IN
('__CPSYS_links','urn@bby@pcm@job@ingest@content@fail@count','urn@bby@pcm@job@ingest@content@warn@count','subPropA@filttest@sdf')
ID: 3b210402-31e8-11e3-af24-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_name, subPropA@filttest@sdf, urn@bby@pcm@job@ingest@content@fail@count]
to [__CPSYS_links, __CPSYS_name, subPropA@filttest@sdf] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'3b210402-31e8-11e3-af24-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@job@ingest@content@fail@count','__CPSYS_links','subPropA@filttest@sdf','__CPSYS_name')
ID: b52a58d0-31e5-11e3-9bd1-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_name, __CPSYS_type, urn@bby@pcm@job@ingest@content@warn@count] to
[__CPSYS_links, __CPSYS_name, __CPSYS_type] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'b52a58d0-31e5-11e3-9bd1-001c42000009-CJOB' AND p_prop IN
('__CPSYS_type','__CPSYS_name','urn@bby@pcm@job@ingest@content@warn@count','__CPSYS_links')
ID: 88c56831-31e4-11e3-b700-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_name, __SYSTEM__BYPASS__PROP__SUBSET__,
urn@bby@pcm@job@ingest@content@complete@count] to [__CPSYS_links, __CPSYS_name,
__SYSTEM__BYPASS__PROP__SUBSET__] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'88c56831-31e4-11e3-b700-001c42000009-CJOB' AND p_prop IN
('__CPSYS_name','__SYSTEM__BYPASS__PROP__SUBSET__','__CPSYS_links','urn@bby@pcm@job@ingest@content@complete@count')
ID: 95bfc4f7-31ed-11e3-a7cc-001c42000009-CJOB NOMATCH:
[DISABLED__SYSTEM__BYPASS__PROP__SUBSET__, __CPSYS_name,
urn@bby@pcm@ingest@status, urn@bby@pcm@job@ingest@content@hold@count] to
[DISABLED__SYSTEM__BYPASS__PROP__SUBSET__, __CPSYS_name,
urn@bby@pcm@ingest@status] CQL: SELECT * FROM wayfair_submission.entity_job
WHERE e_entid = '95bfc4f7-31ed-11e3-a7cc-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@job@ingest@content@hold@count','__CPSYS_name','urn@bby@pcm@ingest@status','DISABLED__SYSTEM__BYPASS__PROP__SUBSET__')
ID: dc084823-31ec-11e3-8db9-001c42000009-CJOB NOMATCH: [__CPSYS_links,
subPropA@filttest@sdf, urn@bby@pcm@ingest@data,
urn@bby@pcm@job@sourceparty@reference@id] to [__CPSYS_links,
subPropA@filttest@sdf, urn@bby@pcm@job@sourceparty@reference@id] CQL: SELECT *
FROM wayfair_submission.entity_job WHERE e_entid =
'dc084823-31ec-11e3-8db9-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@job@sourceparty@reference@id','__CPSYS_links','urn@bby@pcm@ingest@data','subPropA@filttest@sdf')
ID: f667ba14-31ed-11e3-ab0d-001c42000009-CJOB NOMATCH: [__CPSYS_type,
subPropA@filttest@sdf, urn@bby@pcm@ingest@status,
urn@bby@pcm@job@ingest@content@fail@count] to [__CPSYS_type,
subPropA@filttest@sdf, urn@bby@pcm@ingest@status] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'f667ba14-31ed-11e3-ab0d-001c42000009-CJOB' AND p_prop IN
('subPropA@filttest@sdf','__CPSYS_type','urn@bby@pcm@ingest@status','urn@bby@pcm@job@ingest@content@fail@count')
ID: a189b4d3-31f2-11e3-bc88-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_type, subPropA@filttest@sdf, urn@bby@pcm@job@ingest@content@fail@count]
to [__CPSYS_links, __CPSYS_type, subPropA@filttest@sdf] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'a189b4d3-31f2-11e3-bc88-001c42000009-CJOB' AND p_prop IN
('subPropA@filttest@sdf','urn@bby@pcm@job@ingest@content@fail@count','__CPSYS_links','__CPSYS_type')
ID: d410ff91-31f1-11e3-b75f-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_name, urn@bby@pcm@ingest@status,
urn@bby@pcm@job@ingest@content@success@count] to [__CPSYS_links, __CPSYS_name,
urn@bby@pcm@ingest@status] CQL: SELECT * FROM wayfair_submission.entity_job
WHERE e_entid = 'd410ff91-31f1-11e3-b75f-001c42000009-CJOB' AND p_prop IN
('__CPSYS_links','urn@bby@pcm@ingest@status','__CPSYS_name','urn@bby@pcm@job@ingest@content@success@count')
ID: 63c2ea71-31ef-11e3-b50f-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_type, urn@bby@pcm@ingest@status,
urn@bby@pcm@job@ingest@content@hold@count] to [__CPSYS_links, __CPSYS_type,
urn@bby@pcm@ingest@status] CQL: SELECT * FROM wayfair_submission.entity_job
WHERE e_entid = '63c2ea71-31ef-11e3-b50f-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@ingest@status','urn@bby@pcm@job@ingest@content@hold@count','__CPSYS_type','__CPSYS_links')
ID: f67e2843-31ed-11e3-ab0d-001c42000009-CJOB NOMATCH: [__CPSYS_name,
urn@bby@pcm@ingest@status, urn@bby@pcm@job@ingest@content@hold@count,
urn@bby@pcm@job@sourceparty@reference@id] to [__CPSYS_name,
urn@bby@pcm@ingest@status, urn@bby@pcm@job@sourceparty@reference@id] CQL:
SELECT * FROM wayfair_submission.entity_job WHERE e_entid =
'f67e2843-31ed-11e3-ab0d-001c42000009-CJOB' AND p_prop IN
('__CPSYS_name','urn@bby@pcm@job@ingest@content@hold@count','urn@bby@pcm@ingest@status','urn@bby@pcm@job@sourceparty@reference@id')
ID: 50dfa730-31f5-11e3-9684-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_type, urn@bby@pcm@ingest@data,
urn@bby@pcm@job@ingest@content@hold@count] to [__CPSYS_links, __CPSYS_type,
urn@bby@pcm@ingest@data] CQL: SELECT * FROM wayfair_submission.entity_job WHERE
e_entid = '50dfa730-31f5-11e3-9684-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@job@ingest@content@hold@count','__CPSYS_type','__CPSYS_links','urn@bby@pcm@ingest@data')
ID: a3b6e0f1-31e5-11e3-ad9c-001c42000009-CJOB NOMATCH: [__CPSYS_links,
bby:submission:SourceIP, subPropA@filttest@sdf,
urn@bby@pcm@job@ingest@content@warn@count] to [__CPSYS_links,
bby:submission:SourceIP, subPropA@filttest@sdf] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'a3b6e0f1-31e5-11e3-ad9c-001c42000009-CJOB' AND p_prop IN
('bby:submission:SourceIP','__CPSYS_links','urn@bby@pcm@job@ingest@content@warn@count','subPropA@filttest@sdf')
ID: 4a367663-31e2-11e3-9fbe-001c42000009-CJOB NOMATCH: [__CPSYS_name,
__CPSYS_type, subPropA@filttest@sdf, urn@bby@pcm@job@ingest@content@fail@count]
to [__CPSYS_name, __CPSYS_type, subPropA@filttest@sdf] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'4a367663-31e2-11e3-9fbe-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@job@ingest@content@fail@count','subPropA@filttest@sdf','__CPSYS_name','__CPSYS_type')
ID: 6ee7f9b0-31f2-11e3-b7b8-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_name, __CPSYS_type, urn@bby@pcm@job@ingest@content@warn@count] to
[__CPSYS_links, __CPSYS_name, __CPSYS_type] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'6ee7f9b0-31f2-11e3-b7b8-001c42000009-CJOB' AND p_prop IN
('__CPSYS_type','urn@bby@pcm@job@ingest@content@warn@count','__CPSYS_name','__CPSYS_links')
ID: 7d5d1c25-31e6-11e3-a91b-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_type, subPropA@filttest@sdf, urn@bby@pcm@job@ingest@content@warn@count]
to [__CPSYS_links, __CPSYS_type, subPropA@filttest@sdf] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'7d5d1c25-31e6-11e3-a91b-001c42000009-CJOB' AND p_prop IN
('subPropA@filttest@sdf','__CPSYS_links','urn@bby@pcm@job@ingest@content@warn@count','__CPSYS_type')
ID: a3aafa11-31e5-11e3-ad9c-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_type, subPropA@filttest@sdf, urn@bby@pcm@job@ingest@content@fail@count]
to [__CPSYS_links, __CPSYS_type, subPropA@filttest@sdf] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'a3aafa11-31e5-11e3-ad9c-001c42000009-CJOB' AND p_prop IN
('__CPSYS_links','__CPSYS_type','urn@bby@pcm@job@ingest@content@fail@count','subPropA@filttest@sdf')
ID: f4c9a830-31f2-11e3-b478-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_type, urn@bby@pcm@ingest@status,
urn@bby@pcm@job@ingest@content@warn@count] to [__CPSYS_links, __CPSYS_type,
urn@bby@pcm@ingest@status] CQL: SELECT * FROM wayfair_submission.entity_job
WHERE e_entid = 'f4c9a830-31f2-11e3-b478-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@ingest@status','__CPSYS_links','urn@bby@pcm@job@ingest@content@warn@count','__CPSYS_type')
ID: b52d6616-31e5-11e3-9bd1-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_name, dct@dateSubmitted, urn@bby@pcm@ingest@data] to [__CPSYS_links,
__CPSYS_name, dct@dateSubmitted] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'b52d6616-31e5-11e3-9bd1-001c42000009-CJOB' AND p_prop IN
('dct@dateSubmitted','__CPSYS_name','urn@bby@pcm@ingest@data','__CPSYS_links')
ID: 63c693f2-31ef-11e3-b50f-001c42000009-CJOB NOMATCH: [__CPSYS_type,
urn@bby@pcm@ingest@status, urn@bby@pcm@job@ingest@content@success@count,
urn@bby@pcm@job@sourceparty@reference@id] to [__CPSYS_type,
urn@bby@pcm@ingest@status, urn@bby@pcm@job@sourceparty@reference@id] CQL:
SELECT * FROM wayfair_submission.entity_job WHERE e_entid =
'63c693f2-31ef-11e3-b50f-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@ingest@status','__CPSYS_type','urn@bby@pcm@job@sourceparty@reference@id','urn@bby@pcm@job@ingest@content@success@count')
ID: bf4d6bf1-31e9-11e3-aed5-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_name, __CPSYS_type, urn@bby@pcm@job@ingest@content@success@count] to
[__CPSYS_links, __CPSYS_name, __CPSYS_type] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'bf4d6bf1-31e9-11e3-aed5-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@job@ingest@content@success@count','__CPSYS_name','__CPSYS_type','__CPSYS_links')
ID: f91783b3-31e0-11e3-b605-001c42000009-CJOB NOMATCH: [__CPSYS_links,
subPropA@filttest@sdf, urn@bby@pcm@ingest@data,
urn@bby@pcm@job@ingest@content@success@count] to [__CPSYS_links,
subPropA@filttest@sdf] CQL: SELECT * FROM wayfair_submission.entity_job WHERE
e_entid = 'f91783b3-31e0-11e3-b605-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@job@ingest@content@success@count','__CPSYS_links','urn@bby@pcm@ingest@data','subPropA@filttest@sdf')
ID: b51f5c51-31e5-11e3-9bd1-001c42000009-CJOB NOMATCH: [__CPSYS_name,
__CPSYS_type, urn@bby@pcm@job@ingest@content@success@count,
urn@bby@pcm@job@ingest@content@warn@count] to [__CPSYS_name, __CPSYS_type,
urn@bby@pcm@job@ingest@content@warn@count] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'b51f5c51-31e5-11e3-9bd1-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@job@ingest@content@success@count','urn@bby@pcm@job@ingest@content@warn@count','__CPSYS_name','__CPSYS_type')
ID: bf518aa4-31e9-11e3-aed5-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_name, __CPSYS_type, urn@bby@pcm@job@ingest@content@complete@count] to
[__CPSYS_links, __CPSYS_name, __CPSYS_type] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'bf518aa4-31e9-11e3-aed5-001c42000009-CJOB' AND p_prop IN
('__CPSYS_name','urn@bby@pcm@job@ingest@content@complete@count','__CPSYS_links','__CPSYS_type')
ID: 107a6c95-31e4-11e3-b927-001c42000009-CJOB NOMATCH: [__CPSYS_type,
subPropA@filttest@sdf, urn@bby@pcm@job@ingest@content@success@count,
urn@bby@pcm@job@ingest@content@warn@count] to [__CPSYS_type,
subPropA@filttest@sdf, urn@bby@pcm@job@ingest@content@success@count] CQL:
SELECT * FROM wayfair_submission.entity_job WHERE e_entid =
'107a6c95-31e4-11e3-b927-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@job@ingest@content@warn@count','__CPSYS_type','urn@bby@pcm@job@ingest@content@success@count','subPropA@filttest@sdf')
ID: 043c0373-31f4-11e3-a64e-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_name, __CPSYS_type, urn@bby@pcm@job@ingest@content@success@count] to
[__CPSYS_links, __CPSYS_name, __CPSYS_type] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'043c0373-31f4-11e3-a64e-001c42000009-CJOB' AND p_prop IN
('__CPSYS_links','__CPSYS_type','__CPSYS_name','urn@bby@pcm@job@ingest@content@success@count')
ID: a37c44c2-31ec-11e3-b2d5-001c42000009-CJOB NOMATCH: [__CPSYS_name,
subPropA@filttest@sdf, urn@bby@pcm@job@ingest@content@success@count,
urn@bby@pcm@job@ingest@content@warn@count] to [__CPSYS_name,
subPropA@filttest@sdf, urn@bby@pcm@job@ingest@content@warn@count] CQL: SELECT *
FROM wayfair_submission.entity_job WHERE e_entid =
'a37c44c2-31ec-11e3-b2d5-001c42000009-CJOB' AND p_prop IN
('__CPSYS_name','urn@bby@pcm@job@ingest@content@success@count','urn@bby@pcm@job@ingest@content@warn@count','subPropA@filttest@sdf')
ID: 6e697382-31f5-11e3-8ee2-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_name, urn@bby@pcm@ingest@data,
urn@bby@pcm@job@ingest@content@hold@count] to [__CPSYS_links, __CPSYS_name,
urn@bby@pcm@ingest@data] CQL: SELECT * FROM wayfair_submission.entity_job WHERE
e_entid = '6e697382-31f5-11e3-8ee2-001c42000009-CJOB' AND p_prop IN
('__CPSYS_links','__CPSYS_name','urn@bby@pcm@job@ingest@content@hold@count','urn@bby@pcm@ingest@data')
ID: 9b961433-31e6-11e3-a6c8-001c42000009-CJOB NOMATCH: [__CPSYS_links,
subPropA@filttest@sdf, urn@bby@pcm@ingest@data,
urn@bby@pcm@ingest@status@detail] to [__CPSYS_links, subPropA@filttest@sdf,
urn@bby@pcm@ingest@status@detail] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'9b961433-31e6-11e3-a6c8-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@ingest@status@detail','subPropA@filttest@sdf','urn@bby@pcm@ingest@data','__CPSYS_links')
ID: 923ee850-31fd-11e3-97f7-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_name, __CPSYS_type, urn@bby@pcm@job@ingest@content@warn@count] to
[__CPSYS_links, __CPSYS_name, __CPSYS_type] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'923ee850-31fd-11e3-97f7-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@job@ingest@content@warn@count','__CPSYS_name','__CPSYS_type','__CPSYS_links')
ID: 924d6742-31fd-11e3-97f7-001c42000009-CJOB NOMATCH: [__CPSYS_name,
subPropA:filttest:sdf, urn:bby:pcm:ingest:status,
urn@bby@pcm@job@ingest@content@complete@count] to [__CPSYS_name,
subPropA:filttest:sdf, urn:bby:pcm:ingest:status] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'924d6742-31fd-11e3-97f7-001c42000009-CJOB' AND p_prop IN
('__CPSYS_name','urn:bby:pcm:ingest:status','subPropA:filttest:sdf','urn@bby@pcm@job@ingest@content@complete@count')
ID: 7217dab0-31e3-11e3-9dbf-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_name, subPropA@filttest@sdf, urn@bby@pcm@ingest@data] to
[__CPSYS_links, __CPSYS_name, subPropA@filttest@sdf] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'7217dab0-31e3-11e3-9dbf-001c42000009-CJOB' AND p_prop IN
('subPropA@filttest@sdf','__CPSYS_name','__CPSYS_links','urn@bby@pcm@ingest@data')
ID: 3b372413-31e8-11e3-af24-001c42000009-CJOB NOMATCH: [__CPSYS_links,
__CPSYS_name, subPropA@filttest@sdf,
urn@bby@pcm@job@ingest@content@complete@count] to [__CPSYS_links, __CPSYS_name,
subPropA@filttest@sdf] CQL: SELECT * FROM wayfair_submission.entity_job WHERE
e_entid = '3b372413-31e8-11e3-af24-001c42000009-CJOB' AND p_prop IN
('__CPSYS_links','__CPSYS_name','urn@bby@pcm@job@ingest@content@complete@count','subPropA@filttest@sdf')
:-->wayfair_submission.entity_job stats: 10495 succeeded, 97 failed
was (Author: cowardlydragon):
ID: f924f134-31e0-11e3-b605-001c42000009-CJOB !!NOMATCH!!: [__CPSYS_links,
__CPSYS_name, __CPSYS_type, urn@bby@pcm@job@ingest@content@warn@count] to
[__CPSYS_links, __CPSYS_name, __CPSYS_type] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'f924f134-31e0-11e3-b605-001c42000009-CJOB' AND p_prop IN
('__CPSYS_type','__CPSYS_name','urn@bby@pcm@job@ingest@content@warn@count','__CPSYS_links')
ID: b529bc94-31e5-11e3-9bd1-001c42000009-CJOB !!NOMATCH!!: [__CPSYS_name,
__CPSYS_type, subPropA@filttest@sdf,
urn@bby@pcm@job@ingest@content@complete@count] to [__CPSYS_name, __CPSYS_type,
subPropA@filttest@sdf] CQL: SELECT * FROM wayfair_submission.entity_job WHERE
e_entid = 'b529bc94-31e5-11e3-9bd1-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@job@ingest@content@complete@count','subPropA@filttest@sdf','__CPSYS_name','__CPSYS_type')
ID: a4a023f3-31ef-11e3-84cd-001c42000009-CJOB !!NOMATCH!!: [__CPSYS_type,
urn@bby@pcm@ingest@status, urn@bby@pcm@job@ingest@content@complete@count,
urn@bby@pcm@job@sourceparty@reference@id] to [__CPSYS_type,
urn@bby@pcm@ingest@status, urn@bby@pcm@job@sourceparty@reference@id] CQL:
SELECT * FROM wayfair_submission.entity_job WHERE e_entid =
'a4a023f3-31ef-11e3-84cd-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@job@ingest@content@complete@count','urn@bby@pcm@ingest@status','__CPSYS_type','urn@bby@pcm@job@sourceparty@reference@id')
ID: b81e318b-31f2-11e3-bc88-001c42000009-CJOB !!NOMATCH!!: [__CPSYS_links,
__CPSYS_name, __CPSYS_type, urn@bby@pcm@job@ingest@content@complete@count] to
[__CPSYS_links, __CPSYS_name, __CPSYS_type] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'b81e318b-31f2-11e3-bc88-001c42000009-CJOB' AND p_prop IN
('__CPSYS_links','__CPSYS_name','__CPSYS_type','urn@bby@pcm@job@ingest@content@complete@count')
ID: 58a032e8-31f1-11e3-84cd-001c42000009-CJOB !!NOMATCH!!: [__CPSYS_links,
subPropA@filttest@sdf, urn@bby@pcm@ingest@data,
urn@bby@pcm@job@sourceparty@reference@id] to [__CPSYS_links,
subPropA@filttest@sdf, urn@bby@pcm@job@sourceparty@reference@id] CQL: SELECT *
FROM wayfair_submission.entity_job WHERE e_entid =
'58a032e8-31f1-11e3-84cd-001c42000009-CJOB' AND p_prop IN
('subPropA@filttest@sdf','urn@bby@pcm@ingest@data','__CPSYS_links','urn@bby@pcm@job@sourceparty@reference@id')
ID: 4a456a81-31e2-11e3-9fbe-001c42000009-CJOB !!NOMATCH!!: [__CPSYS_links,
__CPSYS_type, subPropA@filttest@sdf, urn@bby@pcm@job@ingest@content@hold@count]
to [__CPSYS_links, __CPSYS_type, subPropA@filttest@sdf] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'4a456a81-31e2-11e3-9fbe-001c42000009-CJOB' AND p_prop IN
('__CPSYS_type','subPropA@filttest@sdf','__CPSYS_links','urn@bby@pcm@job@ingest@content@hold@count')
ID: b51ff891-31e5-11e3-9bd1-001c42000009-CJOB !!NOMATCH!!: [__CPSYS_name,
__CPSYS_type, urn@bby@pcm@job@ingest@content@complete@count,
urn@bby@pcm@job@ingest@content@fail@count] to [__CPSYS_name, __CPSYS_type,
urn@bby@pcm@job@ingest@content@fail@count] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'b51ff891-31e5-11e3-9bd1-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@job@ingest@content@fail@count','__CPSYS_name','__CPSYS_type','urn@bby@pcm@job@ingest@content@complete@count')
ID: d4241266-31f1-11e3-b75f-001c42000009-CJOB !!NOMATCH!!: [__CPSYS_name,
__CPSYS_type, subPropA@filttest@sdf, urn@bby@pcm@job@ingest@content@warn@count]
to [__CPSYS_name, __CPSYS_type, subPropA@filttest@sdf] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'd4241266-31f1-11e3-b75f-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@job@ingest@content@warn@count','__CPSYS_name','__CPSYS_type','subPropA@filttest@sdf')
ID: d7312824-31ed-11e3-961d-001c42000009-CJOB !!NOMATCH!!: [__CPSYS_links,
__CPSYS_name, subPropA@filttest@sdf,
urn@bby@pcm@job@ingest@content@success@count] to [__CPSYS_links, __CPSYS_name,
subPropA@filttest@sdf] CQL: SELECT * FROM wayfair_submission.entity_job WHERE
e_entid = 'd7312824-31ed-11e3-961d-001c42000009-CJOB' AND p_prop IN
('subPropA@filttest@sdf','__CPSYS_links','__CPSYS_name','urn@bby@pcm@job@ingest@content@success@count')
ID: 0164c793-31f4-11e3-a64e-001c42000009-CJOB !!NOMATCH!!: [__CPSYS_name,
__CPSYS_type, urn@bby@pcm@ingest@data,
urn@bby@pcm@job@sourceparty@reference@id] to [__CPSYS_name, __CPSYS_type,
urn@bby@pcm@job@sourceparty@reference@id] CQL: SELECT * FROM
wayfair_submission.entity_job WHERE e_entid =
'0164c793-31f4-11e3-a64e-001c42000009-CJOB' AND p_prop IN
('urn@bby@pcm@ingest@data','__CPSYS_name','__CPSYS_type','urn@bby@pcm@job@sourceparty@reference@id')
> CQL3 SELECT IN CLAUSE inconsistent
> ----------------------------------
>
> Key: CASSANDRA-6137
> URL: https://issues.apache.org/jira/browse/CASSANDRA-6137
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Environment: Ubuntu AWS Cassandra 2.0.1 SINGLE NODE
> Reporter: Constance Eustace
> Fix For: 2.0.1
>
>
> We are encountering inconsistent results from CQL3 queries with column keys
> using IN clause in WHERE. This has been reproduced in cqlsh and the jdbc
> driver.
> Rowkey is e_entid
> Column key is p_prop
> This returns roughly 21 rows for 21 column keys that match p_prop.
> cqlsh> SELECT
> e_entid,e_entname,e_enttype,p_prop,p_flags,p_propid,e_entlinks,p_proplinks,p_subents,p_val,p_vallinks,p_vars
> FROM internal_submission.Entity_Job WHERE e_entid =
> '845b38f1-2b91-11e3-854d-126aad0075d4-CJOB';
> These three queries each return one row for the requested single column key
> in the IN clause:
> SELECT
> e_entid,e_entname,e_enttype,p_prop,p_flags,p_propid,e_entlinks,p_proplinks,p_subents,p_val,p_vallinks,p_vars
> FROM internal_submission.Entity_Job WHERE e_entid =
> '845b38f1-2b91-11e3-854d-126aad0075d4-CJOB' AND p_prop in
> ('urn:bby:pcm:job:ingest:content:complete:count');
> SELECT
> e_entid,e_entname,e_enttype,p_prop,p_flags,p_propid,e_entlinks,p_proplinks,p_subents,p_val,p_vallinks,p_vars
> FROM internal_submission.Entity_Job WHERE e_entid =
> '845b38f1-2b91-11e3-854d-126aad0075d4-CJOB' AND p_prop in
> ('urn:bby:pcm:job:ingest:content:all:count');
> SELECT
> e_entid,e_entname,e_enttype,p_prop,p_flags,p_propid,e_entlinks,p_proplinks,p_subents,p_val,p_vallinks,p_vars
> FROM internal_submission.Entity_Job WHERE e_entid =
> '845b38f1-2b91-11e3-854d-126aad0075d4-CJOB' AND p_prop in
> ('urn:bby:pcm:job:ingest:content:fail:count');
> This query returns ONLY ONE ROW (one column key), not three as I would expect
> from the three-column-key IN clause:
> cqlsh> SELECT
> e_entid,e_entname,e_enttype,p_prop,p_flags,p_propid,e_entlinks,p_proplinks,p_subents,p_val,p_vallinks,p_vars
> FROM internal_submission.Entity_Job WHERE e_entid =
> '845b38f1-2b91-11e3-854d-126aad0075d4-CJOB' AND p_prop in
> ('urn:bby:pcm:job:ingest:content:complete:count','urn:bby:pcm:job:ingest:content:all:count','urn:bby:pcm:job:ingest:content:fail:count');
> This query does return two rows however for the requested two column keys:
> cqlsh> SELECT
> e_entid,e_entname,e_enttype,p_prop,p_flags,p_propid,e_entlinks,p_proplinks,p_subents,p_val,p_vallinks,p_vars
> FROM internal_submission.Entity_Job WHERE e_entid =
> '845b38f1-2b91-11e3-854d-126aad0075d4-CJOB' AND p_prop in (
>
> 'urn:bby:pcm:job:ingest:content:all:count','urn:bby:pcm:job:ingest:content:fail:count');
> cqlsh> describe table internal_submission.entity_job;
> CREATE TABLE entity_job (
> e_entid text,
> p_prop text,
> describes text,
> dndcondition text,
> e_entlinks text,
> e_entname text,
> e_enttype text,
> ingeststatus text,
> ingeststatusdetail text,
> p_flags text,
> p_propid text,
> p_proplinks text,
> p_storage text,
> p_subents text,
> p_val text,
> p_vallang text,
> p_vallinks text,
> p_valtype text,
> p_valunit text,
> p_vars text,
> partnerid text,
> referenceid text,
> size int,
> sourceip text,
> submitdate bigint,
> submitevent text,
> userid text,
> version text,
> PRIMARY KEY (e_entid, p_prop)
> ) WITH
> bloom_filter_fp_chance=0.010000 AND
> caching='KEYS_ONLY' AND
> comment='' AND
> dclocal_read_repair_chance=0.000000 AND
> gc_grace_seconds=864000 AND
> index_interval=128 AND
> read_repair_chance=0.100000 AND
> replicate_on_write='true' AND
> populate_io_cache_on_flush='false' AND
> default_time_to_live=0 AND
> speculative_retry='NONE' AND
> memtable_flush_period_in_ms=0 AND
> compaction={'class': 'SizeTieredCompactionStrategy'} AND
> compression={'sstable_compression': 'LZ4Compressor'};
> CREATE INDEX internal_submission__JobDescribesIDX ON entity_job (describes);
> CREATE INDEX internal_submission__JobDNDConditionIDX ON entity_job
> (dndcondition);
> CREATE INDEX internal_submission__JobIngestStatusIDX ON entity_job
> (ingeststatus);
> CREATE INDEX internal_submission__JobIngestStatusDetailIDX ON entity_job
> (ingeststatusdetail);
> CREATE INDEX internal_submission__JobReferenceIDIDX ON entity_job
> (referenceid);
> CREATE INDEX internal_submission__JobUserIDX ON entity_job (userid);
> CREATE INDEX internal_submission__JobVersionIDX ON entity_job (version);
> -------------------------------
> My suspicion is that the three-column-key IN Clause is translated (improperly
> or not) to a two-column key range with the assumption that the third column
> key is present in that range, but it isn't...
--
This message was sent by Atlassian JIRA
(v6.1#6144)
