Moving data from databases to Apache Hive
You can use Sqoop to import data from a relational database into for use with Hive. You can import the data directly to Hive. Assuming the Sqoop client service is available in your cluster, you can issue import and export commands from the command line.