In this chapter, we covered how to exchange data between Hive and files using the LOAD, INSERT, IMPORT, and EXPORT keywords. Then, we introduced the different Hive ordering and sorting options. We also covered some commonly used tips using Hive functions. Finally, we provided an overview of row-level transactions that are newly supported since Hive 0.13.0. After going through this chapter, we should be able to import or export data to Hive. We should be experienced in using different types of ordering and sorting keywords, Hive functions, and transactions.

In the next chapter, we'll look at the different ways of carrying out data aggregations and sampling in Hive.