How to export Hive2

This article mainly introduces how to export Hive2, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

I. Export

1. Import to the local file system

Hive > show tables;OKlocationtemperaturewindspeedTime taken: 0.679 seconds, Fetched: 3 row (s) hive > insert overwrite local directory'/ home/hadoop/data' > select * from location;. [hadoop@hftclclw0001 data] $pwd/home/hadoop/data [hadoop@hftclclw0001 data] $lltotal 4Murray RWLV-1 hadoop root 113 Oct 27 09:05 00000020 [hadoop@hftclclw0001 data] $cat 0000000Adelaide6769Clean_Air900Faraday6564Grytviken5436Halley7526Neumayer708Rothera6768Signy6045

two。 Export to HDFS

Hive > show tables;OKlocationtemperaturewindspeedTime taken: 0.679 seconds, Fetched: 3 row (s) hive > insert overwrite directory'/ user/user01/data' > select * from location;. Thank you for reading this article carefully. I hope the article "how to Export Hive2" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support and pay attention to the industry information channel. More related knowledge is waiting for you to learn!