英文:
Does CloudSpanner support Fuzzy Search or Wild Card Search?
问题
我正在为工作的一个尖峰项目进行有关CloudSpanner的研究，并将其与BigTable/Elastic Search进行比较。我的团队希望找出CloudSpanner是否支持模糊搜索（FuzzySearch）和/或通配符查询（WildCard query）。我在文章中和观看YouTube直播演示中都找不到相关信息，而且我也无法访问演示/免费试用。我知道CloudSpanner使用NewSQL，但我也找不到有关NewSQL是否支持这些功能的信息。
英文:
I'm doing research on CloudSpanner as part of a spike for work, and comparing it to BigTable/Elastic Search. My team wanted to find out whether or not CloudSpanner supports either FuzzySearch and/or WildCard query. I could find this neither in articles nor by viewing youtube live demos, and i can't access a demo/free trial either. I know that CloudSpanner utilizes NewSQL but I couldn't find anything on NewSQL supporting those either.
答案1
得分: 1
Cloud Spanner不直接支持模糊搜索，据我所知，它也不直接支持通配符查询。
它支持的最相似的功能是：
正则表达式：
使用函数REGEXP_CONTAINS，您可以执行带有匹配所需内容的正则表达式查询。这允许查找[úuü]，以查找所有u的替代项。
LIKE运算符
LIKE运算符允许您匹配字符串的一部分。要查看它的文档，您可以在这里查看。
如果这些替代方法都不适用于您，那么我建议您尝试像这样的方法。
英文:
Cloud Spanner doesn't support FuzzySearch directly and as far as I know it does not support WildCard Queries directly.
the most similar things that it supports that can work for you are:
Regular Expressions:
With the function REGEXP_CONTAINS with which you can perform queries with a regular expression that matches what you want. This allows to look for [úuü] looks for all the alternatives of u.
LIKE Operator
The like operator will allow you to match a section of a string. to see it documentation you can check it here
If none of this alternatives work for you then i would suggest to do something like this
答案2
得分: -2
Yes, Cloud Spanner支持一些SQL查询的通配符（请参阅文档）。
https://cloud.google.com/spanner/docs/query-syntax
英文:
Yes, Cloud Spanner supports wild cards for some SQL queries (see documentation).
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论