[
https://issues.apache.org/jira/browse/KYLIN-5712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hongrong Cao updated KYLIN-5712:
--------------------------------
Description:
The API call parameters are as follows
{quote}{
"project": "kylin_learn",
"fact_table": "SSB.LINEORDER",
"alias": "test_model_02",
"management_type": "MODEL_BASED",
"simplified_measures": [
{
"name": "COUNT_ALL",
"expression": "COUNT",
"parameter_value": [
{
"type": "constant",
"value": 1
}
],
"return_type": ""
}
],
"simplified_dimensions": [
{
"column": "LINEORDER.LO_ORDERKEY",
"name": "LO_ORDERKEY",
"status": "DIMENSION"
},
{
"column": "LINEORDER.LO_CUSTKEY",
"name": "LO_CUSTKEY",
"status": "DIMENSION"
},
{
"column": "LINEORDER.LO_ORDERDATE",
"name": "LO_ORDERDATE",
"status": "DIMENSION"
},
{
"column": "LINEORDER.LO_ORDERPRIOTITY",
"name": "LO_ORDERPRIOTITY",
"status": "DIMENSION"
},
{
"column": "LINEORDER.V_REVENUE",
"name": "V_REVENUE",
"status": "DIMENSION"
},
{
"column": "DATES.D_YEAR",
"name": "D_YEAR",
"status": "DIMENSION"
},
{
"column": "CUSTOMER.c_name",
"name": "c_name",
"status": "DIMENSION"
},
{
"column": "CUSTOMER.C_PHONE",
"name": "C_PHONE",
"status": "DIMENSION"
}
],
"join_tables": []
}
{quote}
normal result as follows
!image-2023-11-20-22-04-48-100.png|width=749,height=817!
The exceptions are as follows
!image-2023-11-20-22-05-41-142.png|width=907,height=802!
> The database, table, column name in the model creation API are
> case-sensitive, resulting in an error when calling the API
> -------------------------------------------------------------------------------------------------------------------------
>
> Key: KYLIN-5712
> URL: https://issues.apache.org/jira/browse/KYLIN-5712
> Project: Kylin
> Issue Type: Bug
> Affects Versions: 5.0-beta
> Reporter: Hongrong Cao
> Assignee: Hongrong Cao
> Priority: Minor
> Fix For: 5.0.0
>
> Attachments: image-2023-11-20-22-04-48-100.png,
> image-2023-11-20-22-05-41-142.png
>
>
> The API call parameters are as follows
> {quote}{
> "project": "kylin_learn",
> "fact_table": "SSB.LINEORDER",
> "alias": "test_model_02",
> "management_type": "MODEL_BASED",
> "simplified_measures": [
> {
> "name": "COUNT_ALL",
> "expression": "COUNT",
> "parameter_value": [
> {
> "type": "constant",
> "value": 1
> }
> ],
> "return_type": ""
> }
> ],
> "simplified_dimensions": [
> {
> "column": "LINEORDER.LO_ORDERKEY",
> "name": "LO_ORDERKEY",
> "status": "DIMENSION"
> },
> {
> "column": "LINEORDER.LO_CUSTKEY",
> "name": "LO_CUSTKEY",
> "status": "DIMENSION"
> },
> {
> "column": "LINEORDER.LO_ORDERDATE",
> "name": "LO_ORDERDATE",
> "status": "DIMENSION"
> },
> {
> "column": "LINEORDER.LO_ORDERPRIOTITY",
> "name": "LO_ORDERPRIOTITY",
> "status": "DIMENSION"
> },
> {
> "column": "LINEORDER.V_REVENUE",
> "name": "V_REVENUE",
> "status": "DIMENSION"
> },
> {
> "column": "DATES.D_YEAR",
> "name": "D_YEAR",
> "status": "DIMENSION"
> },
> {
> "column": "CUSTOMER.c_name",
> "name": "c_name",
> "status": "DIMENSION"
> },
> {
> "column": "CUSTOMER.C_PHONE",
> "name": "C_PHONE",
> "status": "DIMENSION"
> }
> ],
> "join_tables": []
> }
> {quote}
> normal result as follows
> !image-2023-11-20-22-04-48-100.png|width=749,height=817!
>
> The exceptions are as follows
> !image-2023-11-20-22-05-41-142.png|width=907,height=802!
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
