未展平结果时 NEST 的内部错误 [英] Internal error on NEST when not flattening results

问题描述

我正在尝试对重复的字段进行分组并将其返回到新表中

I'm trying to GROUP and return a repeated field into a new table

SELECT url, NEST(label) AS labels
FROM [mytable]
GROUP EACH BY url

当我选中展平结果"复选框时，它就起作用了.当我取消选中该框时，我收到错误:发生内部错误且无法完成请求."

It works when I've got the "Flatten Results" checkbox checked. When I uncheck that box I get 'Error: An internal error occurred and the request could not be completed.'

本体知识图:job_qD7a2Wrq9uCTqZrMbvwdy3v9Vtg

ontology-knowledge-graph:job_qD7a2Wrq9uCTqZrMbvwdy3v9Vtg

推荐答案

NEST 不幸的是与 unflattened 结果不兼容，正如也提到的 此处.

NEST is unfortunately incompatible with unflattened results, as also mentioned here.

可能对您有用的解决方法是使用 SPLIT(GROUP_CONCAT(label)) 而不是使用 NEST.如果您的标签字段是字符串类型，那应该可行.如果您的标签包含逗号，您可能需要为 GROUP_CONCAT 选择一个显式分隔符，但我认为此解决方案应该可行.

A workaround that might work for you is using SPLIT(GROUP_CONCAT(label)) instead of using NEST. That should work if your label field is of type string. You may need to choose an explicit separator for GROUP_CONCAT if your labels contain commas, but I think this solution should be workable.

这篇关于未展平结果时 NEST 的内部错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！