get float column in cassandra mapreduce

2013-10-05 Thread Anseh Danesh
Hi all... I have a question. in the cassandra wordcount mapreduce with cql3, I want to get a string column and a float (or double) column as map input key and value. I mean I want to get date column of type string as key and temprature column of type float as value. but when I println value of

Deleting Row Key

2013-10-05 Thread Sebastian Schmidt
Hi, per default, the key of a row is not deleted, if all columns were deleted. I tried to figure out why, but I didn't find an answer, except that it is 'intended'. Why is that intended? And is there a possibility to manually delete the row key? Regards Sebastian

Re: get float column in cassandra mapreduce

2013-10-05 Thread Shahab Yunus
Couple of things which I could I think of. Other might have better ideas. 1- The exception is about encoding mismatch. Do you know what is your source files's encoding and what is your system's default? E.g. it can be ISO8859-1 in Windows, UTF-8 in Linux etc.and your file has something else. You

Re: get float column in cassandra mapreduce

2013-10-05 Thread Anseh Danesh
Hi.. thanks for your reply shahab.. I don't know what is source file encoding, I export the table in mysql as csv file and import it in cassandra. in both mysql and cassandra the temprature column type is float. I don't know how should set them to UTF8.. for your 2nd topic... no I'm not sure it is

Re: Deleting Row Key

2013-10-05 Thread Cem Cayiroglu
It will be deleted after a compaction. Sent from my iPhone On 05 Oct 2013, at 07:29, Sebastian Schmidt isib...@gmail.com wrote: Hi, per default, the key of a row is not deleted, if all columns were deleted. I tried to figure out why, but I didn't find an answer, except that it is

Re: Deleting Row Key

2013-10-05 Thread Sebastian Schmidt
Am 06.10.2013 00:00, schrieb Cem Cayiroglu: It will be deleted after a compaction. Sent from my iPhone On 05 Oct 2013, at 07:29, Sebastian Schmidt isib...@gmail.com wrote: Hi, per default, the key of a row is not deleted, if all columns were deleted. I tried to figure out why, but I

Re: Deleting Row Key

2013-10-05 Thread Shahab Yunus
Yes you can: http://hbase.apache.org/book/regions.arch.html#compaction http://hbase.apache.org/book/important_configurations.html (Managed Compaction section) Regards, Shahab On Sat, Oct 5, 2013 at 6:02 PM, Sebastian Schmidt isib...@gmail.com wrote: Am 06.10.2013 00:00, schrieb Cem

Re: Deleting Row Key

2013-10-05 Thread Shahab Yunus
Sorry, I replied to the wrong list with HBase info. Here is Cassandra's link about invoking compaction manually through nodetool http://www.datastax.com/documentation/cassandra/1.2/webhelp/index.html#cassandra/tools/toolsNodetool_r.html?pagename=docsversion=1.2file=references/nodetool Regards,