[jira] [Comment Edited] (CASSANDRA-8421) Cassandra 2.1.1 Cassandra 2.1.2 UDT not returning value for LIST type as UDT
[
https://issues.apache.org/jira/browse/CASSANDRA-8421?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=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: '89007'}, {key: 'firstName', value:
'James'}, {key: 'lastName', value: 'Smith'}, {key: 'primaryEmail', value:
'james9...@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: '89007'}, {key: 'firstName', value:
'James'}, {key: 'lastName', value: 'Smith'}, {key: 'primaryEmail', value:
'james9...@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 listfieldmap,
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_22'} 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)
[jira] [Comment Edited] (CASSANDRA-8421) Cassandra 2.1.1 Cassandra 2.1.2 UDT not returning value for LIST type as UDT
[
https://issues.apache.org/jira/browse/CASSANDRA-8421?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=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: '89007'}, {key: 'firstName', value:
'James'}, {key: 'lastName', value: 'Smith'}, {key: 'primaryEmail', value:
'james9...@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: '89007'}, {key: 'firstName', value:
'James'}, {key: 'lastName', value: 'Smith'}, {key: 'primaryEmail', value:
'james9...@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 listfieldmap,
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_22'} 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)
[jira] [Comment Edited] (CASSANDRA-8421) Cassandra 2.1.1 Cassandra 2.1.2 UDT not returning value for LIST type as UDT
[
https://issues.apache.org/jira/browse/CASSANDRA-8421?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14249666#comment-14249666
]
madheswaran edited comment on CASSANDRA-8421 at 12/17/14 10:10 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
{code}
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: '89007'}, {key: 'firstName', value:
'James'}, {key: 'lastName', value: 'Smith'}, {key: 'primaryEmail', value:
'james9...@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
{code}
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: '89007'}, {key: 'firstName', value:
'James'}, {key: 'lastName', value: 'Smith'}, {key: 'primaryEmail', value:
'james9...@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 listfieldmap,
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_22'} 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)
[jira] [Comment Edited] (CASSANDRA-8421) Cassandra 2.1.1 Cassandra 2.1.2 UDT not returning value for LIST type as UDT
[
https://issues.apache.org/jira/browse/CASSANDRA-8421?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14249666#comment-14249666
]
madheswaran edited comment on CASSANDRA-8421 at 12/17/14 10:10 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
{code}
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: '89007'}, {key: 'firstName', value:
'James'}, {key: 'lastName', value: 'Smith'}, {key: 'primaryEmail', value:
'james9...@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
{code}
3) Try search operation ( Select query 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
{code}
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: '89007'}, {key: 'firstName', value:
'James'}, {key: 'lastName', value: 'Smith'}, {key: 'primaryEmail', value:
'james9...@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
{code}
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 listfieldmap,
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_22'} 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)
[jira] [Comment Edited] (CASSANDRA-8421) Cassandra 2.1.1 Cassandra 2.1.2 UDT not returning value for LIST type as UDT
[
https://issues.apache.org/jira/browse/CASSANDRA-8421?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14246742#comment-14246742
]
Philip Thompson edited comment on CASSANDRA-8421 at 12/15/14 3:48 PM:
--
[~slebresne], I attached four unit tests in that file. {{testOneIndex}} and
{{testTwoIndices}} are failing on 2.1-head and trunk for me.
was (Author: philipthompson):
[~slebresne], {{testOneIndex}} and {{testTwoIndices}} are failing on 2.1-head
for me.
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: Sylvain Lebresne
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 listfieldmap,
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_22'} 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)
