Hi Layla, UDFs were not completely implemented in version 1.0, I'm sure you would run into some problems and nobody would be able to help you with them on R1.0. Just FYI: We are just now working on getting Java UDFs working for the next release, so far only C++ is supported.
Yes, UDFs are definitely meant to help with integrating semi-structured data. A UDF could read JSON data, for example, and transform it into a relational output. The JSON data could come from an external source or from an input table, where it could have the form of a VARCHAR. Trafodion UDFs, called TMUDFs (Table-mapping UDFs) can have up to one input table, for now. I like to think of them as similar to a MapReduce program, a TMUDF can behave like a mapper (no PARTITION BY or ORDER BY clauses used for the input table, if there is one) or a reducer (with PARTITION BY and/or ORDER BY specified on the input table). Let me know if you have something specific in mind. I would be very interested in any feedback you have, what's missing from the tutorial and how we could improve Trafodion UDFs. Thanks, Hans 2015-07-17 4:54 GMT-07:00 Martin, Layla (HP DualStudy) <[email protected]> : > Hi everyone, > > > > Is it possible to use UDFs with Trafodion v1.0? The Tutorial only applies > to v1.1 … > > > > Could someone give me a “for dummies” intro into UDF programming? > > -Is it possible to leverage semi-structured data using UDFs? (How to do > that?) > > > > Best regards > > Layla > > > > *Layla Martin* > HP DualStudy > > Hewlett-Packard GmbH > > Telefon +49 7031 4504682 > > *[email protected] <[email protected]>* > > Herrenberger Strasse 140| 71034 Böblingen| www.hp.com/de/dualstudy > > [image: Description: Description: > http://intranet.hp.com/country/germany/live/PublishingImages/NeuesLogoSmall.png] > > Follow us on: [image: facebook] <https://www.facebook.com/DualStudy.hp> > [image: > twitter] <http://twitter.com/hpdualstudy> [image: youtube] > <http://www.youtube.com/user/hpDualStudy> > > Geschäftsführer: Heiko Meyer (Vorsitzender), Thomas Bässler, Volkhard > Bregulla, Michael Eberhardt, Jochen Erlach, Angelika Gifford, Ernst > Reichart > Vorsitzender des Aufsichtsrats: Jörg Menno Harms > Sitz der Gesellschaft: Böblingen, Amtsgericht Stuttgart HRB 244081 > WEEE-Reg.-Nr. DE 30409072 > > > > >
