PageRenderTime 15ms 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/virtual_column.q

#
text | 19 lines | 11 code | 8 blank | 0 comment | 0 complexity | 56d46c896e74fc8e0c03df5d27f0ddca MD5 | raw file
 1select INPUT__FILE__NAME, key, BLOCK__OFFSET__INSIDE__FILE from src;
 2
 3select key, count(INPUT__FILE__NAME) from src group by key order by key;
 4
 5select INPUT__FILE__NAME, key, collect_set(BLOCK__OFFSET__INSIDE__FILE) from src group by INPUT__FILE__NAME, key order by key;
 6
 7select * from src where BLOCK__OFFSET__INSIDE__FILE > 12000 order by key;
 8
 9select * from src where BLOCK__OFFSET__INSIDE__FILE > 5800 order by key;
10
11
12CREATE TABLE src_index_test_rc (key int, value string) STORED AS RCFILE;
13
14set hive.io.rcfile.record.buffer.size = 1024;
15INSERT OVERWRITE TABLE src_index_test_rc SELECT * FROM src;
16select INPUT__FILE__NAME, key, BLOCK__OFFSET__INSIDE__FILE from src_index_test_rc order by key;
17
18DROP TABLE src_index_test_rc;
19DROP INDEX src_index on src_index_test_rc;