1 Requirement
Currently, Users can specify sort column in table properties when create
table. And when load data, users can also specify sort scope in load
options.
In order to improve the ease of use for users, it will be better to specify
the sort related parameters all in create table comm
The two options both prefer to make all the sortscope in all segments (loads)
same.
Since carbondata supports different sortscope in different segment (load), I
think there should be a third option.
Option 3: The sortscope in load data command is in higher priority than that
specified in create