/tags/release-0.0.0-rc0/hive/external/ql/src/test/queries/clientpositive/udf_in.q

# · text · 13 lines · 12 code · 1 blank · 0 comment · 0 complexity · b17ede95bb104d85d3f09f7fd35549b3 MD5 · raw file 

    

  1. SELECT 1 IN (1, 2, 3),
    2. 

  2.        4 IN (1, 2, 3),
    3. 

  3.        array(1,2,3) IN (array(1,2,3)),
    4. 

  4.        "bee" IN("aee", "bee", "cee", 1),
    5. 

  5.        "dee" IN("aee", "bee", "cee"),
    6. 

  6.        1 = 1 IN(true, false),
    7. 

  7.        true IN (true, false) = true,
    8. 

  8.        1 IN (1, 2, 3) OR false IN(false),
    9. 

  9.        NULL IN (1, 2, 3),
    10. 

  10.        4 IN (1, 2, 3, NULL),
    11. 

  11.        (1+3) IN (5, 6, (1+2) + 1) FROM src LIMIT 1;
    12. 

  12. 

  13. SELECT key FROM src WHERE key IN ("238", 86);
    14.