pymonetdb or Python UDF

Doherty, Adam adam.doherty at esso.ca
Wed Jun 13 18:31:47 CEST 2018


Hello all:

This is more of curiosity but I have data in my events table currently trapped in a nvarchar field.
I am wondering if I can build a table and do execute a select into with a python UDF pulling data from the existing fields plus the values of my nvarchar field.

My string data has the following format -

"key1=value, key2=val, key3=value"...

I want to break out the data first by splitting on the , and then the =
Keys would be the columns in the table.

I can do this with a python script and pymonetdb but a UDF would be faster.

Adam Doherty
Process Control Systems Administrator
Kearl Technical, Imperial
505 Quarry Park Blvd SE
W3B.224
Calgary, AB T2C 5N1
adam.doherty at esso.ca<mailto:adam.doherty at esso.ca>    P 587.476.4640<tel:+15874764640>   M 403.869.1636<tel:+14038691636>
imperialoil.ca<http://www.imperialoil.ca/Canada-English/default.aspx>  |  Twitter<http://www.twitter.com/imperialoil>  |  YouTube<http://www.youtube.com/imperialoil>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.monetdb.org/pipermail/users-list/attachments/20180613/cd5b45f4/attachment-0001.html>


More information about the users-list mailing list