Hey,
Data in Hive tables reside on HDFS, Hive is only a metadata layer that helps you access the HDFS data in for of tables and rows.
So you don’t transfer data from Hive to HDFS, as the data is already on HDFS.
To know more, It's recommended to join Big Data Hadoop Course today.