/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;