beeline -n username -p password \ -u jdbc:hive2://hadoop01:10000/cdm \ --verbose=true \ --showHeader=false \ --outputformat=csv2 \ --color=true \ -e "select * from ${database}.${tablename}" > ${tableName}.csv