jzs1997 opened a new issue, #34974:
URL: https://github.com/apache/shardingsphere/issues/34974
## Feature Request
Please pay attention on issues you submitted, because we maybe need more
details.
If no response anymore and we cannot make decision by current information,
we will **close it**.
Please answer these questions before submitting your issue. Thanks!
### Is your feature request related to a problem?
No
### Describe the feature you would like.
opengauss has a new feature called Data Vec which support some vector
calculation. But shardingsphere seems do not support some of the operators. Now
we have problems executing these operators via shardingsphere:
```
SELECT '111' <=> '110';
SELECT '111' <~> '110';
SELECT '1111' <%> '1000';
SELECT '{1:1,2:2}/2'::sparsevec <=> '{1:2,2:4}/2';
SELECT '{}/2'::sparsevec <+> '{1:3,2:4}/2';
```
These queries with the following two operator can be executed
```
SELECT * FROM t1 ORDER BY val <-> '[3, 1, 2]' LIMIT 5;
SELECT * FROM t1 ORDER BY val <#> '[3, 1, 2]' LIMIT 5;
```
References may help:
https://docs.opengauss.org/zh/docs/latest/docs/SQLReference/%E5%90%91%E9%87%8F%E5%87%BD%E6%95%B0%E5%92%8C%E6%93%8D%E4%BD%9C%E7%AC%A6.html
https://docs.opengauss.org/zh/docs/latest/docs/AboutopenGauss/DataVec%E5%90%91%E9%87%8F%E5%BC%95%E6%93%8E.html
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail:
notifications-unsubscr...@shardingsphere.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
