10class.mql 580 B

12345678910111213141516171819202122232425
  1. create class if not exists /test/sequence (
  2. v_varchar varchar,
  3. v_text text,
  4. v_int int,
  5. v_bigint bigint,
  6. v_smalldouble double,
  7. v_double double,
  8. v_float float,
  9. v_bool bool,
  10. indexes(v_varchar, v_text, v_int, v_bigint, v_double, v_float, v_smalldouble, v_bool),
  11. keys(v_varchar, v_text)
  12. ) with nickname='sequence' and key=seq
  13. ;
  14. delete from /test/sequence with version;
  15. -- cassandra内部的删除操作是异步的,需要等待一段时间,确保删除操作完成
  16. -- 否则后续插入的数据可能会被立即删除
  17. /**
  18. sleep(3s)
  19. **/
  20. ;