You can do a query import and then provide the split by column explicitly. You don’t have do only table/view imports
Venkat From: Suresh Kumar Sethuramaswamy Reply-To: "[email protected]<mailto:[email protected]>" Date: Monday, May 4, 2015 at 8:57 AM To: "[email protected]<mailto:[email protected]>" Subject: Re: Sqoop import to hive with additional column 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 <[email protected]<mailto:[email protected]>> 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:[email protected]<javascript:_e(%7B%7D,'cvml','[email protected]');>] Sent: Monday, May 04, 2015 11:35 AM To: [email protected]<javascript:_e(%7B%7D,'cvml','[email protected]');> 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
