hdulay opened a new issue, #12359:
URL: https://github.com/apache/pinot/issues/12359
I'm testing the Vector Similarity function using this statement but getting
the corresponding error: `For VECTOR_SIMILARITY predicate, the second operand
must be a float array literal`
```sql
select ProductId, UserId,
l2_distance(ARRAY[0.1,0.1,0.3,0.4],ARRAY[0.1,0.1,0.3,0.4]) as l2_dist,
n_tokens, combined
from fineFoodReviews
where VECTOR_SIMILARITY(ARRAY[0.1,0.1,0.3,0.4],ARRAY[0.1,0.1,0.3,0.4], 5)
-- order by l2_dist ASC
limit 5
```
```
ProcessingException(errorCode:150, message:SQLParsingError:
org.apache.pinot.sql.parsers.SqlCompilationException: For VECTOR_SIMILARITY
predicate, the second operand must be a float array literal, got:
Expression(type:FUNCTION, functionCall:Function(operator:VECTOR_SIMILARITY,
operands:[Expression(type:LITERAL, literal:<Literal doubleArrayValue:[0.1, 0.1,
0.3, 0.4]>), Expression(type:LITERAL, literal:<Literal doubleArrayValue:[0.1,
0.1, 0.3, 0.4]>), Expression(type:LITERAL, literal:<Literal longValue:5>)]))
at
org.apache.pinot.sql.parsers.rewriter.PredicateComparisonRewriter.updateFunctionExpression(PredicateComparisonRewriter.java:139)
at
org.apache.pinot.sql.parsers.rewriter.PredicateComparisonRewriter.updatePredicate(PredicateComparisonRewriter.java:65)
at
org.apache.pinot.sql.parsers.rewriter.PredicateComparisonRewriter.rewrite(PredicateComparisonRewriter.java:40)
at
org.apache.pinot.sql.parsers.CalciteSqlParser.queryRewrite(CalciteSqlParser.java:569))
```
Workaround is to use CTE & multistage = true
```sql
with DIST as (
SELECT
ProductId,
Summary,
Score,
l2_distance(ARRAY[0.1,0.1,0.3,0.4],ARRAY[0.1,0.1,0.3,0.4]) AS l2_dist
from fineFoodReviews
)
select * from DIST
where l2_dist < .6
order by l2_dist asc
```
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
