Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 1.)
- CREATE KEYSPACE soupesKeyspace WITH placement_strategy = 'SimpleStrategy' AND strategy_options={replication_factor:2};
- 2.)
- SHOW keyspaces;
- 3.)
- UPDATE KEYSPACE soupesKeyspace WITH strategy_options= {replication_factor:2};
- 4.)
- use soupesKeyspace;
- CREATE COLUMN FAMILY Soupes WITH comparator = UTF8Type AND key_validation_class =UTF8Type AND column_metadata= [ {column_name:Nom,validation_class:UTF8Type}{column_name:Marque,validation_class:UTF8Type}{column_name:Saveur,validation_class:UTF8Type}{column_name:Origine,validation_class:UTF8Type} ];
- 5.)
- SET Soupes['scampagne']['Nom']='Soupe traditionnelle de campagne';
- SET Soupes['scampagne']['Marque']='Knorr';
- SET Soupes['scampagne']['Saveur']='Champignon';
- SET Soupes['scampagne']['Origine']='Belgique';
- 6.)
- SET Soupes['stomates']['Nom']='Soupe tomates';
- SET Soupes['stomates']['Saveur']='Tomates';
- 7.)
- LIST Soupes;
- 8.)
- DEL Soupes['scampagne'];
- 9.)
- GET Soupes['stomates'];
- 10.)
- GET Soupes['stomates']['Saveur'];
- SQLSH
- 1.)
- CREATE KEYSPACE eBar WITH REPLICATION= { 'class' : 'SimpleStrategy','replication_factor' : 1 };
- 2.)
- use eBar;
- CREATE TABLE Bieres(nom varchar, brasserie varchar, type varchar, prix double, couleur varchar, PRIMARY KEY(nom));
- 3.)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement