Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
Received-SPF: pass (athena.apache.org: domain of edlinuxguru@gmail.com
 designates 74.125.82.54 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <1391008899.42220.YahooMailNeo@web160106.mail.bf1.yahoo.com>
References: <1391008899.42220.YahooMailNeo@web160106.mail.bf1.yahoo.com>
Date: Wed, 29 Jan 2014 10:29:14 -0500
Message-ID: 
 <CAENxBwxXLA4Bg9xn1i1wk5urbRVtM+L+=EaQseAg6LH4vVh1oA@mail.gmail.com>
Subject: Re: Returning variable number of fields from Hive UDTF
From: Edward Capriolo <edlinuxguru@gmail.com>
To: "user@hive.apache.org" <user@hive.apache.org>,
 Kumar V <kumarbuyonline@yahoo.com>
Content-Type: multipart/alternative; boundary=089e01176b1d710bd104f11d9a6a

--089e01176b1d710bd104f11d9a6a
Content-Type: text/plain; charset=ISO-8859-1

if and only if the number is truely a constant, you can use the constant
Object Inspector in initialize. The value but be a constant at query
compile time.
So this should work:
myudtf(5,xpathsfile);

THhis can not work
myudtf(colx,xpathsfile);


On Wed, Jan 29, 2014 at 10:21 AM, Kumar V <kumarbuyonline@yahoo.com> wrote:

> Hi all,
>     I have a UDTF that returns fields from an XML/SerDe based table.  So I
> have to return varying number of fields from the UDTF based on the number
> of xpath's in the query file.  I am not sure how to access the values of
> the parameters in the initialize() method of the UDTF.  It only has the
> ObjectInspector array. The UDTF itself works fine if I always return a
> fixed number of fields.
>
> Something like
>
> select * from myudtf(xpathsfile);
>
> Should return as many fields as there are xpaths in the file.  Or I can
> also modify the UDTF to take in a parameter for the number of fields, like
>
> select * from myudtf(5,xpathsfile);
>
> I am kind of against a wall here. Any help is appreciated.
>
> Regards,
> Murali.
>

--089e01176b1d710bd104f11d9a6a
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">if and only if the number is truely a constant, you can us=
e the constant Object Inspector in initialize. The value but be a constant =
at query compile time. <br>So this should work:<br>myudtf(5,xpathsfile);<br=
>
<br>THhis can not work<br>myudtf(colx,xpathsfile);</div><div class=3D"gmail=
_extra"><br><br><div class=3D"gmail_quote">On Wed, Jan 29, 2014 at 10:21 AM=
, Kumar V <span dir=3D"ltr">&lt;<a href=3D"mailto:kumarbuyonline@yahoo.com"=
 target=3D"_blank">kumarbuyonline@yahoo.com</a>&gt;</span> wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex"><div><div style=3D"font-size:12pt;font-famil=
y:HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif"><d=
iv>
Hi all,</div><div>=A0=A0=A0 I have a=A0UDTF that returns fields from an XML=
/SerDe based table.=A0 So I have to return varying number of fields from th=
e UDTF based on the number of xpath&#39;s in the query file.=A0 I am not su=
re how to access the values of the parameters in the initialize() method of=
 the UDTF.=A0 It only has the ObjectInspector array. The UDTF itself works =
fine if I always return a fixed number of fields.</div>
<div><br></div><div>Something like </div><div><br></div><div>select * from =
myudtf(xpathsfile);</div><div><br></div><div>Should return as many fields a=
s there are xpaths in the file.=A0 Or I can also modify the UDTF to take in=
 a parameter for the number of fields, like</div>
<div><br></div><div>select * from
 myudtf(5,xpathsfile);</div><div><br></div><div>I am kind of against a wall=
 here. Any help is appreciated.</div><div><br></div><div>Regards,</div><div=
>Murali.</div></div></div></blockquote></div><br></div>

--089e01176b1d710bd104f11d9a6a--