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

 1SELECT 1 IN (1, 2, 3),
 2       4 IN (1, 2, 3),
 3       array(1,2,3) IN (array(1,2,3)),
 4       "bee" IN("aee", "bee", "cee", 1),
 5       "dee" IN("aee", "bee", "cee"),
 6       1 = 1 IN(true, false),
 7       true IN (true, false) = true,
 8       1 IN (1, 2, 3) OR false IN(false),
 9       NULL IN (1, 2, 3),
10       4 IN (1, 2, 3, NULL),
11       (1+3) IN (5, 6, (1+2) + 1) FROM src LIMIT 1;
12
13SELECT key FROM src WHERE key IN ("238", 86);