cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Constance Eustace (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (CASSANDRA-6137) CQL3 SELECT IN CLAUSE inconsistent
Date Tue, 15 Oct 2013 20:02:43 GMT

    [ https://issues.apache.org/jira/browse/CASSANDRA-6137?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13795562#comment-13795562 ] 

Constance Eustace edited comment on CASSANDRA-6137 at 10/15/13 8:01 PM:
------------------------------------------------------------------------

------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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]

------------------------------------------------------------------------------------------------------------------------------------------------------------------------
select * from wyfr_submission.entity_job where e_entid = '924d6742-31fd-11e3-97f7-001c42000009-CJOB' ;

RESULT:

 e_entid                                   | p_prop                                        | describes | dndcondition | e_entlinks                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | e_entname  | e_enttype       | ingeststatus | ingeststatusdetail | p_flags | p_propid                             | p_proplinks | p_storage | p_subents | p_val                  | p_vallang | p_vallinks | p_valtype | p_valunit | p_vars                                                                                                 | partnerid | referenceid                          | size | sourceip | submitdate | submitevent | userid | version
 924d6742-31fd-11e3-97f7-001c42000009-CJOB |                                 __CPSYS_links |      null |         null | [{"content":null,"href":"http://cupcake/wyfr/entities/id/9222fbe1-31fd-11e3-97f7-001c42000009-CJOB","rel":"parent-entity","type":"application/vnd.BUB.content.entity","hreflang":null,"title":"Up to Parent Entity","length":null,"otherAttributes":{}},{"content":null,"href":"http://cupcake/wyfr/entities/id/9222fbe1-31fd-11e3-97f7-001c42000009-CJOB/properties/type/DYNApropAA%3Asdjlk%3Asdfklj%3Afiltertest","rel":"up","type":"application/vnd.BUB.content.property","hreflang":null,"title":"Up to Parent Entity Property","length":null,"otherAttributes":{}}] |       null |            null |         null |               null |    null |                                 null |        null |      null |      null |                   null |      null |       null |      null |      null |                                                                                                   null |      null |                                 null | null |     null |       null |        null |   null |    null
 924d6742-31fd-11e3-97f7-001c42000009-CJOB |                                  __CPSYS_name |      null |         null |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   null | SUBENT-100 |            null |         null |               null |    null |                                 null |        null |      null |      null |                   null |      null |       null |      null |      null |                                                                                                   null |      null |                                 null | null |     null |       null |        null |   null |    null
 924d6742-31fd-11e3-97f7-001c42000009-CJOB |                                  __CPSYS_type |      null |         null |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   null |       null | urn:bby:pcm:job |         null |               null |    null |                                 null |        null |      null |      null |                   null |      null |       null |      null |      null |                                                                                                   null |      null |                                 null | null |     null |       null |        null |   null |    null
 924d6742-31fd-11e3-97f7-001c42000009-CJOB |                         subPropA:filttest:sdf |      null |         null |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   null |       null |            null |         null |               null |     DVM | 924d6743-31fd-11e3-97f7-001c42000009 |          [] |      null |        [] | ["subE","subI","subH"] |     en_us |         [] |      text |         m |                   [{"type":"text","lang":"en_us","uom":"m","datas":["subE","subI","subH"],"links":[]}] |      null |                                 null | null |     null |       null |        null |   null |    null
 924d6742-31fd-11e3-97f7-001c42000009-CJOB |                     urn:bby:pcm:ingest:status |      null |         null |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   null |       null |            null |         subC |               null |     S00 | 924d6744-31fd-11e3-97f7-001c42000009 |          [] |      null |        [] |                   null |      null |         [] |      null |      null |                                 [{"type":"text","lang":"en_us","uom":"m","datas":["subC"],"links":[]}] |      null |                                 null | null |     null |       null |        null |   null |    null
 924d6742-31fd-11e3-97f7-001c42000009-CJOB |      urn:bby:pcm:job:sourceparty:reference:id |      null |         null |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   null |       null |            null |         null |               null |     S00 | 924d6745-31fd-11e3-97f7-001c42000009 |          [] |      null |        [] |                   null |      null |         [] |      null |      null | [{"type":"text","lang":"en_us","uom":"m","datas":["cdc8911c-7092-4c71-a7a6-935331ff2c5c"],"links":[]}] |      null | cdc8911c-7092-4c71-a7a6-935331ff2c5c | null |     null |       null |        null |   null |    null
 924d6742-31fd-11e3-97f7-001c42000009-CJOB | urn@bby@pcm@job@ingest@content@complete@count |      null |         null |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   null |       null |            null |         null |               null |    null |                                 null |          [] |      null |      null |                   null |      null |       null |      null |      null |                                                                                                   null |      null |                                 null | null |     null |       null |        null |   null |    null


TRACE: 
DEBUG [Thrift:1] 2013-10-15 14:45:26,841 CassandraServer.java (line 1699) execute_cql3_query
TRACE [Thrift:1] 2013-10-15 14:45:26,842 QueryProcessor.java (line 100) Process org.apache.cassandra.cql3.statements.SelectStatement@7aacaaae @CL.ONE
TRACE [Thrift:1] 2013-10-15 14:45:26,843 ReadCallback.java (line 67) Blockfor is 1; setting up requests to /127.0.0.1
TRACE [ReadStage:3] 2013-10-15 14:45:26,851 SSTableReader.java (line 756) Adding cache entry for KeyCacheKey(/Users/a999166/aaa-projects/apache-cassandra-1.2.8/z-serverfiles/data/wyfr_submission/entity_job/wyfr_submission-entity_job-ic-2, 39323464363734322d333166642d313165332d393766372d3030316334323030303030392d434a4f42) -> org.apache.cassandra.db.RowIndexEntry@4017415d
TRACE [ReadStage:3] 2013-10-15 14:45:26,853 SliceQueryFilter.java (line 161) collecting 0 of 10000: __CPSYS_links::false:0@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,853 SliceQueryFilter.java (line 161) collecting 1 of 10000: __CPSYS_links:e_entlinks:false:566@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,853 SliceQueryFilter.java (line 161) collecting 1 of 10000: __CPSYS_name::false:0@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,853 SliceQueryFilter.java (line 161) collecting 2 of 10000: __CPSYS_name:e_entname:false:10@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161) collecting 2 of 10000: __CPSYS_type::false:0@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161) collecting 3 of 10000: __CPSYS_type:e_enttype:false:15@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161) collecting 3 of 10000: subPropA\:filttest\:sdf::false:0@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161) collecting 4 of 10000: subPropA\:filttest\:sdf:p_flags:false:3@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161) collecting 4 of 10000: subPropA\:filttest\:sdf:p_propid:false:36@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161) collecting 4 of 10000: subPropA\:filttest\:sdf:p_proplinks:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161) collecting 4 of 10000: subPropA\:filttest\:sdf:p_subents:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161) collecting 4 of 10000: subPropA\:filttest\:sdf:p_val:false:22@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161) collecting 4 of 10000: subPropA\:filttest\:sdf:p_vallang:false:5@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,855 SliceQueryFilter.java (line 161) collecting 4 of 10000: subPropA\:filttest\:sdf:p_vallinks:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,855 SliceQueryFilter.java (line 161) collecting 4 of 10000: subPropA\:filttest\:sdf:p_valtype:false:4@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,855 SliceQueryFilter.java (line 161) collecting 4 of 10000: subPropA\:filttest\:sdf:p_valunit:false:1@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,855 SliceQueryFilter.java (line 161) collecting 4 of 10000: subPropA\:filttest\:sdf:p_vars:false:84@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,855 SliceQueryFilter.java (line 161) collecting 4 of 10000: urn\:bby\:pcm\:ingest\:status::false:0@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,855 SliceQueryFilter.java (line 161) collecting 5 of 10000: urn\:bby\:pcm\:ingest\:status:ingeststatus:false:4@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,855 SliceQueryFilter.java (line 161) collecting 5 of 10000: urn\:bby\:pcm\:ingest\:status:p_flags:false:3@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,855 SliceQueryFilter.java (line 161) collecting 5 of 10000: urn\:bby\:pcm\:ingest\:status:p_propid:false:36@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,856 SliceQueryFilter.java (line 161) collecting 5 of 10000: urn\:bby\:pcm\:ingest\:status:p_proplinks:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,856 SliceQueryFilter.java (line 161) collecting 5 of 10000: urn\:bby\:pcm\:ingest\:status:p_subents:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,856 SliceQueryFilter.java (line 161) collecting 5 of 10000: urn\:bby\:pcm\:ingest\:status:p_vallinks:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,856 SliceQueryFilter.java (line 161) collecting 5 of 10000: urn\:bby\:pcm\:ingest\:status:p_vars:false:70@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,856 SliceQueryFilter.java (line 161) collecting 5 of 10000: urn\:bby\:pcm\:job\:sourceparty\:reference\:id::false:0@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,856 SliceQueryFilter.java (line 161) collecting 6 of 10000: urn\:bby\:pcm\:job\:sourceparty\:reference\:id:p_flags:false:3@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,856 SliceQueryFilter.java (line 161) collecting 6 of 10000: urn\:bby\:pcm\:job\:sourceparty\:reference\:id:p_propid:false:36@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,856 SliceQueryFilter.java (line 161) collecting 6 of 10000: urn\:bby\:pcm\:job\:sourceparty\:reference\:id:p_proplinks:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,857 SliceQueryFilter.java (line 161) collecting 6 of 10000: urn\:bby\:pcm\:job\:sourceparty\:reference\:id:p_subents:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,857 SliceQueryFilter.java (line 161) collecting 6 of 10000: urn\:bby\:pcm\:job\:sourceparty\:reference\:id:p_vallinks:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,857 SliceQueryFilter.java (line 161) collecting 6 of 10000: urn\:bby\:pcm\:job\:sourceparty\:reference\:id:p_vars:false:102@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,857 SliceQueryFilter.java (line 161) collecting 6 of 10000: urn\:bby\:pcm\:job\:sourceparty\:reference\:id:referenceid:false:36@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,857 SliceQueryFilter.java (line 161) collecting 6 of 10000: urn@bby@pcm@job@ingest@content@complete@count::false:0@1381860857189000
TRACE [ReadStage:3] 2013-10-15 14:45:26,857 SliceQueryFilter.java (line 161) collecting 7 of 10000: urn@bby@pcm@job@ingest@content@complete@count:p_proplinks:false:2@1381860857189000


------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SELECT * FROM wyfr_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')

RESULT:
 e_entid                                   | p_prop                    | describes | dndcondition | e_entlinks | e_entname  | e_enttype | ingeststatus | ingeststatusdetail | p_flags | p_propid                             | p_proplinks | p_storage | p_subents | p_val                  | p_vallang | p_vallinks | p_valtype | p_valunit | p_vars                                                                               | partnerid | referenceid | size | sourceip | submitdate | submitevent | userid | version
 924d6742-31fd-11e3-97f7-001c42000009-CJOB |              __CPSYS_name |      null |         null |       null | SUBENT-100 |      null |         null |               null |    null |                                 null |        null |      null |      null |                   null |      null |       null |      null |      null |                                                                                 null |      null |        null | null |     null |       null |        null |   null |    null
 924d6742-31fd-11e3-97f7-001c42000009-CJOB |     subPropA:filttest:sdf |      null |         null |       null |       null |      null |         null |               null |     DVM | 924d6743-31fd-11e3-97f7-001c42000009 |          [] |      null |        [] | ["subE","subI","subH"] |     en_us |         [] |      text |         m | [{"type":"text","lang":"en_us","uom":"m","datas":["subE","subI","subH"],"links":[]}] |      null |        null | null |     null |       null |        null |   null |    null
 924d6742-31fd-11e3-97f7-001c42000009-CJOB | urn:bby:pcm:ingest:status |      null |         null |       null |       null |      null |         subC |               null |     S00 | 924d6744-31fd-11e3-97f7-001c42000009 |          [] |      null |        [] |                   null |      null |         [] |      null |      null |               [{"type":"text","lang":"en_us","uom":"m","datas":["subC"],"links":[]}] |      null |        null | null |     null |       null |        null |   null |    null

TRACE:
DEBUG [Thrift:1] 2013-10-15 14:48:39,115 CassandraServer.java (line 1699) execute_cql3_query
TRACE [Thrift:1] 2013-10-15 14:48:39,116 QueryProcessor.java (line 100) Process org.apache.cassandra.cql3.statements.SelectStatement@58053ef7 @CL.ONE
TRACE [Thrift:1] 2013-10-15 14:48:39,116 ReadCallback.java (line 67) Blockfor is 1; setting up requests to /127.0.0.1
TRACE [ReadStage:33] 2013-10-15 14:48:39,117 SliceQueryFilter.java (line 161) collecting 0 of 10000: __CPSYS_name::false:0@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,117 SliceQueryFilter.java (line 161) collecting 1 of 10000: __CPSYS_name:e_entname:false:10@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,117 SliceQueryFilter.java (line 161) collecting 1 of 10000: subPropA\:filttest\:sdf::false:0@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161) collecting 2 of 10000: subPropA\:filttest\:sdf:p_flags:false:3@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161) collecting 2 of 10000: subPropA\:filttest\:sdf:p_propid:false:36@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161) collecting 2 of 10000: subPropA\:filttest\:sdf:p_proplinks:false:2@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161) collecting 2 of 10000: subPropA\:filttest\:sdf:p_subents:false:2@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161) collecting 2 of 10000: subPropA\:filttest\:sdf:p_val:false:22@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161) collecting 2 of 10000: subPropA\:filttest\:sdf:p_vallang:false:5@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161) collecting 2 of 10000: subPropA\:filttest\:sdf:p_vallinks:false:2@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161) collecting 2 of 10000: subPropA\:filttest\:sdf:p_valtype:false:4@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161) collecting 2 of 10000: subPropA\:filttest\:sdf:p_valunit:false:1@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,119 SliceQueryFilter.java (line 161) collecting 2 of 10000: subPropA\:filttest\:sdf:p_vars:false:84@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,119 SliceQueryFilter.java (line 161) collecting 2 of 10000: urn\:bby\:pcm\:ingest\:status:ingeststatus:false:4@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,119 SliceQueryFilter.java (line 161) collecting 3 of 10000: urn\:bby\:pcm\:ingest\:status:p_flags:false:3@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,119 SliceQueryFilter.java (line 161) collecting 3 of 10000: urn\:bby\:pcm\:ingest\:status:p_propid:false:36@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,119 SliceQueryFilter.java (line 161) collecting 3 of 10000: urn\:bby\:pcm\:ingest\:status:p_proplinks:false:2@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,119 SliceQueryFilter.java (line 161) collecting 3 of 10000: urn\:bby\:pcm\:ingest\:status:p_subents:false:2@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,119 SliceQueryFilter.java (line 161) collecting 3 of 10000: urn\:bby\:pcm\:ingest\:status:p_vallinks:false:2@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,119 SliceQueryFilter.java (line 161) collecting 3 of 10000: urn\:bby\:pcm\:ingest\:status:p_vars:false:70@1381445090517000
DEBUG [Thrift:1] 2013-10-15 14:48:39,120 Tracing.java (line 167) request complete



was (Author: cowardlydragon):
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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]

------------------------------------------------------------------------------------------------------------------------------------------------------------------------
select * from wayfair_submission.entity_job where e_entid = '924d6742-31fd-11e3-97f7-001c42000009-CJOB' ;

RESULT:

 e_entid                                   | p_prop                                        | describes | dndcondition | e_entlinks                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | e_entname  | e_enttype       | ingeststatus | ingeststatusdetail | p_flags | p_propid                             | p_proplinks | p_storage | p_subents | p_val                  | p_vallang | p_vallinks | p_valtype | p_valunit | p_vars                                                                                                 | partnerid | referenceid                          | size | sourceip | submitdate | submitevent | userid | version
 924d6742-31fd-11e3-97f7-001c42000009-CJOB |                                 __CPSYS_links |      null |         null | [{"content":null,"href":"http://cupcake/wayfair/entities/id/9222fbe1-31fd-11e3-97f7-001c42000009-CJOB","rel":"parent-entity","type":"application/vnd.bestbuy.content.entity","hreflang":null,"title":"Up to Parent Entity","length":null,"otherAttributes":{}},{"content":null,"href":"http://cupcake/wayfair/entities/id/9222fbe1-31fd-11e3-97f7-001c42000009-CJOB/properties/type/DYNApropAA%3Asdjlk%3Asdfklj%3Afiltertest","rel":"up","type":"application/vnd.bestbuy.content.property","hreflang":null,"title":"Up to Parent Entity Property","length":null,"otherAttributes":{}}] |       null |            null |         null |               null |    null |                                 null |        null |      null |      null |                   null |      null |       null |      null |      null |                                                                                                   null |      null |                                 null | null |     null |       null |        null |   null |    null
 924d6742-31fd-11e3-97f7-001c42000009-CJOB |                                  __CPSYS_name |      null |         null |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   null | SUBENT-100 |            null |         null |               null |    null |                                 null |        null |      null |      null |                   null |      null |       null |      null |      null |                                                                                                   null |      null |                                 null | null |     null |       null |        null |   null |    null
 924d6742-31fd-11e3-97f7-001c42000009-CJOB |                                  __CPSYS_type |      null |         null |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   null |       null | urn:bby:pcm:job |         null |               null |    null |                                 null |        null |      null |      null |                   null |      null |       null |      null |      null |                                                                                                   null |      null |                                 null | null |     null |       null |        null |   null |    null
 924d6742-31fd-11e3-97f7-001c42000009-CJOB |                         subPropA:filttest:sdf |      null |         null |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   null |       null |            null |         null |               null |     DVM | 924d6743-31fd-11e3-97f7-001c42000009 |          [] |      null |        [] | ["subE","subI","subH"] |     en_us |         [] |      text |         m |                   [{"type":"text","lang":"en_us","uom":"m","datas":["subE","subI","subH"],"links":[]}] |      null |                                 null | null |     null |       null |        null |   null |    null
 924d6742-31fd-11e3-97f7-001c42000009-CJOB |                     urn:bby:pcm:ingest:status |      null |         null |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   null |       null |            null |         subC |               null |     S00 | 924d6744-31fd-11e3-97f7-001c42000009 |          [] |      null |        [] |                   null |      null |         [] |      null |      null |                                 [{"type":"text","lang":"en_us","uom":"m","datas":["subC"],"links":[]}] |      null |                                 null | null |     null |       null |        null |   null |    null
 924d6742-31fd-11e3-97f7-001c42000009-CJOB |      urn:bby:pcm:job:sourceparty:reference:id |      null |         null |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   null |       null |            null |         null |               null |     S00 | 924d6745-31fd-11e3-97f7-001c42000009 |          [] |      null |        [] |                   null |      null |         [] |      null |      null | [{"type":"text","lang":"en_us","uom":"m","datas":["cdc8911c-7092-4c71-a7a6-935331ff2c5c"],"links":[]}] |      null | cdc8911c-7092-4c71-a7a6-935331ff2c5c | null |     null |       null |        null |   null |    null
 924d6742-31fd-11e3-97f7-001c42000009-CJOB | urn@bby@pcm@job@ingest@content@complete@count |      null |         null |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   null |       null |            null |         null |               null |    null |                                 null |          [] |      null |      null |                   null |      null |       null |      null |      null |                                                                                                   null |      null |                                 null | null |     null |       null |        null |   null |    null


TRACE: 
DEBUG [Thrift:1] 2013-10-15 14:45:26,841 CassandraServer.java (line 1699) execute_cql3_query
TRACE [Thrift:1] 2013-10-15 14:45:26,842 QueryProcessor.java (line 100) Process org.apache.cassandra.cql3.statements.SelectStatement@7aacaaae @CL.ONE
TRACE [Thrift:1] 2013-10-15 14:45:26,843 ReadCallback.java (line 67) Blockfor is 1; setting up requests to /127.0.0.1
TRACE [ReadStage:3] 2013-10-15 14:45:26,851 SSTableReader.java (line 756) Adding cache entry for KeyCacheKey(/Users/a999166/aaa-projects/apache-cassandra-1.2.8/z-serverfiles/data/wayfair_submission/entity_job/wayfair_submission-entity_job-ic-2, 39323464363734322d333166642d313165332d393766372d3030316334323030303030392d434a4f42) -> org.apache.cassandra.db.RowIndexEntry@4017415d
TRACE [ReadStage:3] 2013-10-15 14:45:26,853 SliceQueryFilter.java (line 161) collecting 0 of 10000: __CPSYS_links::false:0@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,853 SliceQueryFilter.java (line 161) collecting 1 of 10000: __CPSYS_links:e_entlinks:false:566@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,853 SliceQueryFilter.java (line 161) collecting 1 of 10000: __CPSYS_name::false:0@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,853 SliceQueryFilter.java (line 161) collecting 2 of 10000: __CPSYS_name:e_entname:false:10@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161) collecting 2 of 10000: __CPSYS_type::false:0@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161) collecting 3 of 10000: __CPSYS_type:e_enttype:false:15@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161) collecting 3 of 10000: subPropA\:filttest\:sdf::false:0@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161) collecting 4 of 10000: subPropA\:filttest\:sdf:p_flags:false:3@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161) collecting 4 of 10000: subPropA\:filttest\:sdf:p_propid:false:36@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161) collecting 4 of 10000: subPropA\:filttest\:sdf:p_proplinks:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161) collecting 4 of 10000: subPropA\:filttest\:sdf:p_subents:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161) collecting 4 of 10000: subPropA\:filttest\:sdf:p_val:false:22@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161) collecting 4 of 10000: subPropA\:filttest\:sdf:p_vallang:false:5@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,855 SliceQueryFilter.java (line 161) collecting 4 of 10000: subPropA\:filttest\:sdf:p_vallinks:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,855 SliceQueryFilter.java (line 161) collecting 4 of 10000: subPropA\:filttest\:sdf:p_valtype:false:4@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,855 SliceQueryFilter.java (line 161) collecting 4 of 10000: subPropA\:filttest\:sdf:p_valunit:false:1@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,855 SliceQueryFilter.java (line 161) collecting 4 of 10000: subPropA\:filttest\:sdf:p_vars:false:84@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,855 SliceQueryFilter.java (line 161) collecting 4 of 10000: urn\:bby\:pcm\:ingest\:status::false:0@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,855 SliceQueryFilter.java (line 161) collecting 5 of 10000: urn\:bby\:pcm\:ingest\:status:ingeststatus:false:4@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,855 SliceQueryFilter.java (line 161) collecting 5 of 10000: urn\:bby\:pcm\:ingest\:status:p_flags:false:3@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,855 SliceQueryFilter.java (line 161) collecting 5 of 10000: urn\:bby\:pcm\:ingest\:status:p_propid:false:36@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,856 SliceQueryFilter.java (line 161) collecting 5 of 10000: urn\:bby\:pcm\:ingest\:status:p_proplinks:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,856 SliceQueryFilter.java (line 161) collecting 5 of 10000: urn\:bby\:pcm\:ingest\:status:p_subents:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,856 SliceQueryFilter.java (line 161) collecting 5 of 10000: urn\:bby\:pcm\:ingest\:status:p_vallinks:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,856 SliceQueryFilter.java (line 161) collecting 5 of 10000: urn\:bby\:pcm\:ingest\:status:p_vars:false:70@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,856 SliceQueryFilter.java (line 161) collecting 5 of 10000: urn\:bby\:pcm\:job\:sourceparty\:reference\:id::false:0@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,856 SliceQueryFilter.java (line 161) collecting 6 of 10000: urn\:bby\:pcm\:job\:sourceparty\:reference\:id:p_flags:false:3@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,856 SliceQueryFilter.java (line 161) collecting 6 of 10000: urn\:bby\:pcm\:job\:sourceparty\:reference\:id:p_propid:false:36@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,856 SliceQueryFilter.java (line 161) collecting 6 of 10000: urn\:bby\:pcm\:job\:sourceparty\:reference\:id:p_proplinks:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,857 SliceQueryFilter.java (line 161) collecting 6 of 10000: urn\:bby\:pcm\:job\:sourceparty\:reference\:id:p_subents:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,857 SliceQueryFilter.java (line 161) collecting 6 of 10000: urn\:bby\:pcm\:job\:sourceparty\:reference\:id:p_vallinks:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,857 SliceQueryFilter.java (line 161) collecting 6 of 10000: urn\:bby\:pcm\:job\:sourceparty\:reference\:id:p_vars:false:102@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,857 SliceQueryFilter.java (line 161) collecting 6 of 10000: urn\:bby\:pcm\:job\:sourceparty\:reference\:id:referenceid:false:36@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,857 SliceQueryFilter.java (line 161) collecting 6 of 10000: urn@bby@pcm@job@ingest@content@complete@count::false:0@1381860857189000
TRACE [ReadStage:3] 2013-10-15 14:45:26,857 SliceQueryFilter.java (line 161) collecting 7 of 10000: urn@bby@pcm@job@ingest@content@complete@count:p_proplinks:false:2@1381860857189000


------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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')

RESULT:
 e_entid                                   | p_prop                    | describes | dndcondition | e_entlinks | e_entname  | e_enttype | ingeststatus | ingeststatusdetail | p_flags | p_propid                             | p_proplinks | p_storage | p_subents | p_val                  | p_vallang | p_vallinks | p_valtype | p_valunit | p_vars                                                                               | partnerid | referenceid | size | sourceip | submitdate | submitevent | userid | version
 924d6742-31fd-11e3-97f7-001c42000009-CJOB |              __CPSYS_name |      null |         null |       null | SUBENT-100 |      null |         null |               null |    null |                                 null |        null |      null |      null |                   null |      null |       null |      null |      null |                                                                                 null |      null |        null | null |     null |       null |        null |   null |    null
 924d6742-31fd-11e3-97f7-001c42000009-CJOB |     subPropA:filttest:sdf |      null |         null |       null |       null |      null |         null |               null |     DVM | 924d6743-31fd-11e3-97f7-001c42000009 |          [] |      null |        [] | ["subE","subI","subH"] |     en_us |         [] |      text |         m | [{"type":"text","lang":"en_us","uom":"m","datas":["subE","subI","subH"],"links":[]}] |      null |        null | null |     null |       null |        null |   null |    null
 924d6742-31fd-11e3-97f7-001c42000009-CJOB | urn:bby:pcm:ingest:status |      null |         null |       null |       null |      null |         subC |               null |     S00 | 924d6744-31fd-11e3-97f7-001c42000009 |          [] |      null |        [] |                   null |      null |         [] |      null |      null |               [{"type":"text","lang":"en_us","uom":"m","datas":["subC"],"links":[]}] |      null |        null | null |     null |       null |        null |   null |    null

TRACE:
DEBUG [Thrift:1] 2013-10-15 14:48:39,115 CassandraServer.java (line 1699) execute_cql3_query
TRACE [Thrift:1] 2013-10-15 14:48:39,116 QueryProcessor.java (line 100) Process org.apache.cassandra.cql3.statements.SelectStatement@58053ef7 @CL.ONE
TRACE [Thrift:1] 2013-10-15 14:48:39,116 ReadCallback.java (line 67) Blockfor is 1; setting up requests to /127.0.0.1
TRACE [ReadStage:33] 2013-10-15 14:48:39,117 SliceQueryFilter.java (line 161) collecting 0 of 10000: __CPSYS_name::false:0@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,117 SliceQueryFilter.java (line 161) collecting 1 of 10000: __CPSYS_name:e_entname:false:10@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,117 SliceQueryFilter.java (line 161) collecting 1 of 10000: subPropA\:filttest\:sdf::false:0@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161) collecting 2 of 10000: subPropA\:filttest\:sdf:p_flags:false:3@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161) collecting 2 of 10000: subPropA\:filttest\:sdf:p_propid:false:36@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161) collecting 2 of 10000: subPropA\:filttest\:sdf:p_proplinks:false:2@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161) collecting 2 of 10000: subPropA\:filttest\:sdf:p_subents:false:2@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161) collecting 2 of 10000: subPropA\:filttest\:sdf:p_val:false:22@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161) collecting 2 of 10000: subPropA\:filttest\:sdf:p_vallang:false:5@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161) collecting 2 of 10000: subPropA\:filttest\:sdf:p_vallinks:false:2@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161) collecting 2 of 10000: subPropA\:filttest\:sdf:p_valtype:false:4@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161) collecting 2 of 10000: subPropA\:filttest\:sdf:p_valunit:false:1@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,119 SliceQueryFilter.java (line 161) collecting 2 of 10000: subPropA\:filttest\:sdf:p_vars:false:84@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,119 SliceQueryFilter.java (line 161) collecting 2 of 10000: urn\:bby\:pcm\:ingest\:status:ingeststatus:false:4@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,119 SliceQueryFilter.java (line 161) collecting 3 of 10000: urn\:bby\:pcm\:ingest\:status:p_flags:false:3@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,119 SliceQueryFilter.java (line 161) collecting 3 of 10000: urn\:bby\:pcm\:ingest\:status:p_propid:false:36@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,119 SliceQueryFilter.java (line 161) collecting 3 of 10000: urn\:bby\:pcm\:ingest\:status:p_proplinks:false:2@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,119 SliceQueryFilter.java (line 161) collecting 3 of 10000: urn\:bby\:pcm\:ingest\:status:p_subents:false:2@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,119 SliceQueryFilter.java (line 161) collecting 3 of 10000: urn\:bby\:pcm\:ingest\:status:p_vallinks:false:2@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,119 SliceQueryFilter.java (line 161) collecting 3 of 10000: urn\:bby\:pcm\:ingest\:status:p_vars:false:70@1381445090517000
DEBUG [Thrift:1] 2013-10-15 14:48:39,120 Tracing.java (line 167) request complete


> 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)

Mime
View raw message