使用
ALTER TABLE ruiwang.test_aggregate MODIFY COLUMN age BIGINT KEY AFTER user_id FROM example_rollup_cost_index;
ALTER TABLE ruiwang.test_aggregate ORDER BY (user_id,age,date,max_dwell_time,cost) FROM example_rollup_cost_index;
两个命令后表无变化
使用
ALTER TABLE ruiwang.test_aggregate MODIFY COLUMN age BIGINT KEY AFTER user_id FROM example_rollup_cost_index;
ALTER TABLE ruiwang.test_aggregate ORDER BY (user_id,age,date,max_dwell_time,cost) FROM example_rollup_cost_index;
两个命令后表无变化