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

Posted to dev@kylin.apache.org by "qingquanzhang (Jira)" <ji...@apache.org> on 2022/01/10 09:39:00 UTC

[jira] [Created] (KYLIN-5150) Query visualization does not support numeric fields as dimensions

qingquanzhang created KYLIN-5150:
------------------------------------

             Summary: Query visualization does not support numeric fields as dimensions
                 Key: KYLIN-5150
                 URL: https://issues.apache.org/jira/browse/KYLIN-5150
             Project: Kylin
          Issue Type: Bug
          Components: Query Engine
    Affects Versions: v4.0.1
            Reporter: qingquanzhang
         Attachments: Visualization of query results.png

Here are two tables:

table 1 ,dept:
||column||type||
|deptno|int|
|dname  | string|
|loc  |int|

table 2 ,emp:
||column||type||
||empno || int||
||ename||string||
||job  ||string||
||sal  ||double||
|deptno|  int|

sql:

 
{code:java}
select job,loc,sum(sal) sum_sal from emp e inner join dept d on d.deptno = e.deptno group by job,loc;{code}
 

When visualizing, kylin will use loc fields as metrics, not dimensions
 



--
This message was sent by Atlassian Jira
(v8.20.1#820001)