Videos Archive - PrestoDB

5 Reasons Why AI Is the Future of SQL – Jared Zhao, AskEdith

SQL remains ubiquitous for data retrieval and analytics, yet can be tedious to write, and is downright unusable for business users. The 2-5 business day turnaround time for data projects is both disruptive and frustrating for business users. Data teams are becoming increasingly overwhelmed, and organizations are pushing to empower their “citizen data analysts.” With the advent of AI English-to-SQL platforms like AskEdith, now anyone can work with and query Presto using plain English questions. AskEdith integrates natively with web interfaces like Ahana for a seamless analytics experience.

Presto at Bytedance- Hive UDF Wrapper for Presto

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.