Hi,
I have just started with Cassandra, created a simple ColumnFamily and some data using command given on Getting started on Cassandra download page, by executing below queries.
CREATE TABLE users (
user_id int PRIMARY KEY,
fname text,
lname text
);
INSERT INTO users (user_id, fname, lname)
VALUES (1745, 'john', 'smith');
INSERT INTO users (user_id, fname, lname)
VALUES (1744, 'john', 'doe');
INSERT INTO users (user_id, fname, lname)
VALUES (1746, 'john', 'smith');
But when i fetch data using Hector API from Cassandra in Column name it contain blank space like column name fname will be: ' fname '. And for my queries from Java Hector API i need to use same column name with blank space to fetch or save data.
My Hector code for fetching data:
RangeSlicesQuery<String, String, String> rangeSlicesQuery
= HFactory.createRangeSlicesQuery(keyspace, STR, STR, STR);
rangeSlicesQuery.setColumnFamily(columnFamily)
.setColumnNames(" fname ", " lname ")
.setKeys("6", "5")
.setRowCount(row_count);
QueryResult<OrderedRows<String, String, String>> result = rangeSlicesQuery.execute();
as i use column name in .setColumnNames(" fname ", " lname ") it gets data with same column names with blank space, if i will replace this with this .setColumnNames("fname", "lname") it will not get data.
Anybody have any idea, what i have done wrong, or what do i do to remove those trailing space.
Thanks