ql/src/test/queries/clientpositive/select_transform_hint.q

--! qt:dataset:src
-- SORT_QUERY_RESULTS

set hive.entity.capture.transform=true;

EXPLAIN
SELECT /*+MAPJOIN(a)*/ 
TRANSFORM(a.key, a.value) USING 'cat' AS (tkey, tvalue)
FROM src a join src b
on a.key = b.key;


SELECT /*+MAPJOIN(a)*/ 
TRANSFORM(a.key, a.value) USING 'cat' AS (tkey, tvalue)
FROM src a join src b
on a.key = b.key;


EXPLAIN
SELECT /*+STREAMTABLE(a)*/ 
TRANSFORM(a.key, a.value) USING 'cat' AS (tkey, tvalue)
FROM src a join src b
on a.key = b.key;


SELECT /*+STREAMTABLE(a)*/ 
TRANSFORM(a.key, a.value) USING 'cat' AS (tkey, tvalue)
FROM src a join src b
on a.key = b.key;