hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From 王锋 <wfeng1...@163.com>
Subject The Confused question of hive udf
Date Fri, 11 May 2012 08:10:19 GMT
Hi,
   we have an udf called minf which can change current time to one point .
  for example   20120510:00:00:00   -->  minf  20120510000,
                       20120510:00:06:00   ->   minf  20120510001
                       20120510:10:51:38   ->   minf  20120510130


we test the minf  function using main function ,it is normal.
but  when using in hive,the sql :
select minf(createtime) as minf  from table limit 500;
the results are normally sometime:
20120510195
20120510195
20120510195
20120510195
20120510198
20120510198
20120510198
20120510198
20120510196
20120510197
20120510198
20120510197
20120510195
20120510196
20120510196
20120510196
20120510195
20120510196
20120510195
20120510195
20120510195
20120510195
20120510195
20120510195
20120510197
20120510196
20120510197
20120510196
20120510196
20120510196
20120510196
20120510196
20120510196
20120510197
20120510197
20120510197
20120510198
20120510197
20120510198
20120510197
20120510198
20120510198
20120510198
20120510198
but sometime the results are unnormally:
20120510195
20120510198
20120510198
20120510198
20120510198
20120510195
20120510195
20120510195
2012[10198 
2012[10198 
2012[10198 
2012[10198 
20120510196
2012[10196 
20120510195
20120510197
2012[10198 
2012[10197 
2012[10197 
20120510197
20120510195
20120510195
20120510198
20120510196
2012[10196 
20120510195
2012[10196 
2012[10198 
2012[10198 
20120510196
2012[10196 
2012[10196 
2012[10196 
20120510196
2012[10196 
20120510196
2012[10196 
20120510196
2012[10196 
20120510196
20120510196
20120510196
2012[10196 
20120510195
20120510196
2012[10198 
20120510195
20120510198
20120510197
20120510197
20120510197
2012[10197 
2012[10197 
2012[10197 
2012[10197 
2012[10197 
2012[10197 
20120510198
20120510198
20120510198
20120510198
2012[10198 
2012[10198 
20120510195
20120510197
20120510197
2012[10198 
20120510198
20120510198
20120510198


when data of the table is small, Probability of normal  results was high. And error was disappeared
in month field.
wrong:2012[10198---->right:20120510198  
some issue or cause?


  
Mime
View raw message