Scenario: creating a partitioned Hive table
This scenario illustrates how to use tHiveConnection,
tHiveCreateTable and tHiveLoad to create a partitioned Hive table and write data in
it.
Note that tHiveCreateTable and tHiveLoad are available only when you are using one of the
Talend
solutions with Big Data.
reading as follows:
|
1 2 3 4 5 6 7 8 9 10 11 |
1;Lyndon;Fillmore;21-05-2008;US 2;Ronald;McKinley;15-08-2008 3;Ulysses;Roosevelt;05-10-2008 4;Harry;Harrison;23-11-2007 5;Lyndon;Garfield;19-07-2007 6;James;Quincy;15-07-2008 7;Chester;Jackson;26-02-2008 8;Dwight;McKinley;16-07-2008 9;Jimmy;Johnson;23-12-2007 10;Herbert;Fillmore;03-04-2008 |
The information contains some employees’ names and the dates when they are registered
in a HR system. Since these employees work for the US subsidiary of the company, you
will create a US partition for this sample data.
Before starting to replicate this scenario, ensure that you have appropriate rights
and permissions to access the Hive database to be used.
Note that if you are using the Windows operating system, you have to create a
tmp folder at the root of the disk where the
Studio is installed.
Then proceed as follows: