Hi, You can't yet, see https://issues.apache.org/jira/browse/CASSANDRA-10857Note that secondary indexes don't scale. Be aware of their limitations.If you want to change the data model of a CF, a Spark job can do the trick. Best, Romain
Le Mardi 7 juin 2016 10h51, "Lu, Boying" <boying...@emc.com> a écrit : #yiv3185006454 #yiv3185006454 -- filtered {font-family:SimSun;panose-1:2 1 6 0 3 1 1 1 1 1;}#yiv3185006454 filtered {font-family:SimSun;panose-1:2 1 6 0 3 1 1 1 1 1;}#yiv3185006454 filtered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}#yiv3185006454 filtered {font-family:SimSun;panose-1:2 1 6 0 3 1 1 1 1 1;}#yiv3185006454 p.yiv3185006454MsoNormal, #yiv3185006454 li.yiv3185006454MsoNormal, #yiv3185006454 div.yiv3185006454MsoNormal {margin:0cm;margin-bottom:.0001pt;font-size:11.0pt;}#yiv3185006454 a:link, #yiv3185006454 span.yiv3185006454MsoHyperlink {color:blue;text-decoration:underline;}#yiv3185006454 a:visited, #yiv3185006454 span.yiv3185006454MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv3185006454 span.yiv3185006454EmailStyle17 {color:windowtext;}#yiv3185006454 .yiv3185006454MsoChpDefault {}#yiv3185006454 filtered {margin:72.0pt 90.0pt 72.0pt 90.0pt;}#yiv3185006454 div.yiv3185006454WordSection1 {}#yiv3185006454 Hi, All, Since the Astyanax client has been EOL, we are considering to migrate to Datastax java client in our product. One thing I notice is that the CFs created by Astyanax have ‘compact storage’ attribute which prevent us from using some new features provided by CQL such as secondary index. Does anyone know how to remove this attribute? “ALTER TABLE” seems doesn’t work according to the CQL document. Thanks Boying