PageRenderTime 16ms CodeModel.GetById 11ms app.highlight 1ms RepoModel.GetById 1ms app.codeStats 1ms

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