| |
| dfs ${system:test.dfs.mkdir} -p file:///${system:test.tmp.dir}/sfs; |
| dfs -cp ${system:hive.root}/data/files/table1_delim.txt file:///${system:test.tmp.dir}/sfs/f1.txt; |
| dfs -cp ${system:hive.root}/data/files/table1_delim.txt file:///${system:test.tmp.dir}/sfs/f2.txt; |
| |
| create external table t1 (a string,b string,c string) location 'file://${system:test.tmp.dir}/sfs'; |
| |
| select * from t1; |
| |
| create external table t1s (a string,b string,c string) location 'sfs+file://${system:test.tmp.dir}/sfs/f1.txt/#SINGLEFILE#'; |
| |
| select * from t1s; |
| |
| desc formatted t1s; |
| |
| select count(1) from t1; |
| select count(1) from t1s; |