column name trailing with blank spaces

[shamsul haque]

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