[KYLIN-5150] Query visualization does not support numeric fields as dimensions

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: v4.0.1
• Component/s: Query Engine
• Assignee: Unassigned
• Reporter: qingquanzhang
• Created: 10/Jan/22 09:38
• Updated: 12/Jan/22 05:38

Description

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:

 

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

 

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