[
https://issues.apache.org/jira/browse/KYLIN-5150?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17474259#comment-17474259
]
qingquanzhang commented on KYLIN-5150:
--------------------------------------
Hi,[Yaqian
Zhang|https://issues.apache.org/jira/secure/ViewProfile.jspa?name=zhangyaqian]
I see, thanks for the answer!:)
> 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)
