====
---- CREATE_VIEW
# Create a view in Impala with plan hints. Hive should recognize the hints as
# comments and ignore them.
create view test as
select /* +straight_join */ a.* from functional.alltypestiny a
inner join /* +broadcast */ functional.alltypes b on a.id = b.id
inner join /* +shuffle */ functional.alltypessmall c on b.id = c.id;
---- CREATE_VIEW_RESULTS
IMPALA=SUCCESS
HIVE=SUCCESS
---- QUERY_IMPALA_VIEW_RESULTS
IMPALA=SUCCESS
HIVE=SUCCESS
====