Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Sqoop >> mail # user >> Re: Issue in Oozie sqoop action with <command></command> and --query


+
Jarek Jarcec Cecho 2012-10-22, 15:40
+
Nitin kak 2012-10-22, 17:03
+
Jarek Jarcec Cecho 2012-10-22, 17:27
+
Nitin kak 2012-10-19, 21:10
+
Jarek Jarcec Cecho 2012-10-19, 21:25
+
Nitin kak 2012-10-19, 21:32
Copy link to this message
-
Re: Issue in Oozie sqoop action with <command></command> and --query
That is correct - you can't use <command> tag and <arg> tags together. You can use either <command> or <arg>.

Jarcec

On Fri, Oct 19, 2012 at 05:32:12PM -0400, Nitin kak wrote:
> Ahh...that sucks..I hope they will come up with something in future
> releases...
>
> One follow up question...We can't use <command></command> in combination
> with <arg></arg> right?
>
> On Fri, Oct 19, 2012 at 5:25 PM, Jarek Jarcec Cecho <[EMAIL PROTECTED]>wrote:
>
> > Hi Nikin,
> > workaround to use --query parameter inside <command> tag in Oozie is to
> > use multiple <arg> tags instead :-)
> >
> > Basically Oozie will blindly divide value supplied in <command> tag by
> > spaces without taking into account any escaping. You are required to use
> > <arg> tags instead of <command> in case that you need to specify arguments
> > with spaces. For more information please consider Oozie Sqoop action
> > documentation [1].
> >
> > Jarcec
> >
> > Links:
> > 1:
> > http://oozie.apache.org/docs/3.2.0-incubating/DG_SqoopActionExtension.html
> >
> > On Fri, Oct 19, 2012 at 05:10:07PM -0400, Nitin kak wrote:
> > > Hi guys,
> > >
> > >       Just wanted to know how we can use "--query" attribute in
> > > <command></command> of sqoop action in Oozie. The issue is that if we
> > have
> > > something like
> > >
> > > * <command>blah blah ....  --query "select * from table"</command> *is
> > > converted to
> > >
> > > <arg>blah</arg>
> > > <arg>blah</arg>
> > > <arg>--query</arg>
> > > <arg>"select</arg>
> > > <arg>*</arg>
> > > <arg>from</arg>
> > > ....so on
> > > while what we want is
> > >
> > > <arg>blah</arg>
> > > <arg>blah</arg>
> > > <arg>--query</arg>
> > > <arg>"select * from table:</arg>
> > >
> > >
> > > Is there a workaround?
> > >
> > > Regards,
> > > Nitin Kak
> >