Re: Hive UDF gives duplicate result regardless of parameters, when nested in a subquery

2014-07-24 Thread 丁桂涛(桂花)
Yeah. After setting hive.cache.expr.evaluation=false, all queries output expected results. And I found that it's related to the getDisplayString function in the UDF. At first the function returns a string regardless of its parameters. And I had to set hive.cache.expr.evaluation = false. But after

Re: Hive UDF gives duplicate result regardless of parameters, when nested in a subquery

2014-07-23 Thread Navis류승우
Looks like it's caused by HIVE-7314. Could you try that with "hive.cache.expr.evaluation=false"? Thanks, Navis 2014-07-24 14:34 GMT+09:00 丁桂涛(桂花) : > Yes. The output is correct: ["tp","p","sp"]. > > I developed the UDF using JAVA in eclipse and exported the jar file into > the auxlib directory

Re: Hive UDF gives duplicate result regardless of parameters, when nested in a subquery

2014-07-23 Thread 丁桂涛(桂花)
Yes. The output is correct: ["tp","p","sp"]. I developed the UDF using JAVA in eclipse and exported the jar file into the auxlib directory of hive. Then add the following line into the ~/.hiverc file. create temporary function getad as 'xxx'; The hive version is 0.12.0. Perhaps the problem r

Re: Hive UDF gives duplicate result regardless of parameters, when nested in a subquery

2014-07-23 Thread Jie Jin
Have you tried this query without UDF, say: select array(tp, p, sp) as ps from ( select 'tp' as tp, 'p' as p, 'sp' as sp from table_name where id = ) t; ​And how you implement the UDF?​ 谢谢 金杰 (Jie Jin) On Wed, Jul 23, 2014 at 1:34 PM, 丁桂涛(桂花) wrote: > R