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.

select distinct ON support

In PostgreSQL the phrase

SELECT DISTINCT ON (col1, col2)

is a really handy mechanism for pulling out a combination of unique values from a table along with combinations of the other columns.  It would be great if Presto could support this syntax.

 

  • Rick Otten
  • Sep 1 2016