Re: Text searches and free form queries

[Andrey V. Panov]

Some one did search on Lucene, but for very fresh data they build search
index in memory so data become available for search without delays.

On 3 September 2012 22:25, Oleg Dulin  wrote:

> Dear Distinguished Colleagues:
>
>

Re: Java 7 support?

[Andrey V. Panov]

Are you using openJDK or Oracle JDK? I know java7 should be based on
openJDK since 7, but still not sure.

On 25 October 2012 05:42, Edward Capriolo  wrote:

> We have been using cassandra and java7 for months. No problems. A key
> concept of java is portable binaries. There are sometimes wrinkles with
> upgrades. If you hit one undo the upgrade and restart.
>

Re: building a new email-like inbox service with cassandra

[Andrey V. Panov]

I'm also interesting in your project and will be glad to follow you on
twitter if I can.

On 18 November 2011 00:37, Rustam Aliyev  wrote:

>  Hi Dotan,
>
> We have already built something similar and were planning to open source
> it. It will be available under http://www.elasticinbox.com/.
>
> We haven't followed exactly IBM's paper, we believe our Cassandra model
> design is more robust. It's written in Java and provides LMTP and REST
> interfaces. ElasticInbox also stores original messages outside of the
> Cassandra, in the blob store.
>
> Let me know if you are interested, I will need some time to do cleanup.
>
> Regards,
> Rustam.
>
> On 17/11/2011 14:17, Dotan N. wrote:
>
> Hi all,
> New to cassandra, i'm about to embrak on building a scalable user inbox
> service on top of cassandra.
> I've done the preliminary googling and got some more info on bluerunner
> (IBM's project on the subject),
> and now looking for more information in this specific topic.
>
>  If anyone can point me to researches/articles that would nudge me in the
> right direction i'd be tremendously thankful!
>
>  Thanks!
>
> --
> Dotan, @jondot 
>
>

Re: yet a couple more questions on composite columns

[Andrey V. Panov]

On 4 February 2012 06:21, Yiming Sun  wrote:

> I cannot have one composite column name with 3 components while another
> with 4 components?

 Just put 4 components and left last empty (if it is same type)?!

Another question I have is how flexible composite columns actually are.  If
> my data model has a CF containing US zip codes with the following composite
> columns:
>
> {OH:Spring Field} : 45503
> {OH:Columbus} : 43085
> {FL:Spring Field} : 32401
> {FL:Key West}  : 33040
>
> I know I can ask cassandra to "give me the zip codes of all cities in OH".
>  But can I ask it to "give me the zip codes of all cities named Spring
> Field" using this model?  Thanks.
>
No. You set first composite component at first.

Re: design that mimics twitter tweet search

[Andrey V. Panov]

Why you suppose they did search on Cassandra?

On 19 March 2012 00:16, Sasha Dolgy  wrote:

> yes -- but given i have two keywords, and want to find all tweets that
> have "cassandra" and "bestest" ... means, retrieving all columns + values
> in each row, iterating through both to see if tweet id's in one, exist in
> the other and finishing up with a consolidated list of tweet id's that only
> exist in both.  just seems clunky to me ... ?
>
>
> On Sun, Mar 18, 2012 at 4:12 PM, Benoit Perroud wrote:
>
>> The simpliest modeling you could have is using the keyword as key, a
>> timestamp/time UUID as column name and the tweetid as value
>>
>> -> cf['keyword']['timestamp'] = tweetid
>>
>> then you do a range query to get all tweetid sorted by time (you may
>> want them in reverse order) and you can limit to the number of tweets
>> displayed on the page.
>>
>> As some rows can become large, you could use key patitionning by
>> concatening for instance keyword and the month and year.
>>
>>
>> 2012/3/18 Sasha Dolgy :
>> > Hi All,
>> >
>> > With twitter, when I search for words like:  "cassandra is the
>> bestest", 4
>> > tweets will appear, including one i just did.  My understand that the
>> > internals of twitter work in that each word in a tweet is allocated,
>> > irrespective of the presence of a  # hash tag, and the tweet id is
>> assigned
>> > to a row for that word.  What is puzzling to me, and hopeful that some
>> smart
>> > people on here can shed some light on -- is how would this work with
>> > Cassandra?
>> >
>> > row [ cassandra ]: key -> tweetid  / timestamp
>> > row [ bestest ]: key -> tweetid / timestamp
>> >
>> > I had thought that I could simply pull a list of all column names from
>> each
>> > row (representing each word) and flag all occurrences (tweet id's) that
>> > exist in each row ... however, these rows would get quite long over
>> time.
>> >
>> > Am I missing an easier way to get a list of all "tweetid's" that exist
>> in
>> > multiple rows?
>> >
>> > --
>> > Sasha Dolgy
>> > sasha.do...@gmail.com
>>
>>
>>
>> --
>> sent from my Nokia 3210
>>
>
>
>
> --
> Sasha Dolgy
> sasha.do...@gmail.com
>

ahtung! apt-get update

[Andrey V. Panov]

Hi all.
I have ubuntu 10.10 and it offer me to update cassandra today. And I did it.
As I can see it update it to cassandra 0.8-beta1. Due to some jars missed
cassandra wan't start.
I already downgraded.


*Some details:*
root@asus:~# apt-cache policy cassandra
cassandra:
  Installed: 0.7.4
  Candidate: 0.8.0~beta1
  Version table:
 0.8.0~beta1 0
500 http://www.apache.org/dist/cassandra/debian/ unstable/main i386
Packages
 *** 0.7.4 0
500 http://debian.riptano.com/maverick/ maverick/main i386 Packages
100 /var/lib/dpkg/status

root@asus:~# apt-cache policy sun-java6-jdk
sun-java6-jdk:
  Installed: 6.24-1build0.10.10.1
  Candidate: 6.24-1build0.10.10.1
  Version table:
 *** 6.24-1build0.10.10.1 0
500 http://archive.canonical.com/ubuntu/ maverick/partner i386
Packages
100 /var/lib/dpkg/status

Re: New web client & future API

[Andrey V. Panov]

How to download it?
Your "Download war-file" open just blank page :(

On 14/06/2011, Markus Wiesenbacher | Codefreun.de  wrote:

> I just released an early version of my web client
> (http://www.codefreun.de/apollo) which is Thrift-based, and therefore I
> would like to know what the future is ...

Re: Tool to access Data in Cassandra

[Andrey V. Panov]

I did propotyping very small Cassandra data browser on top of Wicket and
Hector. Try it :) http://goo.gl/lozFo

On 23 September 2011 08:41, mcasandra  wrote:

> Are there any tools that let you scroll over data in Cassandra in html or
> UI?
>
> We are planning to encrypt data before storing in cassandra so I think we
> also need a tool where we can plug-in decryption logic. Does anyone if
> there
> is such a tool available that we can enhance?
>
> --
> View this message in context:
> http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Tool-to-access-Data-in-Cassandra-tp6822348p6822348.html
> Sent from the cassandra-u...@incubator.apache.org mailing list archive at
> Nabble.com.
>

ColumnFamily structure documentation

[Andrey V. Panov]

Hi all.
I want share one idea about how to documet Cassandra ColumnFamily structure.
I found software called "XMind" (it's free) and it allow easy draw schema
like this:

http://s57.radikal.ru/i158/1009/2a/a94e13a98e1e.jpg

I suppose it's important to have big picture about your data structure.
Hoping it will be useful for someone.

Re: Any ODBC/JDBC driver for Cassandra

[Andrey V. Panov]

But there few other drivers for connecting to cassandra.

On 1 October 2010 23:58, Weiping He  wrote:

> I new to Cassandra. I know it is not relational database and it is
> NoSQL. Is there any ODBC/JDBC driver for Cassandra?
>
>
>
>

Re: Which Java on Fedora? Sun's or GNU's?

[Andrey V. Panov]

Why not install Cassandra by hands? You should only download it and
unpack... Only thing left is boot script.

Re: Which Java on Fedora? Sun's or GNU's?

[Andrey V. Panov]

At the moment I'm use Sun JDK. But I think in some future I should migrate
to openJDK because it's more safety!? JRocket will be merged with HotSpot
and I think they already did it.

On 29 December 2010 14:21, AJ  wrote:

> I did install by hand with the previous release.  I suppose the RPM's are
> just a convenience, eh?  But, if the only real dependency is Java, then
> there isn't much need for an RPM right now?
>
> But, what do you think about other JREs?  Sun, JRocket, or Gnu?
>
> Thanks,
> aj
>
>
> On 12/28/2010 11:11 PM, Andrey V. Panov wrote:
>
>> Why not install Cassandra by hands? You should only download it and
>> unpack... Only thing left is boot script.
>>
>
>

Re: Cassandra + Thrift on RedHat Enterprise 5

[Andrey V. Panov]

Use Hector instead of pure Trift. https://github.com/rantav/hector/
And checkout wiki.

Re: online chat scenario

[Andrey V. Panov]

I never did it. But I suppose you can use "chatroom name" as key and store
messages & nicks as columns in JSON and timestamp as columnName.