| set hive.mapred.mode=nonstrict; |
| set hive.compute.query.using.stats=false; |
| |
| DROP TABLE IF EXISTS symlink_text_input_format; |
| |
| EXPLAIN |
| CREATE TABLE symlink_text_input_format (key STRING, value STRING) STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.SymlinkTextInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat'; |
| |
| CREATE TABLE symlink_text_input_format (key STRING, value STRING) STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.SymlinkTextInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat'; |
| |
| dfs -cp ../../data/files/symlink1.txt ${system:test.local.warehouse.dir}/symlink_text_input_format/symlink1.txt; |
| dfs -cp ../../data/files/symlink2.txt ${system:test.local.warehouse.dir}/symlink_text_input_format/symlink2.txt; |
| |
| EXPLAIN SELECT * FROM symlink_text_input_format order by key, value; |
| |
| SELECT * FROM symlink_text_input_format order by key, value; |
| |
| EXPLAIN SELECT value FROM symlink_text_input_format order by value; |
| |
| SELECT value FROM symlink_text_input_format order by value; |
| |
| EXPLAIN SELECT count(1) FROM symlink_text_input_format; |
| |
| SELECT count(1) FROM symlink_text_input_format; |
| |
| DROP TABLE symlink_text_input_format; |
| |
| CREATE TABLE symlink_text_input_format (key STRING, value STRING) STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.SymlinkTextInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat'; |
| |
| dfs -cp ../../data/files/symlink-with-regex.txt ${system:test.local.warehouse.dir}/symlink_text_input_format/symlink-with-regex.txt; |
| dfs -cp ../../data/files/symlink2.txt ${system:test.local.warehouse.dir}/symlink_text_input_format/symlink2.txt; |
| |
| EXPLAIN SELECT * FROM symlink_text_input_format order by key, value; |
| |
| SELECT * FROM symlink_text_input_format order by key, value; |
| |
| EXPLAIN SELECT value FROM symlink_text_input_format order by value; |
| |
| SELECT value FROM symlink_text_input_format order by value; |
| |
| EXPLAIN SELECT count(1) FROM symlink_text_input_format; |
| |
| SELECT count(1) FROM symlink_text_input_format; |
| |
| SET hive.rework.mapredwork = true ; |
| SET mapred.max.split.size= 0 ; |
| SET mapred.min.split.size.per.node= 0 ; |
| SET mapred.min.split.size.per.rack= 0 ; |
| |
| SELECT count(1) FROM symlink_text_input_format; |
| |
| DROP TABLE symlink_text_input_format; |