10class.mql 641 B

1234567891011121314151617181920212223242526
  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. -- cassandra整体性能下降时,可能需要更长时间
  18. /**
  19. sleep(5s)
  20. **/
  21. ;