#Call DESCRIBE
 out=$(hive client -S -e "use $HIVE_SCHEMA; DESCRIBE EXTENDED $table")

 #Get location for example
 table_location=$(echo "${out}" | egrep -o 'location:[^,]+' | sed 's/location://')
 echo Table location: $table_location
 #removing the path
 #hdfs dfs -rm -r -skipTrash $table_location   #need to remove this comment