[
https://issues.apache.org/jira/browse/KYLIN-6041?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17930127#comment-17930127
]
ASF GitHub Bot commented on KYLIN-6041:
---------------------------------------
lionelcao merged PR #2291:
URL: https://github.com/apache/kylin/pull/2291
> When using the SQL acceleration interface to accelerate multiple SQL queries,
> the interface returns success, but no indexes are generated
> -----------------------------------------------------------------------------------------------------------------------------------------
>
> Key: KYLIN-6041
> URL: https://issues.apache.org/jira/browse/KYLIN-6041
> Project: Kylin
> Issue Type: Bug
> Affects Versions: 5.0.0
> Reporter: Guoliang Sun
> Priority: Major
>
> The API request succeeds, but no indexes are generated on the page.
> When sending a single SQL query, indexes are successfully generated in the
> index list.
> When `accept_recommendation` is set to `false`, the optimization suggestion
> list displays two recommended indexes.
> h3. Local Reproduction Steps
> 1. Create a new model `lineorder` with a base detail index.
> 2. Use the following API to send a request. The response indicates that two
> aggregation indexes have been added, but the index list does not reflect the
> new indexes.
>
> {code:java}
> curl --location --request POST
> 'http://ip:port/kylin/api/models/model_optimization' \
> --header 'Accept: application/vnd.apache.kylin-v4-public+json' \
> --header 'Accept-Language: en' \
> --header 'Authorization: Basic QURNSU46S1lMSU4=' \
> --header 'Content-Type: application/json;charset=utf-8' \
> --header 'Cookie:
> 595a13bd50743a411ff0342be87321b96a5568c535dbbe426f4e311b63911c40=MWVmYTZjOWYtNDUxMS00OGU2LThkNmQtYWFhNWI4YWUzNWJm'
> \
> --data-raw '{"project":"test",
> "sqls": ["select LO_ORDERDATE from ssb.lineorder group by LO_ORDERDATE","
> select * from ( select LO_CUSTKEY , LO_ORDERKEY , LO_PARTKEY,
> sum(LO_REVENUE-LO_TAX) from ssb.lineorder group by LO_CUSTKEY , LO_ORDERKEY ,
> LO_PARTKEY union all (select C_CUSTKEY as C_CUSTKEY, C_CITY as C_CITY,
> C_PHONE as C_PHONE, C_REGION as C_REGION from SSB.customer) )"],
> "discard_table_index":true,
> "accept_recommendation":true}'{code}
>
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
