Monthly Archives: August 2016
SQL LIKE operation in Cassandra, is possible in v3.4+
For a long time it has not been possible to do a SELECT * FROM table WHERE firstname like ‘t%’; in Cassandra like you could in eg.. MySQL or any other Relation Database for that matter. In Cassandra v3.4 this … Continue reading
Posted in Uncategorized
3 Comments
UDF/User Defined Functions in Cassandra 3.x
I was just playing around with Cassandra WRITETIME and thought it was somewhat difficult to figure out the date / timestamp of a number like this (microseconds since EPOC) 1470645914253000. So in my example it looked like this
1 2 3 4 5 6 7 8 9 10 11 |
cqlsh:bth> select id, writetime(dateofbirth) from bth.employee; id | writetime(dateofbirth) ----+------------------------ 1 | 1470645914253000 2 | 1470645977177000 7 | 1470948508799001 3 | 1470645977178000 (4 rows) cqlsh:bth> |
So … Continue reading