| set hive.vectorized.execution.reduce.enabled=true; | |
| CREATE EXTERNAL TABLE orderdatatest_ext (col1 int, col2 int); | |
| INSERT INTO orderdatatest_ext VALUES | |
| (1,1), | |
| (1,2), | |
| (1,3), | |
| (1,4), | |
| (1,5), | |
| (1,6), | |
| (1,7), | |
| (1,8), | |
| (1,9), | |
| (1,10); | |
| select * from orderdatatest_ext order by col1 limit 5,100 |