Return-Path: X-Original-To: apmail-cassandra-commits-archive@www.apache.org Delivered-To: apmail-cassandra-commits-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 7F453964D for ; Wed, 17 Dec 2014 10:10:14 +0000 (UTC) Received: (qmail 7832 invoked by uid 500); 17 Dec 2014 10:10:14 -0000 Delivered-To: apmail-cassandra-commits-archive@cassandra.apache.org Received: (qmail 7798 invoked by uid 500); 17 Dec 2014 10:10:14 -0000 Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@cassandra.apache.org Delivered-To: mailing list commits@cassandra.apache.org Received: (qmail 7784 invoked by uid 99); 17 Dec 2014 10:10:14 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 17 Dec 2014 10:10:14 +0000 Date: Wed, 17 Dec 2014 10:10:14 +0000 (UTC) From: "madheswaran (JIRA)" To: commits@cassandra.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Comment Edited] (CASSANDRA-8421) Cassandra 2.1.1 & Cassandra 2.1.2 UDT not returning value for LIST type as UDT MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/CASSANDRA-8421?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14249666#comment-14249666 ] madheswaran edited comment on CASSANDRA-8421 at 12/17/14 10:09 AM: ------------------------------------------------------------------- Hi Benjamin, Steps to reproduce: 1) Please create table as I mentioned with Secondary index's for other fields. 2) Insert just 4 records , similar to below {quote} 723d4295-1ad2-4aba-8638-5bdd6b3be8b7 | 1 | pcs.com | null | DefaultPCSTemplate_User | [{key: 'access', value: '[{"entityId":"c0e30978-9662-4d6e-9503-7fcfd4d7693c"},{"entityId":"9af1e1e2-05bd-4929-a2cc-ff9e6526992c"}]'}, {key: 'contactNumber', value: '8888888889007'}, {key: 'firstName', value: 'James'}, {key: 'lastName', value: 'Smith'}, {key: 'primaryEmail', value: 'james9007@pcs.com'}, {key: 'roleName', value: 'admin'}, {key: 'userName', value: 'James9007'}, {key: 'userType', value: 'some'}, {key: 'password', value: 'James9007'}] | USER | 5a0dad10-7edf-11e4-8d47-4b86331ee8c7 | 0 | ACTIVE | null {quote} 3) Try search operation ( Select with condition ) was (Author: madheswaran): Hi Benjamin, Steps to reproduce: 1) Please create table as I mentioned with Secondary index's for other fields. 2) Insert just 4 records , similar to below {quote} 723d4295-1ad2-4aba-8638-5bdd6b3be8b7 | 1 | pcs.com | null | DefaultPCSTemplate_User | [{key: 'access', value: '[{"entityId":"c0e30978-9662-4d6e-9503-7fcfd4d7693c"},{"entityId":"9af1e1e2-05bd-4929-a2cc-ff9e6526992c"}]'}, {key: 'contactNumber', value: '8888888889007'}, {key: 'firstName', value: 'James'}, {key: 'lastName', value: 'Smith'}, {key: 'primaryEmail', value: 'james9007@pcs.com'}, {key: 'roleName', value: 'admin'}, {key: 'userName', value: 'James9007'}, {key: 'userType', value: 'some'}, {key: 'password', value: 'James9007'}] | USER | 5a0dad10-7edf-11e4-8d47-4b86331ee8c7 | 0 | ACTIVE | null {quote} 3) Try search operation ( Select with condition ) > Cassandra 2.1.1 & Cassandra 2.1.2 UDT not returning value for LIST type as UDT > ------------------------------------------------------------------------------ > > Key: CASSANDRA-8421 > URL: https://issues.apache.org/jira/browse/CASSANDRA-8421 > Project: Cassandra > Issue Type: Bug > Components: API > Environment: single node cassandra > Reporter: madheswaran > Assignee: Benjamin Lerer > Fix For: 3.0, 2.1.3 > > Attachments: 8421-unittest.txt, entity_data.csv > > > I using List and its data type is UDT. > UDT: > {code} > CREATE TYPE > fieldmap ( > key text, > value text > ); > {code} > TABLE: > {code} > CREATE TABLE entity ( > entity_id uuid PRIMARY KEY, > begining int, > domain text, > domain_type text, > entity_template_name text, > field_values list, > global_entity_type text, > revision_time timeuuid, > status_key int, > status_name text, > uuid timeuuid > ) {code} > INDEX: > {code} > CREATE INDEX entity_domain_idx_1 ON galaxy_dev.entity (domain); > CREATE INDEX entity_field_values_idx_1 ON galaxy_dev.entity (field_values); > CREATE INDEX entity_global_entity_type_idx_1 ON galaxy_dev.entity (gen_type ); > {code} > QUERY > {code} > SELECT * FROM entity WHERE status_key < 3 and field_values contains {key: 'userName', value: 'Sprint5_200002'} and gen_type = 'USER' and domain = 'S4_1017.abc.com' allow filtering; > {code} > The above query return value for some row and not for many rows but those rows and data's are exist. > Observation: > If I execute query with other than field_maps, then it returns value. I suspect the problem with LIST with UDT. > I have single node cassadra DB. Please let me know why this strange behavior from cassandra. -- This message was sent by Atlassian JIRA (v6.3.4#6332)