Practice


cqlsh> CREATE KEYSPACE rapcas
   ... WITH replication = {'class': 'SimpleStrategy', 'replication_factor': 1};
cqlsh> USE rapcas ;

cqlsh:rapcas> CREATE TABLE dayquote1 (
          ... exchange varchar ,
          ... sector varchar ,
          ... symbol varchar ,
          ... quote_date timestamp ,
          ... close decimal,
          ... high decimal ,
          ... low decimal ,
          ... open decimal,
          ... volumn bigint ,
          ... PRIMARY KEY (symbol)
          ... );

cqlsh:rapcas> CREATE TABLE dayquote2 (
          ... exchange varchar ,
          ... sector varchar ,
          ... symbol varchar ,
          ... quote_date timestamp ,
          ... close decimal,
          ... high decimal ,
          ... low decimal ,
          ... open decimal,
          ... volumn bigint ,
          ... PRIMARY KEY (symbol, quote_date)
          ... );