admin管理员组

文章数量:1345106

I'm working with Google Spanner (MySQL) in a FastAPI application and encountering this error when trying to search for a column with search index on (as the docs):

status = StatusCode.INVALID_ARGUMENT details = "SEARCH_NGRAMS cannot be used in transactional queries by default." ... google.api_core.exceptions.InvalidArgument: 400 SEARCH_NGRAMS cannot be used in transactional queries by default.

Iam using Sqlalchemy, that's the query:

    query = '''
        SELECT
        *
        FROM 
        permission p
        WHERE
        1=1 AND SEARCH_NGRAMS(p.Tokens, "alpha")
    '''
        
    engine.execute(query)

Questions:

1- How can I use text search capabilities in Google Spanner within transactional contexts? 2- Is there a way to enable SEARCH_NGRAMS in transactional queries? 3- What are alternatives to SEARCH_NGRAMS for searching text in Google Spanner?

本文标签：

版权声明：本文标题：sql - Google Spanner: "SEARCH_NGRAMS cannot be used in transactional queries by default" error - Stack Overflo 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1743798526a2540880.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。