Re: LEFT JOIN and WHERE CLAUSE - How to handle

How about splitting your txn data into two parts, one for the tx that has currency info (just use join) and the other part for the tx that can't find currency info then use a union all operator combines two parts tx, as below: SELECT ROW_NUM,CCY_CD,TXN_DT,CNTRY_DESC FROM CURRENCY JOIN TXN ON (CU

Hive on Spark

Hi All, Has anybody used hive on spark in your production environment? How does it's the stability and performance compared with spark sql? Hope anybody can share your experience. Thanks in advance!