Geocoding with UDFs - geopy library

steffen_check24
Contributor

Hi,

I was trying out the Exasol tutorial that shows you how to determine the latitude and longitude for a given place.

The used library geopy seems not to be preinstalled in my Exasol environment, at least I do get following error:

[22002] VM error: F-UDF-CL-LIB-1125: F-UDF-CL-SL-PYTHON-1000: F-UDF-CL-SL-PYTHON-1017: ExaUDFError: F-UDF-CL-SL-PYTHON-1122: Exception while parsing UDF GEOPY_GEOCODE_LONG_LAT:3 <module> ImportError: No module named geopy.geocoders

 

Does anyone know how to add additional libraries?

Or could it have something to do with following line of the python script, that I need to modify?

sys.path.extend(glob.glob('/buckets/bucketfs1/showcase/*'))

?

Any ideas wellcome. 

 

Cheers,

Steffen

1 ACCEPTED SOLUTION

Accepted Solutions

exa-Kristof
Team Exasol
Team Exasol

Hi Steffen, 

this example is based on our free trial system where the library is already added. If you want to do this on your own system you have to add geopy to BucketFS to use it. How to do that is described in our free Exacademy Advanced Analytics course: https://exacademy.exasol.com/courses/course-v1:Exasol+ADVA+X/course/

--> Chapter "BucketFS - Uploading Python Packages"

Best regards,

Kristof

View solution in original post

1 REPLY 1

exa-Kristof
Team Exasol
Team Exasol

Hi Steffen, 

this example is based on our free trial system where the library is already added. If you want to do this on your own system you have to add geopy to BucketFS to use it. How to do that is described in our free Exacademy Advanced Analytics course: https://exacademy.exasol.com/courses/course-v1:Exasol+ADVA+X/course/

--> Chapter "BucketFS - Uploading Python Packages"

Best regards,

Kristof

View solution in original post