SELECT m.*,n.pricecount
FROM(SELECT*FROM table_sample a WHERE d='2018-08-31'LIMIT100) n
LATERAL VIEW json_tuple(pricecount,'paymentType','complete') m AS f1,f2;
SELECT j.nf,p.*FROM(SELECT m.*,n.pricecount
FROM(SELECT*FROM ods_htl_htlinfogoverndb.buyout_appraise a WHERE d ='${zdt.format("yyyy-MM-dd")}'LIMIT100) n
LATERAL VIEW json_tuple(pricecount,'paymentType','complete') m AS f1,f2) p
LATERAL