Thank you Szabolcs – this has been most helpful. Olav From: Szabolcs Vasas <va...@apache.org> Sent: Thursday, 29 November 2018 1:28 AM To: user@sqoop.apache.org Subject: Re: Sqoop usernames
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<mailto: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<mailto:va...@apache.org>> Sent: Tuesday, 27 November 2018 11:33 PM To: user@sqoop.apache.org<mailto: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<mailto: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>
