Both DISTINCT and GROUP cause the result to be ordered. Why does using a merge cause this to fail?
Specifically, Zebra then thinks the results aren't sorted, when they are. I think the problem is that Zebra actually writes the sort info into the table schema on disk but that with DISTINCT and GROUP it isn't written. I'll have to see what other operations will result in a sorted table and then implement support for them as well. I have a DISTINCT operation which can then be merge joined do another table which is already sorted. Both are rather large files…… like 500GB … so avoiding a resort would be a good thing :) Kevin -- Founder/CEO Spinn3r.com Location: *San Francisco, CA* Skype: *burtonator* Skype-in: *(415) 871-0687*
