This JIRA should be included in the next release upstream but since you use a Cloudera distribution I suggest contacting your account manager regarding the ETA of this feature in CDH.
Regards, Szabolcs On Wed, Nov 28, 2018 at 12:04 AM Olav Jordens <olav.jord...@tenzing.co.nz> wrote: > Hi Szabolcs, > > > > Thanks for getting back to me. We are using Cloudera 5.15 with Sqoop 1.4.6 > included as standard. Your JIRA is certainly of interest for us. Which > version of Sqoop are you targeting for this development? > > > > Regards, > > Olav > > > > > > *From:* Szabolcs Vasas <va...@apache.org> > *Sent:* Tuesday, 27 November 2018 11:33 PM > *To:* user@sqoop.apache.org > *Subject:* Re: Sqoop usernames > > > > Hi Olav, > > > > Sqoop uses HiveCLI by default to import the data into Hive and it does not > support specifying custom username and password. > > We have already implemented a way to connect to HiveServer2 and execute > the import through it (https://issues.apache.org/jira/browse/SQOOP-3299) > just like Beeline does but it is not yet released and it only supports > Kerberos authentication at the moment. > > What Sqoop version do you use? > > > > Regards, > > Szabolcs > > > > On Mon, Nov 19, 2018 at 3:44 AM Olav Jordens <olav.jord...@tenzing.co.nz> > wrote: > > Hi Sqoop Users, > > > > I have bumped into an odd issue. I am using sqoop import to extract from > Oracle to HDFS. I have the Oracle username and password for extracting the > data, but would also like to supply the Hive username and password. How can > that be done? The reason is that Sqoop client is installed on a box where I > have only a generic username that is not available in Hive. When I use > beeline from this box, I can access Hive by providing username and > password. Also when I use sqoop list-databases I can access Oracle using > the Oracle username and password. However, for sqoop import I will need to > supply both the Oracle and the Hive credentials. How can I do this? (I have > seen reference to using export $HADOOP_USER_NAME but not password) > > > > Thanks, > > Olav > > > > > > Olav Jordens | Senior Manager | T +64 (0)9 362 3208 | Mobile +64 022 620 > 2429 > > Tenzing - Management & Technology Consultants | http://www.tenzing.co.nz/ > > > > *This email is confidential and subject to our standard Tenzing disclaimer > which can be viewed on our website at **www.tenzing.co.nz/disclaimer* > <http://www.tenzing.co.nz/disclaimer> > > > >