THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
We plan to limit the scope with following assumption/limitations
Subqueries could only be top level expressions in select i.e. subqueries in complex expressions, aggregates, UDFs etc will not be supported for now. e.g. following queries will not run on HIVE
Code Block language sql -- subquery in non-simple expression SELECT 1 + (SELECT SUM(ship_charge) FROM orders), customer.customer_num FROM customer -- subquery in CASE SELECT CASE WHEN (select count(*) from store_sales where ss_quantity between 1 and 20) > 409437 THEN (select avg(ss_ext_list_price) from store_sales where ss_quantity between 1 and 20) ELSE (select avg(ss_net_paid_inc_tax) from store_sales where ss_quantity between 1 and 20) end bucket1 FROM reason WHERE r_reason_sk = 1
...