create class if not exists /test/mpartition ( mv_varchar varchar, v_text text, v_int int, v_bigint bigint, v_smalldouble double, v_double double, v_float float, v_bool bool, indexes(mv_varchar, v_text, v_int, v_bigint, v_double, v_float, v_smalldouble, v_bool), keys(mv_varchar, v_text, v_int) ) with partition=(mv_varchar,v_int), onconflict=(v_bigint incr), cache=6000 ; delete from /test/mpartition with version ;