Re: Only a single expression in the SELECT clause is supported with UDTF's

_id) as (p,k) ... > > -Original Message- > From: Tim Robertson [mailto:timrobertson...@gmail.com] > Sent: Monday, November 08, 2010 5:53 AM > To: user@hive.apache.org > Subject: Re: Only a single expression in the SELECT clause is supported with > UDTF's > > Thank you onc

RE: Only a single expression in the SELECT clause is supported with UDTF's

: user@hive.apache.org Subject: Re: Only a single expression in the SELECT clause is supported with UDTF's Thank you once again Sonal. The following worked just nicely: select k,p from temp_kingdom_phylum lateral view taxonDensityUDTF(kingdom_concept_id, phylum_concept_id) e as k,p; [For a

Re: Only a single expression in the SELECT clause is supported with UDTF's

Thank you once again Sonal. The following worked just nicely: select k,p from temp_kingdom_phylum lateral view taxonDensityUDTF(kingdom_concept_id, phylum_concept_id) e as k,p; [For anyone stumbling across this thread: I also had to change the close() and issue the forward() in the process andn

Re: Only a single expression in the SELECT clause is supported with UDTF's

Hi Tim, I guess you are running into limitations while using UDTFs. Check http://wiki.apache.org/hadoop/Hive/LanguageManual/UDF#UDTF. I think you should be able to use lateral view in your query. Thanks and Regards, Sonal Sonal Goyal | Founder and CEO | Nube Technologies LLP http://www.nubetech.