>From FAQs Getting wrong result for the query with order by By default if you're making queries on the web client, a mode called "AcceptPartialResults" is enabled​, this is a protection mechanism that will only return part of the results to reduce server overhead. Honestly it might hurt the correctness of order by queries.
If you're seeking 100% correctness, after running the query you will find a notification: Note: Current results are partial, please click 'Show All' button to get all results. Click the "Show All" button to disable the "AcceptPartialResults" mode, and you'll get a right result. Notice "AcceptPartialResults" is only enabled by default at web client, you'll not meet such problems if you're using JDBC, ODBC or standard REST API. -- View this message in context: http://apache-kylin.74782.x6.nabble.com/TopN-Results-Differ-in-Hive-and-Kylin-tp3288p3292.html Sent from the Apache Kylin mailing list archive at Nabble.com.
