How does 'sort' interact with record batches? #15711
Unanswered
daphnenhuch-at
asked this question in
Q&A
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
I have a table with 10,000 records in it ranging from primary key "0000" to "9999". I'm doing the following query
My goal is that I will have a fully sorted file sorted by primary key where each fileRowNumber is the index of that row in the file. However, I'm getting the result where the record batches are sorted, but not with respect to each other. The table returned here is
user primary key 8192 through 9999 followed then by 0 through 8191. The fileRowNumbers are correct in that they actually match what would have been the fully sorted user primary key order. So why are the record batches not returned sorted with respect to each other?
Beta Was this translation helpful? Give feedback.
All reactions