sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bejoy ks <bejo...@gmail.com>
Subject Re: Sqoop import into a Hive table with 2 columns as partition keys
Date Thu, 13 Mar 2014 04:19:07 GMT
AFAIK. Sqoop 1x imports supports hive single column partitions.

If it is multi column partitions you might have to take a two hop approach
1. Load the data into a single/non partitioned hive tabe
2. From the above staging table load to the final one.


On Tue, Mar 11, 2014 at 7:23 AM, Richa Sharma
<mailtorichasharma@gmail.com>wrote:

> Hi,
>
> I am trying to run sqoop import into a Hive table partitioned on 2 columns
> (col1 string, col2 string).
>
> I looked at the documentation for both --hive-import and --hcatalog and
> could not find any such option.
>
> It works successfully when table is partitioned on 1 column but not when i
> increase number of partition columns.
>
> Has anyone tried it and knows how to achieve it ?
>
> Thanks,
> Richa
>



-- 
Regards
       Bejoy

Mime
View raw message