[
https://issues.apache.org/jira/browse/IGNITE-26156?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18018330#comment-18018330
]
Andrey Mashenkov edited comment on IGNITE-26156 at 9/5/25 9:14 AM:
-------------------------------------------------------------------
It's impossible to add subcommands for "ignite3 sql", because of picocli
limitations, when subcommand inherits all mandatory options of it's parent
command regardless of options scope preferences.
Suggest to convert current command to a subcommand, then add a new one
{code:java}
// Moved to subcommand: sql -> sql exec
ignite3 sql exec --jdbc-url <URL> <SQL query text>
// New command for planner cache invalidation
ignite3 sql planner invalidate-cache [-tables <table name>[,<table name>]]
[-nodes <node id>[,<node id>]]
{code}
was (Author: amashenkov):
It's impossible to add subcommands for "ignite3 sql", because of picocli
limitations, when subcommand inherits all mandatory options of it's parent
command regardless of options scope preferences.
{code:java}
Suggest to convert current command to a subcommand, then add a new one
// Moved to subcommand: sql -> sql exec
ignite3 sql exec --jdbc-url <URL> <SQL query text>
// New command for planner cache invalidation
ignite3 sql planner invalidate-cache [-tables <table name>[,<table name>]]
[-nodes <node id>[,<node id>]]
{code}
> Drop cached SQL plans through CLI and REST
> ------------------------------------------
>
> Key: IGNITE-26156
> URL: https://issues.apache.org/jira/browse/IGNITE-26156
> Project: Ignite
> Issue Type: Improvement
> Components: sql ai3
> Reporter: Iurii Gerzhedovich
> Assignee: Andrey Mashenkov
> Priority: Major
> Labels: ignite-3
> Time Spent: 10m
> Remaining Estimate: 0h
>
> Let's add as EXPERIMENTAL ability to drop cached SQL plans.
> Command for CLI can be like a
> {code:java}
> ignite3 sql plan-cache invalidate [--tables <table name>[,<table name>]]
> [--nodes <node id>[,<node id>]]
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
