Hi, > Can you send your examples again? > > What you sent earlier is showed as ³1² < ³9² and ³11² < ³9² > x > Œ9¹;
That’s my Outlook client eating up quotes and occasionally rewriting what I write into unreadable junk. They are 1, 9, and 11 in single quotes, to be compared as strings, which puts them in order as [1, 11, 9] instead of the order they truly belong in as numbers. Going to String.compareTo() with them would be a disaster for PPD handling, except that only happens if you misuse the SARGs API from a non-Hive tool for Integers. But it looks like Timestamp/Date might be different in that. In either case, the 1.3.0 WARN logs (and the correct answer) is the expected result. >> https://issues.apache.org/jira/browse/HIVE-10286 Cheers, Gopal
