CREATE TABLE shapelets_predict DISTRIBUTE BY HASH(id) AS SELECT * FROM SupervisedShapeletClassifier ( ON shapelets_test AS time_series PARTITION BY id ORDER BY period ON shapelets_model AS shapelets DIMENSION ORDER BY shapelet_id, time_instant TimeInterval (1) ValueColumn ('stockprice') Accumulate ('stock_category') ) ORDER BY 1;