HDFS to Apache Hive data migration

In Cloudera Base on premises, you can import data from diverse data sources into HDFS, perform ETL processes, and then query the data in Apache Hive.

Ingest the data.
In Cloudera Base on premises, you create a single Sqoop import command that imports data from a relational database into HDFS.
Convert the data to ORC format.
In Cloudera Base on premises, to use Hive to query data in HDFS, you apply a schema to the data and then store data in ORC format.
Incrementally update the imported data.
In Cloudera Base on premises, updating imported tables involves importing incremental changes made to the original table using Apache Sqoop and then merging changes with the tables imported into Apache Hive.