sql - 将 SAS SQL 转换为 Hive SQL

Question

我必须将 SAS SQL 转换为 hive sql 请帮助。下面是SAS代码。

proc sql;
    create table master as
        select acct_nbr , clnt_nbr, card_typ from myquery.int_card
        order by 1,2 ;
quit;

proc sql;
    create table clnt_base as 
        select clnt_nbr ,
        (case when clnt_nbr in 
             (select clnt_nbr from master where crd_type in ('198',199')) then 1 else 0 end)
              as ultima 
         order by 1;
quit;

请帮忙！！

标签： sqlsashiveql