Ideas

Treasure Data's primary idea portal. 

Submit your ideas & feature requests directly to our product requirements team! We look forward to hearing from you.

Create our own reusable functions (UDF)

Much like any database (Postgres for instance) we want to be able to create our own reusable functions. A function library of reusable code would be great so we wouldn't have to repeat so much Presto or hive questions all the time.

Also it would clean up every query and also help developers inside TreasureData do things the same way.

  • Ola Nate
  • Dec 20 2016
  • Under Review
Active Requests?
Product Component Query Engines
  • Admin
    Antonio Romero commented
    August 17, 2017 18:10

    The usefulness of this idea is obvious.

    However:

    • One of the difficulties presented by this is that to pick up new UDFs the entire presto cluster may have to be restarted. Given that we run multitenant Presto environments, this may not be an acceptable tradeoff because of the impact to other customers. 
    • There are other issues -- for example, we'd have to impose certain limits to ensure the UDF would not risk system stability or security. 
  • Ola Nate commented
    April 18, 2018 19:01

    How about letting people submit UDF's as a pull request and you allow it if you think it's good?