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

2010-11-09 Thread Tim Robertson
_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

2010-11-08 Thread Paul Yang
: 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

2010-11-08 Thread Tim Robertson
ngdom_concept_id, phylum_concept_id) >> as p,k from temp_kingdom_phylum; >> FAILED: Error in semantic analysis: Only a single expression in the >> SELECT clause is supported with UDTF's >> hive> >> >> Below is my code.  Thanks for any pointers, &g

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

2010-11-08 Thread Sonal Goyal
hive> select taxonDensityUDTF(kingdom_concept_id, phylum_concept_id) > as p,k from temp_kingdom_phylum; > FAILED: Error in semantic analysis: Only a single expression in the > SELECT clause is supported with UDTF's > hive> > > Below is my code. Thanks for any point

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

2010-11-08 Thread Tim Robertson
Hi all, I am trying my first UDTF, but can't seem to get it to run. Can anyone spot anything wrong with this please: hive> select taxonDensityUDTF(kingdom_concept_id, phylum_concept_id) as p,k from temp_kingdom_phylum; FAILED: Error in semantic analysis: Only a single expression in th