Advertisement
Guest User

Untitled

a guest
Nov 27th, 2014
155
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.24 KB | None | 0 0
  1. 1.)
  2. CREATE KEYSPACE soupesKeyspace WITH placement_strategy = 'SimpleStrategy' AND strategy_options={replication_factor:2};
  3.  
  4. 2.)
  5. SHOW keyspaces;
  6.  
  7. 3.)
  8. UPDATE KEYSPACE soupesKeyspace WITH strategy_options= {replication_factor:2};
  9.  
  10. 4.)
  11. use soupesKeyspace;
  12. 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} ];
  13.  
  14. 5.)
  15. SET Soupes['scampagne']['Nom']='Soupe traditionnelle de campagne';
  16. SET Soupes['scampagne']['Marque']='Knorr';
  17. SET Soupes['scampagne']['Saveur']='Champignon';
  18. SET Soupes['scampagne']['Origine']='Belgique';
  19.  
  20. 6.)
  21. SET Soupes['stomates']['Nom']='Soupe tomates';
  22. SET Soupes['stomates']['Saveur']='Tomates';
  23.  
  24. 7.)
  25. LIST Soupes;
  26.  
  27. 8.)
  28. DEL Soupes['scampagne'];
  29.  
  30. 9.)
  31. GET Soupes['stomates'];
  32.  
  33. 10.)
  34. GET Soupes['stomates']['Saveur'];
  35.  
  36. SQLSH
  37.  
  38. 1.)
  39. CREATE KEYSPACE eBar WITH REPLICATION= { 'class' : 'SimpleStrategy','replication_factor' : 1 };
  40.  
  41. 2.)
  42. use eBar;
  43. CREATE TABLE Bieres(nom varchar, brasserie varchar, type varchar, prix double, couleur varchar, PRIMARY KEY(nom));
  44.  
  45. 3.)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement