[
https://issues.apache.org/jira/browse/KYLIN-6041?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
liyang closed KYLIN-6041.
-------------------------
close as kylin 5.0.2 released
> 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
> Assignee: Guoliang Sun
> Priority: Major
> Fix For: 5.0.2
>
>
> 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)
