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.
