Hi Guys, Thanks for sharing your experiences and valuable links.... these are really helpful.
But I want to do ETL and then wanted to load data in Cassandra. I have link 10-15 various source system, presently daily ETL jobs runs load data in our database which is Netezza. How can I do this in Cassandra, like what if my target data base is source are the same (MySQL, Oracle, Netezza..etc)? -Sonia On Sat, Aug 7, 2010 at 7:46 PM, Zhong Li <z...@voxeo.com> wrote: > Yes, I use OrderPreservngPartitioner, the token considers > datacenter+ip+function+timestamp+recordId+... > > > On Aug 7, 2010, at 10:36 PM, Jonathan Ellis wrote: > > are you using OrderPreservingPartitioner then? >> >> On Sat, Aug 7, 2010 at 10:32 PM, Zhong Li <z...@voxeo.com> wrote: >> >>> Here is just my personal experiences. >>> >>> I recently use Cassandra to implement a system cross 5 datacenters. >>> Because >>> it is impossible to do it in SQL Database at low cost, Cassandra helps. >>> >>> Cassandra is all about indexing, there is no relationship naturally, you >>> have to use indexing to keep all relationships. This is fine, because you >>> can add new index when you want. >>> >>> The big pain is the token. Only one token you can choose for a node, all >>> system have to adopt same rule to create index. It is huge huge pain. >>> >>> If Cassandra can implement token at CF level, it is much nature and easy >>> for >>> us to implement a system. >>> >>> Best, >>> >>> Zhong >>> >>> >>> On Aug 6, 2010, at 9:23 PM, Peter Harrison wrote: >>> >>> On Sat, Aug 7, 2010 at 6:00 AM, sonia gehlot <sonia.geh...@gmail.com> >>>> wrote: >>>> >>>> Can you please help me how to move forward? How should I do all the >>>>> setup >>>>> for this? >>>>> >>>> >>>> My view is that Cassandra is fundamentally different from SQL databases. >>>> There >>>> may be artefact's which are superficially similar between the two >>>> systems, >>>> but >>>> I guess I'm thinking of a move to Cassandra like my move from dBase to >>>> Delphi; >>>> in other words there were concepts which modified how you write >>>> applications. >>>> >>>> Now, you can do something similar to a SQL database, but I don't think >>>> you >>>> would >>>> be leveraging the features of Cassandra. That said, I think there will >>>> be >>>> a new >>>> generation of abstraction tools that will make modeling easier. >>>> >>>> A perhaps more practical answer: there is no one to one mapping between >>>> SQL >>>> and Cassandra. >>>> >>> >>> >>> >> >> >> -- >> Jonathan Ellis >> Project Chair, Apache Cassandra >> co-founder of Riptano, the source for professional Cassandra support >> http://riptano.com >> > >
