Add distributed execution limitation

**Is your feature request related to a problem? Please describe.**
Current implementation has a few limitations, for example, for queries with ORDER doesn't support distribution, need to document it publically and record in the roadmap. 

**Describe the solution you'd like**
N/A

**Describe alternatives you've considered**
N/A

**Additional context**
N/A
