Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create keyspace robson with replication = {
- ‘class’:’SimpleStrategy’,
- ‘replication_factor’: 2
- };
- use robson;
- create table Jorge(
- id uuid,
- nome varchar,
- data timestamp,
- preco double,
- ips list<inet>,
- primary key(id));
- insert into jorge(id, nome, data, preco, ips) values (Now(), 'Irineu Silva','2012-12-12',234.56,['127.0.1.1','127.1.1.1']);
- insert into jorge(id, nome, data, preco, ips) values (Now(), ‘Augustinho Carrara’,’2011-11-11’,8001.6987,[‘192.168.0.1’]);
- insert into jorge (id) values (Now());
- insert into jorge(id, nome, data) values (Now(), ‘Santana’,’2017-11-23 18:30:00’);
- create table Jao(
- id int,
- nome varchar,
- vivo boolean,
- contatos map<varchar, bigint>,
- primary key(id));
- insert into Jao (id, nome, vivo, contatos) values (1, ‘Clayton’,true,{‘Will’:33667070});
- insert into Jao (id,nome,vivo) values(1,’Tristao’,false) IF NOT EXISTS;
- --insert into Jao(id,nome) values (2,’VAI SUMIR ISSO DAQUI’) USING TTL 30;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement