sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Suresh Kumar Sethuramaswamy <rock...@gmail.com>
Subject Re: Sqoop import to hive with additional column
Date Mon, 04 May 2015 15:57:01 GMT
Thanks for the suggestions Karthik, but I don't have access to create in
oracle, is there a way I can pass an additional column in sqoop command
line?


Regards
Suresh

On Monday, May 4, 2015, Dhandapani, Karthik <
Karthik.Dhandapani@cvscaremark.com> wrote:

> Hi,
>
>
>
> You can create a view on top of Oracle Table with the 10th column and use
> view as the source to Sqoop.
>
>
>
> Thanks,
>
> Karthik
>
>
>
> *From:* Suresh Kumar Sethuramaswamy [mailto:rockssk@gmail.com
> <javascript:_e(%7B%7D,'cvml','rockssk@gmail.com');>]
> *Sent:* Monday, May 04, 2015 11:35 AM
> *To:* user@sqoop.apache.org
> <javascript:_e(%7B%7D,'cvml','user@sqoop.apache.org');>
> *Subject:* Sqoop import to hive with additional column
>
>
>
> hi
>
>
>
>
>
>     I need to source data from oracle to hive, oracle has 9 columns and
> hive 10 columns , the 10th column need to be a constant value(ex. Date)
>
>
>
> How do I hardcode the value for 10th column while import , suggestions
> please
>
>
>
>
>
> Regards
>
> Suresh
>

Mime
View raw message