/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
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
- SELECT 1 IN (1, 2, 3),
- 4 IN (1, 2, 3),
- array(1,2,3) IN (array(1,2,3)),
- "bee" IN("aee", "bee", "cee", 1),
- "dee" IN("aee", "bee", "cee"),
- 1 = 1 IN(true, false),
- true IN (true, false) = true,
- 1 IN (1, 2, 3) OR false IN(false),
- NULL IN (1, 2, 3),
- 4 IN (1, 2, 3, NULL),
- (1+3) IN (5, 6, (1+2) + 1) FROM src LIMIT 1;
- SELECT key FROM src WHERE key IN ("238", 86);