Hi all, I'm almost sure I'm just tired and I am doing something stupid however I can't understand this problem. In one Super Column Family I have just 2 rows, called ALL and INCREMENTAL.
For some reason I sometimes need to duplicate a SuperColumn from the row ALL to the INCREMENTAL one ... very easy (cassandra 0.7.4, java, pelops) private static void mirrorizeEngineSuperColumn(Bytes superColumnId) { Mutator mutator = Pelops.createMutator(SocialContext.POOL_NAME_VALUE); Selector selector = Pelops.createSelector(SocialContext. POOL_NAME_VALUE); try { SuperColumn sc = selector.getSuperColumnFromRow(MotoreFamily, SocialColumn.MOTORE_ALL_ROW, superColumnId, ConsistencyLevel.QUORUM); LOG.debug("Column list size of supercolumn is " + sc. getColumnsSize()); mutator.writeSubColumns(MotoreFamily, SocialColumn. MOTORE_INCREMENTALI_ROW, superColumnId, sc.getColumns()); mutator.execute(ConsistencyLevel.QUORUM); } catch (NotFoundException nfe) { LOG.debug("Supercolumn not found ..."); } catch (Exception e) { LOG.error(e.toString()); } } When I print it the column list size is exact (3, 4 it depends on which supercolumn I'm working) but when I write them I find only one column of this column list ... here is the output produced (viewing with cassandra cli ...) -- compare the 3 super_column in the row INCREMENTAL and you'll see they're different from the one in the row ALL RowKey: ALL => (super_column=54b05120-552f-11e0-9d1f-020054554e01, (column=54fc9c60-552f-11e0-9d1f-020054554e01, value=00000003, timestamp=1300872296917000) (column=746595b0-553f-11e0-9e66-020054554e01, value=00000002, timestamp=1300879284037000) (column=6ec46ef0-5540-11e0-9e66-020054554e01, value=00000004, timestamp=1300879641811000) (column=99d911d0-5541-11e0-af7b-020054554e01, value=00000001, timestamp=1300880138869000)) => (super_column=97351e20-5545-11e0-9464-001d72d09363, (column=9763cf40-5545-11e0-9464-001d72d09363, value=00000004, timestamp=1300881876938000) (column=1e5b7a40-5549-11e0-8da1-020054554e01, value=00000005, timestamp=1300883402593000) (column=89f7c3e0-560b-11e0-a6ac-020054554e01, value=00000005, timestamp=1300966880883000)) => (super_column=cadf5940-55ed-11e0-9b97-020054554e01, (column=cb03aa20-55ed-11e0-9b97-020054554e01, value=00000004, timestamp=1300954178721000) (column=27092500-5609-11e0-b1f1-020054554e01, value=00000004, timestamp=1300965858839000) (column=5cdf88d0-560a-11e0-a6ac-020054554e01, value=00000005, timestamp=1300966438198000) (column=c6e34110-561c-11e0-9399-020054554e01, value=00000005, timestamp=1300974305208000)) => (super_column=309d66a0-5602-11e0-9cc8-020054554e01, (column=30d8e900-5602-11e0-9cc8-020054554e01, value=00000005, timestamp=1300963602927000) (column=8c8a4f40-5603-11e0-9cc8-020054554e01, value=00000005, timestamp=1300963728307000) (column=62246620-5606-11e0-9e06-020054554e01, value=00000005, timestamp=1300964702748000) (column=db951080-561b-11e0-8880-020054554e01, value=00000003, timestamp=1300973895462000)) => (super_column=e44f1860-560c-11e0-b696-020054554e01, (column=e5045ea0-560c-11e0-b696-020054554e01, value=00000005, timestamp=1300967480905000)) => (super_column=e53d7000-560c-11e0-b696-020054554e01, (column=e56395a0-560c-11e0-b696-020054554e01, value=00000005, timestamp=1300967620609000)) => (super_column=90ce8370-5615-11e0-b696-020054554e01, (column=9100de10-5615-11e0-b696-020054554e01, value=00000005, timestamp=1300971213814000) (column=a5171450-5615-11e0-b696-020054554e01, value=00000005, timestamp=1300971294115000) (column=9fb68390-5617-11e0-9ed9-020054554e01, value=00000002, timestamp=1300972093565000) (column=79889ed0-561a-11e0-bf27-020054554e01, value=00000002, timestamp=1300973301530000)) ------------------- RowKey: INCREMENTAL => (super_column=cadf5940-55ed-11e0-9b97-020054554e01, (column=c6e34110-561c-11e0-9399-020054554e01, value=00000005, timestamp=1300974305208000)) => (super_column=309d66a0-5602-11e0-9cc8-020054554e01, (column=db951080-561b-11e0-8880-020054554e01, value=00000003, timestamp=1300973895462000)) => (super_column=90ce8370-5615-11e0-b696-020054554e01, (column=9fb68390-5617-11e0-9ed9-020054554e01, value=00000002, timestamp=1300972093565000)) I think I'm getting crazy! TIA for any help Best regards Carlo