blob: c58ebe147912c269f35d2da6d4c6aa08b9510df2 [file] [log] [blame]
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;