You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@kylin.apache.org by "JiangYang (Jira)" <ji...@apache.org> on 2023/02/28 02:07:00 UTC

[jira] [Created] (KYLIN-5466) Support DDL and DML for kylin5

JiangYang created KYLIN-5466:
--------------------------------

             Summary: Support DDL and DML for kylin5 
                 Key: KYLIN-5466
                 URL: https://issues.apache.org/jira/browse/KYLIN-5466
             Project: Kylin
          Issue Type: New Feature
            Reporter: JiangYang
            Assignee: JiangYang


We try to support DDL and DML in kylin5:

DDL:  allow create cube by sql like:

 
{code:java}
// code placeholder
CREATE MATERIALIZED VIEW project_name.model_name AS
SELECT table1.c1_1,
       table1.c1_2,
       MAX(table1.c3),
       HLL_COUNT(table1.c4)
FROM 
 db1.table1 JOIN db2.table2
 ON table1.c1_1 = table2.c2_1
GROUP BY c1_1, c2_2; {code}
DML: support manipulate kylin job, model by sql

 

 

When both are supported ,  we can support more features in kylin5 JDBC. 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)