I have to convert SAS SQL to hive sql Please help. Below is the SAS code. 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;   Please help!! ... View more

Hi I am writing hive query on my jupyter notebook. But, an error is coming. My code is : query = """" select addr_line1_txt as add1, addr_line2_txt as add2  from from int_client_addr """" path_file = 'çheck.csv' df = queryImpalaAndSave(path_file, delimeter,query) clear_output() displaydf()   error is empty dataerror.   Please help!!! ... View more