Question: how to export data from hive table to hdfs?
Answer: create new table like output_table in hive. insert into table table name select * from table name. go to hive warehouse in HDFS. find table name you have created in hive.