我有这样的表:
文档:
+-----+---------+
| dId | score |
+-----+---------+
| A | 100 |
| B | 80 |
| C | 70 |
+-----+---------+
实体:
+------+------------+-----+
| name | details | dId |
+------+------------+-----+
| e1 | a | A |
| e2 | a | A |
| e3 | b | B |
| e4 | c | B |
| e5 | d | C |
+------+------------+-----+
预期输出:
+------+--------+----------+
| dId | score | entities |
+------+--------+----------+
| A | 100 | e1, e2 |
| B | 80 | e3, e4 |
| C | 70 | e5 |
+------+--------+----------+
当前查询:
SELECT
docT.dId,
docT.score,
entityT.name AS entities
FROM
document docT,
entity entityT
LEFT JOIN
document_sentiment docT1
ON
docT1.dId = entityT.dId
但我正在寻找BigQuery 使用的标准 SQL 格式。
如何获得标准 SQL 格式的预期输出?
尝试如下
select d.dId,score,STRING_AGG(e.name)
document d join entity e on d.did=e.did
group by d.dId,score
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句