This example creates join index t_cppi with a character partitioning expression. The data type for column j in this example is CHARACTER and the type of column k is INTEGER.
CREATE JOIN INDEX t_cppi AS SELECT j, k FROM t1 PRIMARY INDEX(j) PARTITION BY (CASE_N(j BETWEEN 'aaaa' AND 'bbbb', j BETWEEN 'cccc' AND 'dddd'), RANGE_N(k BETWEEN 1 AND 10 EACH 1));