IMPALA-6123: Fix column order of a query test in test_inline_view_limit Currently a "select *" query in test_inline_view_limit fails during exhaustive testing because Impala returns columns from HBase tables in a different order (IMPALA-886) than the one expected. This fix ensures the column order is consistent by specifying the output columns in the right order in the select query.
Testing: Tested locally, with and without exhaustive exploration strategy. Change-Id: I11667872b8788a8b0040bf9252bf07b987b5d330 Reviewed-on: http://gerrit.cloudera.org:8080/8409 Reviewed-by: Lars Volker <[email protected]> Tested-by: Impala Public Jenkins Project: http://git-wip-us.apache.org/repos/asf/incubator-impala/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-impala/commit/f11181cb Tree: http://git-wip-us.apache.org/repos/asf/incubator-impala/tree/f11181cb Diff: http://git-wip-us.apache.org/repos/asf/incubator-impala/diff/f11181cb Branch: refs/heads/master Commit: f11181cbe5a7eaa3ae16bfb6a60ab9e200e37d39 Parents: 43ef80e Author: Bikramjeet Vig <[email protected]> Authored: Fri Oct 27 17:41:33 2017 -0700 Committer: Impala Public Jenkins <[email protected]> Committed: Sat Oct 28 06:29:38 2017 +0000 ---------------------------------------------------------------------- .../functional-query/queries/QueryTest/inline-view-limit.test | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/f11181cb/testdata/workloads/functional-query/queries/QueryTest/inline-view-limit.test ---------------------------------------------------------------------- diff --git a/testdata/workloads/functional-query/queries/QueryTest/inline-view-limit.test b/testdata/workloads/functional-query/queries/QueryTest/inline-view-limit.test index 93a7a58..2c3a72b 100644 --- a/testdata/workloads/functional-query/queries/QueryTest/inline-view-limit.test +++ b/testdata/workloads/functional-query/queries/QueryTest/inline-view-limit.test @@ -93,7 +93,9 @@ bigint ==== ---- QUERY # Test that limit is enforced by select node. -select * from (select * from alltypes order by id limit 20) t1 where int_col <100 limit 5 +select id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, float_col, +double_col, date_string_col, string_col, timestamp_col, year, month from +(select * from alltypes order by id limit 20) t1 where int_col < 100 limit 5 ---- RESULTS 0,true,0,0,0,0,0,0,'01/01/09','0',2009-01-01 00:00:00,2009,1 1,false,1,1,1,10,1.100000023841858,10.1,'01/01/09','1',2009-01-01 00:01:00,2009,1
