CREATE TABLE layer (
    layer_name text,
    layer_position text,
    PRIMARY KEY (layer_name, layer_position)
) WITH CLUSTERING ORDER BY (layer_position DESC)

$select = new CassandraSimpleStatement(<<<EOD
                        select * from layer ORDER BY layer_position DESC
EOD
                      );

$result = $session->execute($select);

PRIMARY KEY (layer_name, layer_position)
) WITH CLUSTERING ORDER BY (layer_position DESC)

SELECT * FROM layer WHERE layer_name = 'layer1';

CREATE TABLE layer_by_state_id (
    layer_name text,
    layer_position text,
    state_id text,
    PRIMARY KEY (state_id, layer_position, layer_name)
) WITH CLUSTERING ORDER BY (layer_position DESC, layer_name ASC);

SELECT * FROM layer WHERE state_id='thx1138';