不平坦化结果时，NEST发生内部错误

问题描述

我尝试GROUP并将重复的字段返回到新表中

  SELECT url，NEST（label）AS标签
 FROM [mytable] 
 GROUP EACH BY网址
  

已选中展平结果复选框。当我取消选中该框时，我得到'错误：发生内部错误，并且请求无法完成。'

本体知识图：job_qD7a2Wrq9uCTqZrMbvwdy3v9Vtg

解决方案

NEST 不幸与unflattened结果不兼容，也提到。

可能适用于您的解决方法是使用 SPLIT（GROUP_CONCAT（label）），而不是使用 NEST 。如果你的标签字段是字符串类型的话，这应该起作用。如果您的标签包含逗号，您可能需要为 GROUP_CONCAT 选择明确的分隔符，但我认为此解决方案应该可行。

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.'

ontology-knowledge-graph:job_qD7a2Wrq9uCTqZrMbvwdy3v9Vtg

解决方案

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

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发生内部错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！