Guoliang Sun created KYLIN-6041:
-----------------------------------
Summary: 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
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)
