regex_col.q | searchcode

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

#
text | 35 lines | 25 code | 10 blank | 0 comment | 0 complexity | 97d21eb9b86d0cfee5c1dfc43afa2475 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0


EXPLAIN
SELECT * FROM srcpart;

EXPLAIN
SELECT `..` FROM srcpart;

EXPLAIN
SELECT srcpart.`..` FROM srcpart;

EXPLAIN
SELECT `..` FROM srcpart a JOIN srcpart b
ON a.key = b.key AND a.value = b.value;

EXPLAIN
SELECT b.`..` FROM srcpart a JOIN srcpart b
ON a.key = b.key AND a.hr = b.hr AND a.ds = b.ds AND a.key = 103
ORDER BY ds, hr;

SELECT b.`..` FROM srcpart a JOIN srcpart b
ON a.key = b.key AND a.hr = b.hr AND a.ds = b.ds AND a.key = 103
ORDER BY ds, hr;

EXPLAIN
SELECT `.e.` FROM srcpart;

EXPLAIN
SELECT `d.*` FROM srcpart;

EXPLAIN
SELECT `(ds)?+.+` FROM srcpart;

EXPLAIN
SELECT `(ds|hr)?+.+` FROM srcpart ORDER BY key, value LIMIT 10;

SELECT `(ds|hr)?+.+` FROM srcpart ORDER BY key, value LIMIT 10;