10class.mql 457 B

1234567891011121314151617181920
  1. create class if not exists /test/mpartition (
  2. mv_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(mv_varchar, v_text, v_int, v_bigint, v_double, v_float, v_smalldouble, v_bool),
  11. keys(mv_varchar, v_text, v_int)
  12. ) with partition=(mv_varchar,v_int), onconflict=(v_bigint incr), cache=6000
  13. ;
  14. delete from /test/mpartition with version
  15. ;