Sorry, but your message is too confusing - you say "reading dynamic columns in CQL" and "make the table schema less", but neither has any relevance to CQL! 1. CQL tables always have schemas. 2. All columns in CQL are statically declared (even maps/collections are statically declared columns.) Granted, it is a challenge for Thrift users to get used to the terminology of CQL, but it is required. If necessary, review some of the free online training videos for data modeling.
Unless your data model is very simply and does directly translate into CQL, you probably do need to bite the bullet and re-model your data to exploit the features of CQL rather than fight CQL trying to mimic Thrift per se. In any case, take another shot at framing the problem and then maybe people here can help you out. -- Jack Krupansky On Mon, Apr 11, 2016 at 10:39 AM, Anuj Wadehra <anujw_2...@yahoo.co.in> wrote: > Any comments or suggestions on this one? > > Thanks > Anuj > > Sent from Yahoo Mail on Android > <https://overview.mail.yahoo.com/mobile/?.src=Android> > > On Sun, 10 Apr, 2016 at 11:39 PM, Anuj Wadehra > <anujw_2...@yahoo.co.in> wrote: > Hi > > We are on 2.0.14 and Thrift. We are planning to migrate to CQL soon but > facing some challenges. > > We have a cf with a mix of statically defined columns and dynamic columns > (created at run time). For reading dynamic columns in CQL, > we have two options: > > 1. Drop all columns and make the table schema less. This way, we will get > a Cql row for each column defined for a row key--As mentioned here: > http://www.datastax.com/dev/blog/thrift-to-cql3 > > 2.Migrate entire data to a new non compact storage table and create > collections for dynamic columns in new table. > > In our case, we have observed that approach 2 causes 3 times slower > performance in Range scan queries used by Spark. This is not acceptable. > Cassandra 3 has optimized storage engine but we are not comfortable moving > to 3.x in production. > > Moreover, data migration to new table using Spark takes hours. > > Any suggestions for the two issues? > > > Thanks > Anuj > > > Sent from Yahoo Mail on Android > <https://overview.mail.yahoo.com/mobile/?.src=Android> > >