Trafodion UDF

["Martin, Layla (HP DualStudy)" <la...@hp.com>]

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
layla.martin@hp.com<ma...@hp.com>
Herrenberger Strasse 140| 71034 Böblingen| www.hp.com/de/dualstudy<http://www.hp.com/de/dualstudy>
[Description: Description: http://intranet.hp.com/country/germany/live/PublishingImages/NeuesLogoSmall.png]
Follow us on: [facebook] <https://www.facebook.com/DualStudy.hp>  [twitter] <http://twitter.com/hpdualstudy>  [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

Re: Trafodion UDF

[Hans Zeller <ha...@esgyn.com>]

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) <la...@hp.com>
:

>  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
>
> *layla.martin@hp.com <la...@hp.com>*
>
> 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
>
>
>
>
>