Hi Venkat, Thanks, it really works. However the current behavior still seems incorrect to me, I can file an issue if you think it is makes sense.
Regards, Pavel -----Original Message----- From: Venkat Ranganathan [mailto:[email protected]] Sent: Saturday, May 23, 2015 1:35 AM To: [email protected] Subject: Re: Sqoop import fails with "Imported Failed: Can not create a Path from an empty string" You need to add --skip-dist-cache option and add hcatalog (and hive also depending on Oozie versino) as the additional sharelibs Venkat On 5/22/15, 1:49 PM, "Benes, Pavel" <[email protected]> wrote: >Hi Abraham, > >I am running it from oozie, this is my workflow.xml > ><workflow-app xmlns="uri:oozie:workflow:0.4" name="${jobName}"> > <credentials> > <credential name="auth" type="hcat"> > <property> > <name>hcat.metastore.uri</name> > <value>thrift://ip-54-40-222-251.huronc.merck.com:9083/</value> > </property> > <property> > <name>hcat.metastore.principal</name> > <value>hive/[email protected]</value> > </property> > <property> > <name>hive.metastore.sasl.enabled</name> > <value>true</value> > </property> > </credential> > </credentials> > <start to="sqoop0"/> > <action cred="auth" name="sqoop0"> > <sqoop xmlns="uri:oozie:sqoop-action:0.2"> > <job-tracker>${jobTracker}</job-tracker> > <name-node>${nameNode}</name-node> > <job-xml>hive-site.xml</job-xml> > <arg>import</arg> > <arg>--connect</arg> > > <arg>jdbc:postgresql://54.40.29.151:5432/test_user_middlegate_dev_gerrit_build_232</arg> > <arg>--username</arg> > <arg>middlegate</arg> > <arg>--password-file</arg> > <arg>${nameNode}${wf:appPath()}/.passwords/password</arg> > <arg>--table</arg> > <arg>cars</arg> > <arg>--hcatalog-database</arg> > <arg>${hive_output_100_cars_database}</arg> > <arg>--hcatalog-table</arg> > <arg>${hive_output_100_cars_table}</arg> > <arg>--hive-partition-key</arg> > <arg>mg_version</arg> > <arg>--hive-partition-value</arg> > <arg>${hive_output_100_cars_dated_partition_value_mg_version}</arg> > <arg>-m</arg> > <arg>1</arg> > <arg>--verbose</arg> > <arg>--driver</arg> > <arg>org.postgresql.Driver</arg> > </sqoop> > <ok to="end"/> > <error to="kill"/> > </action> > <kill name="kill"> > <message>Action failed, error > message[${wf:errorMessage(wf:lastErrorNode())}]</message> > </kill> > <end name="end"/> ></workflow-app> > >I am also attaching the log file. > >The working workaround is to add the property 'tmpjars' into workflow.xml >pointing to some existing jar file. > >Thanks, > >Pavel > >-----Original Message----- >From: Abraham Elmahrek [mailto:[email protected]] >Sent: Friday, May 22, 2015 6:38 PM >To: [email protected] >Subject: Re: Sqoop import fails with "Imported Failed: Can not create a Path >from an empty string" > >Possibly Pavel, > >Could you provide your full command as well as the --verbose output? > >-Abe > >On Fri, May 22, 2015 at 3:07 AM, Benes, Pavel <[email protected]> wrote: > >> Hi guys, >> >> I am using sqoop-1.4.5 with HCatalog integration, and my imports are >> crashing with this error: >> >> 12187 [main] ERROR org.apache.sqoop.tool.ImportTool - Imported Failed: >> Can not create a Path from an empty string >> 2015-05-21 13:42:40,221 ERROR [main] tool.ImportTool >> (ImportTool.java:run(603)) - Imported Failed: Can not create a Path from an >> empty string >> >> After looking into sources, it looks the problem lies in the processing of >> the list of jars coming from the property 'tmpjars'. The implementation >> does not handle correctly the situation where the property value is empty >> (but not null). >> >> I am able to workaround this by setting this property with some dummy >> value, but in general it looks like a bug. >> >> Have you experienced this sort of problem as well? >> >> Thanks, >> >> Pavel >> Notice: This e-mail message, together with any attachments, contains >> information of Merck & Co., Inc. (2000 Galloping Hill Road, Kenilworth, >> New Jersey, USA 07033), and/or its affiliates Direct contact information >> for affiliates is available at >> http://www.merck.com/contact/contacts.html) that may be confidential, >> proprietary copyrighted and/or legally privileged. It is intended solely >> for the use of the individual or entity named on this message. If you are >> not the intended recipient, and have received this message in error, >> please notify us immediately by reply e-mail and then delete it from >> your system. >> >Notice: This e-mail message, together with any attachments, contains >information of Merck & Co., Inc. (2000 Galloping Hill Road, Kenilworth, >New Jersey, USA 07033), and/or its affiliates Direct contact information >for affiliates is available at >http://www.merck.com/contact/contacts.html) that may be confidential, >proprietary copyrighted and/or legally privileged. It is intended solely >for the use of the individual or entity named on this message. If you are >not the intended recipient, and have received this message in error, >please notify us immediately by reply e-mail and then delete it from >your system. Notice: This e-mail message, together with any attachments, contains information of Merck & Co., Inc. (2000 Galloping Hill Road, Kenilworth, New Jersey, USA 07033), and/or its affiliates Direct contact information for affiliates is available at http://www.merck.com/contact/contacts.html) that may be confidential, proprietary copyrighted and/or legally privileged. It is intended solely for the use of the individual or entity named on this message. If you are not the intended recipient, and have received this message in error, please notify us immediately by reply e-mail and then delete it from your system.
