Moving data from HDFS to Apache Hive

In CDP Private Cloud Base, 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 CDP Private Cloud Base, you create a single Sqoop import command that imports data from a relational database into HDFS.
Convert the data to ORC format.
In CDP Private Cloud Base, 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 CDP Private Cloud Base, updating imported tables involves importing incremental changes made to the original table using Sqoop and then merging changes with the tables imported into Hive.