You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "pengfei.zhan (Jira)" <ji...@apache.org> on 2024/04/01 06:31:00 UTC
[jira] [Resolved] (KYLIN-5712) The database, table, column name in the model creation API are case-sensitive, resulting in an error when calling the API
[ https://issues.apache.org/jira/browse/KYLIN-5712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
pengfei.zhan resolved KYLIN-5712.
---------------------------------
Resolution: Fixed
> 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)