presto中的SubQuery

Question

SELECT
  id,(select something
   from table2 
   where table2.id = table.id) AS "Description"
 FROM table

我得到了这个错误：

presto error: Scalar sub-query has returned multiple rows

如何在presto中写入子查询？

Answer 1

Presto确实支持嵌套查询。我认为问题出在你的语义上。

您正在尝试从嵌套查询中投影某些内容，但它需要一个标量值。

可能是这样的-

select
id, desc from 
(select table.id as id, something as desc
    from table2 
    where table2.id = table.id)