hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tim Robertson <timrobertson...@gmail.com>
Subject Re: UDF help
Date Tue, 02 Nov 2010 19:13:01 GMT
Thanks Edward.  I'll poke around there.



On Tue, Nov 2, 2010 at 6:40 PM, Edward Capriolo <edlinuxguru@gmail.com> wrote:
> On Tue, Nov 2, 2010 at 12:47 PM, Tim Robertson
> <timrobertson100@gmail.com> wrote:
>> Hi all,
>>
>> Is the following a valid UDF please?
>>
>> When I run it I get the following so I presume not:
>> hive> select toGoogleCoords(latitude,longitude,1) from
>> raw_occurrence_record limit 100;
>> FAILED: Error in semantic analysis:
>> java.lang.IllegalArgumentException: Error: name expected at the
>> position 7 of 'struct<>' but '>' is found.
>>
>> Is it possible to return an Array from a UDF?
>>
>> Thanks for any pointers,
>> Tim
>>
>>
>>
>>
>> public class GoogleTileCoordsUDF extends UDF {
>>
>>  public IntWritable[] evaluate(Text latitude, Text longitude,
>> IntWritable zoomLevel) {
>>    if (latitude == null
>>                || longitude == null
>>                || zoomLevel == null) {
>>      return null;
>>    }
>>
>>    double lat = Double.parseDouble(latitude.toString());
>>    double lng = Double.parseDouble(longitude.toString());
>>
>>    Point p = GoogleTileUtil.toTileXY(lat, lng, zoomLevel.get());
>>
>>    if (p==null) {
>>      return null;
>>    }
>>
>>    IntWritable[] xy = new IntWritable[2];
>>    xy[0]=new IntWritable(p.x);
>>    xy[1]=new IntWritable(p.y);
>>    return xy;
>>  }
>> }
>>
>
> I believe a UDF can not return an Array type. You may have to use the
> GenericUDF interface for that.
>

Mime
View raw message