On-Demand Recordings from PrestoCon’s, Webinars, Meetups, and more
DataCTRL is a data management platform for ingesting large quantities of disparate data sets. We’ve written a connector for Presto which allows our users to leverage the data they’ve ingested using SQL. Integrating Presto with our platform has given our customers a quick and effective way to query their data while also building additional data products.
Presto has been widely used at Bytedance in several ways such as in the data warehouse, BI tools, ads etc. And, the Presto team at Bytedance has also delivered many key features and optimizations such as the Hive UDF wrapper, coordinator, runtime filter and so on which extend Presto usages and enhance Presto stabilities. Nowadays, most companies will use both Hive (or Spark) and Presto together. But Presto UDFs have very different syntax and internal mechanisms compared with Hive UDFs. This restricts Presto usage while users need to maintain 2 kinds of functions. In this talk, we will present a way to execute Hive UDF/UDAF inside Presto.