/tags/release-0.0.0-rc0/hive/external/ql/src/test/queries/clientnegative/semijoin4.q

# · text · 3 lines · 2 code · 1 blank · 0 comment · 0 complexity · 72ee1167d63f646ec2b63a4abc762ab5 MD5 · raw file 

    

  1. -- rhs table is a view and reference the view in where clause
    2. 

  2. select a.value from src a left semi join (select key , value from src where key > 100) b on a.key = b.key where b.value = 'val_108' ;
    3.