You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Steve Carlin (Jira)" <ji...@apache.org> on 2026/04/20 16:04:00 UTC
[jira] [Commented] (IMPALA-14192) SqlValidatorException: Invalid number of arguments to function 'ILIKE'. Was expecting 0 arguments
[ https://issues.apache.org/jira/browse/IMPALA-14192?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18074911#comment-18074911 ]
Steve Carlin commented on IMPALA-14192:
---------------------------------------
This will fallback to the original planner for v1
This should be supported in V2
> SqlValidatorException: Invalid number of arguments to function 'ILIKE'. Was expecting 0 arguments
> -------------------------------------------------------------------------------------------------
>
> Key: IMPALA-14192
> URL: https://issues.apache.org/jira/browse/IMPALA-14192
> Project: IMPALA
> Issue Type: Sub-task
> Reporter: weihua zhang
> Priority: Major
>
> {code:sql}
> SELECT 'huahua' ILIKE '%han%'
> 2025-06-27 03:57:08 [Exception] ERROR: Query 524963f4bf25a562:c84ba73900000000 failed:
> AnalysisException: From line 1, column 8 to line 1, column 31: Invalid number of arguments to function 'ILIKE'. Was expecting 0 arguments
> CAUSED BY: SqlValidatorException: Invalid number of arguments to function 'ILIKE'. Was expecting 0 arguments
> SELECT 'huahua' not ILIKE '%han%';
> AnalysisException: From line 1, column 8 to line 1, column 34: No match found for function signature NOT ILIKE
> CAUSED BY: SqlValidatorException: No match found for function signature NOT ILIKE
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org