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 "weihua zhang (Jira)" <ji...@apache.org> on 2025/06/27 11:39:00 UTC
[jira] [Updated] (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:all-tabpanel ]
weihua zhang updated IMPALA-14192:
----------------------------------
Description:
{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}
was:
{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
{code}
> 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