导出spark-sql结果

 

./bin/spark-sql -e "select count(1),count(distinct ip),substr(url,0,44) from tongji_log where domain ='xxx.com' and ds ='20170303' group by substr(url,0,44);" -v >> testtongji.log