create table alias_test_01(a INT, b STRING) ;
                         create table alias_test_02(a INT, b STRING) ;
                         create table alias_test_03(a INT, b STRING) ;
                         set hive.groupby.position.alias = true;
                         set hive.strict.checks.cartesian.product = false;

                         explain
                         select * from
                         alias_test_01 alias01
                         left join
                         (
                         select 2017 as a, b from alias_test_02 group by 1, 2
                         ) alias02
                         on alias01.a = alias02.a
                         left join
                         alias_test_03 alias03
                         on alias01.a = alias03.a;