create class if not exists /test/mprepare ( v_varchar varchar, v_text text, v_int int, v_bigint bigint, v_smalldouble double, v_double double, v_float float, v_bool bool, v_timestamp timestamp, v_blob blob, indexes(v_varchar, v_text, v_int, v_bigint, v_double, v_float, v_smalldouble, v_bool, v_timestamp), keys(v_varchar, v_text) ) with partition=v_int ; delete from /test/mprepare with version ;