[jira] [Created] (CASSANDRA-9343) Connecting Cassandra via Hive throws error
madheswaran created CASSANDRA-9343: -- Summary: Connecting Cassandra via Hive throws error Key: CASSANDRA-9343 URL: https://issues.apache.org/jira/browse/CASSANDRA-9343 Project: Cassandra Issue Type: Bug Reporter: madheswaran CREATE EXTERNAL TABLE g3( a int, b int, c int ) STORED BY 'org.apache.hadoop.hive.cassandra.cql.CqlStorageHandler' WITH SERDEPROPERTIES(cql.primarykey = a,b, cassandra.host = 10.234.31.170, cassandra.port = 9160 ) TBLPROPERTIES (cassandra.ks.name = device_cloud_integration,cassandra.cf.name = g3,cassandra.ks.repfactor = 2,cassandra.ks.strategy = org.apache.cassandra.locator.SimpleStrategy,cassandra.partitioner=org.apache.cassandra.dht.RandomPartitioner ); OK Time taken: 0.407 seconds hive select * from g3; OK Failed with exception java.io.IOException:java.lang.RuntimeException: org.apache.cassandra.exceptions.ConfigurationException: Unable to find partitioner class 'org.apache.cassandra.dht.RandomPartitioner' Time taken: 0.217 seconds hive add jar cassandra-all-2.1.5.jar; Added [cassandra-all-2.1.5.jar] to class path Added resources: [cassandra-all-2.1.5.jar] hive select * from g3; OK Failed with exception java.io.IOException:java.lang.RuntimeException: org.apache.cassandra.exceptions.ConfigurationException: Unable to find partitioner class 'org.apache.cassandra.dht.RandomPartitioner' Time taken: 0.215 seconds -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (CASSANDRA-9343) Connecting Cassandra via Hive throws error
[ https://issues.apache.org/jira/browse/CASSANDRA-9343?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14538317#comment-14538317 ] madheswaran commented on CASSANDRA-9343: Hi Philip, Sorry both (CASSANDRA-9340 CASSANDRA-9343) are same issue. Connecting Cassandra via Hive throws error -- Key: CASSANDRA-9343 URL: https://issues.apache.org/jira/browse/CASSANDRA-9343 Project: Cassandra Issue Type: Bug Components: Hadoop Reporter: madheswaran CREATE EXTERNAL TABLE g3( a int, b int, c int ) STORED BY 'org.apache.hadoop.hive.cassandra.cql.CqlStorageHandler' WITH SERDEPROPERTIES(cql.primarykey = a,b, cassandra.host = 10.234.31.170, cassandra.port = 9160 ) TBLPROPERTIES (cassandra.ks.name = device_cloud_integration,cassandra.cf.name = g3,cassandra.ks.repfactor = 2,cassandra.ks.strategy = org.apache.cassandra.locator.SimpleStrategy,cassandra.partitioner=org.apache.cassandra.dht.RandomPartitioner ); OK Time taken: 0.407 seconds hive select * from g3; OK Failed with exception java.io.IOException:java.lang.RuntimeException: org.apache.cassandra.exceptions.ConfigurationException: Unable to find partitioner class 'org.apache.cassandra.dht.RandomPartitioner' Time taken: 0.217 seconds hive add jar cassandra-all-2.1.5.jar; Added [cassandra-all-2.1.5.jar] to class path Added resources: [cassandra-all-2.1.5.jar] hive select * from g3; OK Failed with exception java.io.IOException:java.lang.RuntimeException: org.apache.cassandra.exceptions.ConfigurationException: Unable to find partitioner class 'org.apache.cassandra.dht.RandomPartitioner' Time taken: 0.215 seconds -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (CASSANDRA-9343) Connecting Cassandra via Hive throws error
[ https://issues.apache.org/jira/browse/CASSANDRA-9343?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14538424#comment-14538424 ] madheswaran commented on CASSANDRA-9343: Philip, Please can you give me solution to resolve this issue. Connecting Cassandra via Hive throws error -- Key: CASSANDRA-9343 URL: https://issues.apache.org/jira/browse/CASSANDRA-9343 Project: Cassandra Issue Type: Bug Components: Hadoop Reporter: madheswaran CREATE EXTERNAL TABLE g3( a int, b int, c int ) STORED BY 'org.apache.hadoop.hive.cassandra.cql.CqlStorageHandler' WITH SERDEPROPERTIES(cql.primarykey = a,b, cassandra.host = 10.234.31.170, cassandra.port = 9160 ) TBLPROPERTIES (cassandra.ks.name = device_cloud_integration,cassandra.cf.name = g3,cassandra.ks.repfactor = 2,cassandra.ks.strategy = org.apache.cassandra.locator.SimpleStrategy,cassandra.partitioner=org.apache.cassandra.dht.RandomPartitioner ); OK Time taken: 0.407 seconds hive select * from g3; OK Failed with exception java.io.IOException:java.lang.RuntimeException: org.apache.cassandra.exceptions.ConfigurationException: Unable to find partitioner class 'org.apache.cassandra.dht.RandomPartitioner' Time taken: 0.217 seconds hive add jar cassandra-all-2.1.5.jar; Added [cassandra-all-2.1.5.jar] to class path Added resources: [cassandra-all-2.1.5.jar] hive select * from g3; OK Failed with exception java.io.IOException:java.lang.RuntimeException: org.apache.cassandra.exceptions.ConfigurationException: Unable to find partitioner class 'org.apache.cassandra.dht.RandomPartitioner' Time taken: 0.215 seconds -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (CASSANDRA-9340) Cassandra Hive throws Unable to find partitioner class 'org.apache.cassandra.dht.Murmur3Partitioner'
madheswaran created CASSANDRA-9340: -- Summary: Cassandra Hive throws Unable to find partitioner class 'org.apache.cassandra.dht.Murmur3Partitioner' Key: CASSANDRA-9340 URL: https://issues.apache.org/jira/browse/CASSANDRA-9340 Project: Cassandra Issue Type: Bug Components: Core Environment: Hive 1.1.0 Cassandra 2.1.5 Reporter: madheswaran Fix For: 2.1.5 Using Hive trying to execute select statement on cassandra, but it throws error: hive select * from genericquantity; OK Failed with exception java.io.IOException:java.lang.RuntimeException: org.apache.cassandra.exceptions.ConfigurationException: Unable to find partitioner class 'org.apache.cassandra.dht.Murmur3Partitioner' Time taken: 0.518 seconds -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (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=14258684#comment-14258684
]
madheswaran commented on CASSANDRA-8421:
Any updates Philip or Benjamin.
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] [Commented] (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 commented on CASSANDRA-8421:
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: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] [Commented] (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=14245247#comment-14245247
]
madheswaran commented on CASSANDRA-8421:
Sylvain Lebresne and Philip Thompson, are you able to reproduce this issue?.
Please let me know if you need any more inputs.
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)
[jira] [Commented] (CASSANDRA-8421) Cassandra 2.1.1 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=14239219#comment-14239219
]
madheswaran commented on CASSANDRA-8421:
h3. Another Issue in Search:
--
First Query searching list value {color:red} {key: 'contactNumber', value:
'89007'} {color}
{code:title=First Query |borderStyle=solid}
1) SELECT * from entity WHERE status_key 3 and field_values contains {key:
'contactNumber', value: '89007'} and domain = 'pcs.com' allow filtering
;
entity_id| begining | domain | domain_type |
entity_template_name| field_values
|
global_entity_type | revision_time| status_key |
status_name | uuid
--+--+-+-+-+++--++-+--
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
(1 rows)
{code}
2) Same query but searching another value of list {color:red} {key: 'access',
value:
'[{entityId:c0e30978-9662-4d6e-9503-7fcfd4d7693c},{entityId:9af1e1e2-05bd-4929-a2cc-ff9e6526992c}]'}
{color} from same *ROW* but it is not returning any value.
{code:title=SecondQuery |borderStyle=solid}
SELECT * from entity WHERE status_key 3 and field_values contains {key:
'access', value:
'[{entityId:c0e30978-9662-4d6e-9503-7fcfd4d7693c},{entityId:9af1e1e2-05bd-4929-a2cc-ff9e6526992c}]'}
and domain = 'pcs.com' allow filtering ;
(0 rows)
{code}
Index Created for both status_key and field_values
{code}
CREATE INDEX entity_begining_idx_1 ON galaxy_development.entity (begining);
CREATE INDEX entity_domain_idx_1 ON galaxy_development.entity (domain);
CREATE INDEX entity_field_values_idx_1 ON galaxy_development.entity
(field_values);
CREATE INDEX entity_global_entity_type_idx_1 ON galaxy_development.entity
(global_entity_type);
CREATE INDEX entity_revision_time_idx_1 ON galaxy_development.entity
(revision_time);
CREATE INDEX entity_status_key_idx_1 ON galaxy_development.entity (status_key);
{code}
Cassandra 2.1.1 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:
[jira] [Updated] (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:all-tabpanel
]
madheswaran updated CASSANDRA-8421:
---
Reproduced In: 2.1.2, 2.1.1 (was: 2.1.1, 2.1.2)
Summary: Cassandra 2.1.1 Cassandra 2.1.2 UDT not returning value
for LIST type as UDT (was: Cassandra 2.1.1 UDT not returning value for LIST
type as UDT)
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)
[jira] [Commented] (CASSANDRA-8421) Cassandra 2.1.1 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=14237722#comment-14237722
]
madheswaran commented on CASSANDRA-8421:
I never used CQLTester?.. Please can you tell me where I can Download CQLTester
Cassandra 2.1.1 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: 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] [Commented] (CASSANDRA-8421) Cassandra 2.1.1 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=14237427#comment-14237427
]
madheswaran commented on CASSANDRA-8421:
Philip Thompson : Index was already created for status_key, field_values and
etc. Please find the index details:
CREATE INDEX entity_begining_idx_1 ON galaxy_dev.entity (begining);
CREATE INDEX entity_domain_idx_1 ON galaxy_dev.entity (domain);
CREATE INDEX field ON galaxy_dev.entity (field_values);
CREATE INDEX entity_global_entity_type_idx_1 ON galaxy_dev.entity
(global_entity_type);
CREATE INDEX entity_revision_time_idx_1 ON galaxy_dev.entity (revision_time);
CREATE INDEX stat ON galaxy_dev.entity (status_key);
Cassandra 2.1.1 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
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] [Updated] (CASSANDRA-8421) Cassandra 2.1.1 UDT not returning value for LIST type as UDT
[
https://issues.apache.org/jira/browse/CASSANDRA-8421?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
madheswaran updated CASSANDRA-8421:
---
Reproduced In: 2.1.2, 2.1.1 (was: 2.1.1, 2.1.2)
Attachment: entity_data.csv
Cassandra 2.1.1 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: 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] [Commented] (CASSANDRA-8421) Cassandra 2.1.1 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=14237435#comment-14237435
]
madheswaran commented on CASSANDRA-8421:
Philip Thompson: Exported the stored data into CSV file and attached here.
Cassandra 2.1.1 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: 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] [Commented] (CASSANDRA-8435) Cassandra LIST with UDT fails to create index in SOLR throws JDBC error
[
https://issues.apache.org/jira/browse/CASSANDRA-8435?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14237440#comment-14237440
]
madheswaran commented on CASSANDRA-8435:
Jonathan Ellis
Please see this error
Caused by: java.lang.NullPointerException
at org.apache.cassandra.cql.jdbc.ListMaker.compose(ListMaker.java:61)
Cassandra LIST with UDT fails to create index in SOLR throws JDBC error
---
Key: CASSANDRA-8435
URL: https://issues.apache.org/jira/browse/CASSANDRA-8435
Project: Cassandra
Issue Type: Bug
Components: Drivers (now out of tree)
Reporter: madheswaran
Priority: Critical
16767 [qtp297774990-12] INFO org.apache.solr.handler.dataimport.DataImporter
– Loading DIH Configuration: dataconfigCassandra.xml
16779 [qtp297774990-12] INFO org.apache.solr.handler.dataimport.DataImporter
– Data Configuration loaded successfully
16788 [Thread-15] INFO org.apache.solr.handler.dataimport.DataImporter –
Starting Full Import
16789 [qtp297774990-12] INFO org.apache.solr.core.SolrCore – [Entity_dev]
webapp=/solr path=/dataimport params=
{optimize=falseindent=trueclean=truecommit=trueverbose=falsecommand=full-importdebug=falsewt=json}
status=0 QTime=27
16810 [qtp297774990-12] INFO org.apache.solr.core.SolrCore – [Entity_dev]
webapp=/solr path=/dataimport params=
{indent=truecommand=status_=1416042006354wt=json}
status=0 QTime=0
16831 [Thread-15] INFO
org.apache.solr.handler.dataimport.SimplePropertiesWriter – Read
dataimport.properties
16917 [Thread-15] INFO org.apache.solr.search.SolrIndexSearcher – Opening
Searcher@6214b0dc[Entity_dev] realtime
16945 [Thread-15] INFO org.apache.solr.handler.dataimport.JdbcDataSource –
Creating a connection for entity Entity with URL:
jdbc:cassandra://10.234.31.153:9160/galaxy_dev
17082 [Thread-15] INFO org.apache.solr.handler.dataimport.JdbcDataSource –
Time taken for getConnection(): 136
17429 [Thread-15] ERROR org.apache.solr.handler.dataimport.DocBuilder –
Exception while processing: Entity document : SolrInputDocument(fields:
[]):org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to
execute query: select * from entity Processing Document # 1
at
org.apache.solr.handler.dataimport.DataImportHandlerException.wrapAndThrow(DataImportHandlerException.java:71)
at
org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.init(JdbcDataSource.java:283)
at
org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:240)
at
org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:44)
at
org.apache.solr.handler.dataimport.SqlEntityProcessor.initQuery(SqlEntityProcessor.java:59)
at
org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEntityProcessor.java:73)
at
org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(EntityProcessorWrapper.java:243)
at
org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:476)
at
org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:415)
at
org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:330)
at org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:232)
at
org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:416)
at
org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:480)
at
org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:461)
Caused by: java.lang.NullPointerException
at org.apache.cassandra.cql.jdbc.ListMaker.compose(ListMaker.java:61)
at org.apache.cassandra.cql.jdbc.TypedColumn.init(TypedColumn.java:68)
at
org.apache.cassandra.cql.jdbc.CassandraResultSet.createColumn(CassandraResultSet.java:1174)
at
org.apache.cassandra.cql.jdbc.CassandraResultSet.populateColumns(CassandraResultSet.java:240)
at
org.apache.cassandra.cql.jdbc.CassandraResultSet.init(CassandraResultSet.java:200)
at
org.apache.cassandra.cql.jdbc.CassandraStatement.doExecute(CassandraStatement.java:169)
at
org.apache.cassandra.cql.jdbc.CassandraStatement.execute(CassandraStatement.java:205)
at
org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.init(JdbcDataSource.java:276)
... 12 more
UDT:
=
DESCRIBE TYPE fieldmap ;
CREATE TYPE galaxy_dev.fieldmap (
key text,
value text
);
Table:
=
CREATE TABLE galaxy_dev.entity (
entity_id uuid PRIMARY KEY,
begining int,
domain text,
domain_type text,
entity_template_name text,
field_values listfrozenfieldmap,
global_entity_type text,
revision_time timeuuid,
status_key int,
status_name text,
uuid timeuuid
);
--
This message was sent by Atlassian JIRA
[jira] [Reopened] (CASSANDRA-8435) Cassandra LIST with UDT fails to create index in SOLR throws JDBC error
[
https://issues.apache.org/jira/browse/CASSANDRA-8435?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
madheswaran reopened CASSANDRA-8435:
Reproduced In: 2.1.2, 2.1.1 (was: 2.1.1, 2.1.2)
Cassandra Driver throwing NULL pointer exception for collection ( LIST) with
UDT.
For non UDT it works fine.
Cassandra LIST with UDT fails to create index in SOLR throws JDBC error
---
Key: CASSANDRA-8435
URL: https://issues.apache.org/jira/browse/CASSANDRA-8435
Project: Cassandra
Issue Type: Bug
Components: Drivers (now out of tree)
Reporter: madheswaran
Priority: Critical
16767 [qtp297774990-12] INFO org.apache.solr.handler.dataimport.DataImporter
– Loading DIH Configuration: dataconfigCassandra.xml
16779 [qtp297774990-12] INFO org.apache.solr.handler.dataimport.DataImporter
– Data Configuration loaded successfully
16788 [Thread-15] INFO org.apache.solr.handler.dataimport.DataImporter –
Starting Full Import
16789 [qtp297774990-12] INFO org.apache.solr.core.SolrCore – [Entity_dev]
webapp=/solr path=/dataimport params=
{optimize=falseindent=trueclean=truecommit=trueverbose=falsecommand=full-importdebug=falsewt=json}
status=0 QTime=27
16810 [qtp297774990-12] INFO org.apache.solr.core.SolrCore – [Entity_dev]
webapp=/solr path=/dataimport params=
{indent=truecommand=status_=1416042006354wt=json}
status=0 QTime=0
16831 [Thread-15] INFO
org.apache.solr.handler.dataimport.SimplePropertiesWriter – Read
dataimport.properties
16917 [Thread-15] INFO org.apache.solr.search.SolrIndexSearcher – Opening
Searcher@6214b0dc[Entity_dev] realtime
16945 [Thread-15] INFO org.apache.solr.handler.dataimport.JdbcDataSource –
Creating a connection for entity Entity with URL:
jdbc:cassandra://10.234.31.153:9160/galaxy_dev
17082 [Thread-15] INFO org.apache.solr.handler.dataimport.JdbcDataSource –
Time taken for getConnection(): 136
17429 [Thread-15] ERROR org.apache.solr.handler.dataimport.DocBuilder –
Exception while processing: Entity document : SolrInputDocument(fields:
[]):org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to
execute query: select * from entity Processing Document # 1
at
org.apache.solr.handler.dataimport.DataImportHandlerException.wrapAndThrow(DataImportHandlerException.java:71)
at
org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.init(JdbcDataSource.java:283)
at
org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:240)
at
org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:44)
at
org.apache.solr.handler.dataimport.SqlEntityProcessor.initQuery(SqlEntityProcessor.java:59)
at
org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEntityProcessor.java:73)
at
org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(EntityProcessorWrapper.java:243)
at
org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:476)
at
org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:415)
at
org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:330)
at org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:232)
at
org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:416)
at
org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:480)
at
org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:461)
Caused by: java.lang.NullPointerException
at org.apache.cassandra.cql.jdbc.ListMaker.compose(ListMaker.java:61)
at org.apache.cassandra.cql.jdbc.TypedColumn.init(TypedColumn.java:68)
at
org.apache.cassandra.cql.jdbc.CassandraResultSet.createColumn(CassandraResultSet.java:1174)
at
org.apache.cassandra.cql.jdbc.CassandraResultSet.populateColumns(CassandraResultSet.java:240)
at
org.apache.cassandra.cql.jdbc.CassandraResultSet.init(CassandraResultSet.java:200)
at
org.apache.cassandra.cql.jdbc.CassandraStatement.doExecute(CassandraStatement.java:169)
at
org.apache.cassandra.cql.jdbc.CassandraStatement.execute(CassandraStatement.java:205)
at
org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.init(JdbcDataSource.java:276)
... 12 more
UDT:
=
DESCRIBE TYPE fieldmap ;
CREATE TYPE galaxy_dev.fieldmap (
key text,
value text
);
Table:
=
CREATE TABLE galaxy_dev.entity (
entity_id uuid PRIMARY KEY,
begining int,
domain text,
domain_type text,
entity_template_name text,
field_values listfrozenfieldmap,
global_entity_type text,
revision_time timeuuid,
status_key int,
status_name text,
uuid timeuuid
);
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Commented] (CASSANDRA-8421) Cassandra 2.1.1 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=14237054#comment-14237054
]
madheswaran commented on CASSANDRA-8421:
It is typo error. I used frozen keyword for UDT .
CREATE TYPE galaxy_dev.fieldmap (
key text,
value text
);
CREATE TABLE galaxy_dev.entity (
entity_id uuid PRIMARY KEY,
begining int,
domain text,
domain_type text,
entity_template_name text,
field_values listfrozenfieldmap,
global_entity_type text,
revision_time timeuuid,
status_key int,
status_name text,
uuid timeuuid
)
Even I tried with latest release Cassandra 2.1.2 and the issue is reproduced. :(
Total Records inserted was 20
cqlsh:galaxy_dev SELECT count(*) from entity;
count
---
20
SELECT * from entity where status_key = 3 allow filtering ;
it returns 17 records
SELECT * from entity where field_values CONTAINS {key: 'state', value:
'Dubai'}
it returns 19 records
SELECT * from entity where field_values CONTAINS {key: 'state', value:
'Dubai'} and status_key = 3 allow filtering;
returns only 1 record. ( but expected is 17 records ).
Sample Data which inserted:
cqlsh:master_db SELECT * FROM entity limit 1;
entity_id| begining | domain | domain_type |
entity_template_name | field_values
[jira] [Commented] (CASSANDRA-8421) Cassandra 2.1.1 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=14237056#comment-14237056
]
madheswaran commented on CASSANDRA-8421:
This issue is not reproduced in lesser records ( 4 or 5 records) when record
count get increased then it behaves abnormally.
Cassandra 2.1.1 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: Philip Thompson
Fix For: 3.0, 2.1.3
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] [Created] (CASSANDRA-8435) Cassandra LIST with UDT fails to create index in SOLR throws JDBC error
madheswaran created CASSANDRA-8435:
--
Summary: Cassandra LIST with UDT fails to create index in SOLR
throws JDBC error
Key: CASSANDRA-8435
URL: https://issues.apache.org/jira/browse/CASSANDRA-8435
Project: Cassandra
Issue Type: Bug
Components: Drivers (now out of tree)
Reporter: madheswaran
Priority: Critical
16767 [qtp297774990-12] INFO org.apache.solr.handler.dataimport.DataImporter –
Loading DIH Configuration: dataconfigCassandra.xml
16779 [qtp297774990-12] INFO org.apache.solr.handler.dataimport.DataImporter –
Data Configuration loaded successfully
16788 [Thread-15] INFO org.apache.solr.handler.dataimport.DataImporter –
Starting Full Import
16789 [qtp297774990-12] INFO org.apache.solr.core.SolrCore – [Entity_dev]
webapp=/solr path=/dataimport params=
{optimize=falseindent=trueclean=truecommit=trueverbose=falsecommand=full-importdebug=falsewt=json}
status=0 QTime=27
16810 [qtp297774990-12] INFO org.apache.solr.core.SolrCore – [Entity_dev]
webapp=/solr path=/dataimport params=
{indent=truecommand=status_=1416042006354wt=json}
status=0 QTime=0
16831 [Thread-15] INFO
org.apache.solr.handler.dataimport.SimplePropertiesWriter – Read
dataimport.properties
16917 [Thread-15] INFO org.apache.solr.search.SolrIndexSearcher – Opening
Searcher@6214b0dc[Entity_dev] realtime
16945 [Thread-15] INFO org.apache.solr.handler.dataimport.JdbcDataSource –
Creating a connection for entity Entity with URL:
jdbc:cassandra://10.234.31.153:9160/galaxy_dev
17082 [Thread-15] INFO org.apache.solr.handler.dataimport.JdbcDataSource – Time
taken for getConnection(): 136
17429 [Thread-15] ERROR org.apache.solr.handler.dataimport.DocBuilder –
Exception while processing: Entity document : SolrInputDocument(fields:
[]):org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to
execute query: select * from entity Processing Document # 1
at
org.apache.solr.handler.dataimport.DataImportHandlerException.wrapAndThrow(DataImportHandlerException.java:71)
at
org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.init(JdbcDataSource.java:283)
at
org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:240)
at
org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:44)
at
org.apache.solr.handler.dataimport.SqlEntityProcessor.initQuery(SqlEntityProcessor.java:59)
at
org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEntityProcessor.java:73)
at
org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(EntityProcessorWrapper.java:243)
at
org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:476)
at
org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:415)
at org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:330)
at org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:232)
at
org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:416)
at org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:480)
at org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:461)
Caused by: java.lang.NullPointerException
at org.apache.cassandra.cql.jdbc.ListMaker.compose(ListMaker.java:61)
at org.apache.cassandra.cql.jdbc.TypedColumn.init(TypedColumn.java:68)
at
org.apache.cassandra.cql.jdbc.CassandraResultSet.createColumn(CassandraResultSet.java:1174)
at
org.apache.cassandra.cql.jdbc.CassandraResultSet.populateColumns(CassandraResultSet.java:240)
at
org.apache.cassandra.cql.jdbc.CassandraResultSet.init(CassandraResultSet.java:200)
at
org.apache.cassandra.cql.jdbc.CassandraStatement.doExecute(CassandraStatement.java:169)
at
org.apache.cassandra.cql.jdbc.CassandraStatement.execute(CassandraStatement.java:205)
at
org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.init(JdbcDataSource.java:276)
... 12 more
UDT:
=
DESCRIBE TYPE fieldmap ;
CREATE TYPE galaxy_dev.fieldmap (
key text,
value text
);
Table:
=
CREATE TABLE galaxy_dev.entity (
entity_id uuid PRIMARY KEY,
begining int,
domain text,
domain_type text,
entity_template_name text,
field_values listfrozenfieldmap,
global_entity_type text,
revision_time timeuuid,
status_key int,
status_name text,
uuid timeuuid
);
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Created] (CASSANDRA-8421) Cassandra 2.1.1 UDT not returning value for LIST type as UDT
madheswaran created CASSANDRA-8421:
--
Summary: Cassandra 2.1.1 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
Fix For: 3.0, 2.1.2, 2.1 rc6
I using List and its data type is UDT.
UDT:
CREATE TYPE
fieldmap (
key text,
value text
);
TABLE:
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
)
INDEX:
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 );
QUERY
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;
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)
