google-bigquery - Invalid POLYGON bigQuery while using ST_GEOGFROMTEXT

Question

I have a column with POLYGON strings and I need to convert them with ST_GEOGFROMTEXT. But I got this error mensage:

"ST_GeogFromText failed: Invalid polygon loop: Edge 1 has duplicate vertex with edge 4; in polygon at position 392"

Is there way to identify which row returns the problem?

标签： google-bigquery

Answer 1

考虑使用SAFE.ST_GeogFromTextwhich 将为错误的行返回 NULL。