/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
1EXPLAIN 2SELECT * FROM srcpart; 3 4EXPLAIN 5SELECT `..` FROM srcpart; 6 7EXPLAIN 8SELECT srcpart.`..` FROM srcpart; 9 10EXPLAIN 11SELECT `..` FROM srcpart a JOIN srcpart b 12ON a.key = b.key AND a.value = b.value; 13 14EXPLAIN 15SELECT b.`..` FROM srcpart a JOIN srcpart b 16ON a.key = b.key AND a.hr = b.hr AND a.ds = b.ds AND a.key = 103 17ORDER BY ds, hr; 18 19SELECT b.`..` FROM srcpart a JOIN srcpart b 20ON a.key = b.key AND a.hr = b.hr AND a.ds = b.ds AND a.key = 103 21ORDER BY ds, hr; 22 23EXPLAIN 24SELECT `.e.` FROM srcpart; 25 26EXPLAIN 27SELECT `d.*` FROM srcpart; 28 29EXPLAIN 30SELECT `(ds)?+.+` FROM srcpart; 31 32EXPLAIN 33SELECT `(ds|hr)?+.+` FROM srcpart ORDER BY key, value LIMIT 10; 34 35SELECT `(ds|hr)?+.+` FROM srcpart ORDER BY key, value LIMIT 10;