/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
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
- select INPUT__FILE__NAME, key, BLOCK__OFFSET__INSIDE__FILE from src;
- select key, count(INPUT__FILE__NAME) from src group by key order by key;
- select INPUT__FILE__NAME, key, collect_set(BLOCK__OFFSET__INSIDE__FILE) from src group by INPUT__FILE__NAME, key order by key;
- select * from src where BLOCK__OFFSET__INSIDE__FILE > 12000 order by key;
- select * from src where BLOCK__OFFSET__INSIDE__FILE > 5800 order by key;
- CREATE TABLE src_index_test_rc (key int, value string) STORED AS RCFILE;
- set hive.io.rcfile.record.buffer.size = 1024;
- INSERT OVERWRITE TABLE src_index_test_rc SELECT * FROM src;
- select INPUT__FILE__NAME, key, BLOCK__OFFSET__INSIDE__FILE from src_index_test_rc order by key;
- DROP TABLE src_index_test_rc;
- DROP INDEX src_index on src_index_test_rc;