testdata/workloads/functional-query/queries/QueryTest/views.test

====
---- QUERY
# Basic test on querying a view.
select count(int_col), count(bigint_col) from functional.alltypes_view
---- RESULTS
7300,7300
---- TYPES
BIGINT, BIGINT
====
---- QUERY
# Using views in union.
select bigint_col, string_col from functional.alltypes_view order by id limit 2
union all (select * from functional.complex_view) order by 1, 2 limit 10
---- RESULTS
0,'0'
2,'0'
2,'1'
10,'1'
---- TYPES
BIGINT, STRING
====
---- QUERY
# Using a view in subquery.
select t.* from (select * from functional.complex_view) t
order by t.abc, t.xyz desc limit 10;
---- RESULTS
2,'1'
2,'0'
---- TYPES
BIGINT, STRING
====
---- QUERY
# Using multiple views in a join.
select count(*) from functional.alltypes_view t1, functional.alltypes_view_sub t2
where t1.id < 10 and t2.x < 5 and t1.id = t2.x
---- RESULTS
3650
---- TYPES
BIGINT
====
---- QUERY
# Self-join of a view to make sure the join op is properly set
# in the cloned view instances.
select count(*) from functional.alltypes_view t1
left outer join functional.alltypes_view t2 on t1.id+10 = t2.id
full outer join functional.alltypes_view t3 on t2.id+20 = t3.id
---- RESULTS
7330
---- TYPES
BIGINT
====
---- QUERY
# Test that Impala can handle incorrect column metadata created by Hive (IMPALA-994).
select * from functional.alltypes_hive_view where id = 0
---- RESULTS
0,true,0,0,0,0,0,0,'01/01/09','0',2009-01-01 00:00:00,2009,1
---- TYPES
INT, BOOLEAN, TINYINT, SMALLINT, INT, BIGINT, FLOAT, DOUBLE, STRING, STRING, TIMESTAMP, INT, INT
====
---- QUERY
# Regression test for IMPALA-1010. This currently produces a bushy plan.
select STRAIGHT_JOIN c.id, d.date_string_col from
  alltypessmall d join [SHUFFLE] (select a.id as id, b.date_string_col from
    alltypessmall a join [SHUFFLE] alltypessmall b on (a.id = b.id)) c on c.id = d.id
  order by c.id limit 2
---- RESULTS
0,'01/01/09'
1,'01/01/09'
---- TYPES
int, STRING
====