There is no guarantee of results order in SQL without an order by. With columnstore and multiple pms / multi threading results may come back in any order.
get it,really appreciate your help.
no problem, happy to help.
I want to know,which mcs version can be storaged by hadoop?
This is something that was supported by infinidb and the code still exists but is not something we are emphasizing or testing internally as in some ways we see ourselves as the easier to use alternative. Is this just curiosity or do you have a use case in mind?
Thank you for your patience. 
em,I am a Big data ecosphere devops，so I always tend to use hadoop storage.
Now,in my production,I set up 2um and 2pms with Separate storage. I have made a backup everyday to my mcs environment.
except shared storage(example nfs),does mcs support hot Active-Standby mode ?(Waste storage and machine) if so, how to do it?
what I want to know is except shared storage mode,is there others mode? just like presto ,it can use haooop storage ,mysql storage and so on.