Scenario: HCatalog table management on Hortonworks Data Platform
This scenario applies only to a Talend solution with Big Data.
This scenario describes a six-component Job that includes the common operations for
the HCatalog table management on Hortonworks Data Platform. Sub-sections in this
scenario covers DB operations including:
-
Creating a table to the database in HDFS;
-
Writing data to the HCatalog managed table;
-
Writing data to the partitioned table using tHCatalogLoad;
-
Reading data from the HCatalog managed table;
-
Outputting the data read from the table in HDFS.
Knowledge of Hive Data Definition Language and HCatalog Data Definition
Language is required. For further information about Hive Data Definition
Language, see https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL.
For further information about HCatalog Data Definition Language, see https://cwiki.apache.org/confluence/display/HCATALOG/Design+Document+-+Java+APIs+for+HCatalog+DDL+Commands.