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

["Yaqian Zhang (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/KYLIN-5150?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17473270#comment-17473270 ] 

Yaqian Zhang commented on KYLIN-5150:
-------------------------------------

Hi [~qingquan]:

Kylin's visualization for query result is only a primary feature, and it does not make a deeper adaptation to various types of data. 
It is recommended to use external BI tools to connect Kylin for visualization.

> 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
>            Priority: Minor
>         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)