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]> 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 >
