PageRenderTime 41ms CodeModel.GetById 18ms RepoModel.GetById 0ms app.codeStats 0ms

/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
  1. select INPUT__FILE__NAME, key, BLOCK__OFFSET__INSIDE__FILE from src;
  2. select key, count(INPUT__FILE__NAME) from src group by key order by key;
  3. select INPUT__FILE__NAME, key, collect_set(BLOCK__OFFSET__INSIDE__FILE) from src group by INPUT__FILE__NAME, key order by key;
  4. select * from src where BLOCK__OFFSET__INSIDE__FILE > 12000 order by key;
  5. select * from src where BLOCK__OFFSET__INSIDE__FILE > 5800 order by key;
  6. CREATE TABLE src_index_test_rc (key int, value string) STORED AS RCFILE;
  7. set hive.io.rcfile.record.buffer.size = 1024;
  8. INSERT OVERWRITE TABLE src_index_test_rc SELECT * FROM src;
  9. select INPUT__FILE__NAME, key, BLOCK__OFFSET__INSIDE__FILE from src_index_test_rc order by key;
  10. DROP TABLE src_index_test_rc;
  11. DROP INDEX src_index on src_index_test_rc;