Maybe you could integrate with Hadoop. On Mon, Aug 9, 2010 at 1:15 PM, sonia gehlot <sonia.geh...@gmail.com> wrote:
> 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 >>> >> >> > -- Regards Peng Guo