kyuubi
kyuubi copied to clipboard
[FEATURE] 支持算子血缘
Code of Conduct
- [X] I agree to follow this project's Code of Conduct
Search before asking
- [X] I have searched in the issues and found no similar issues.
Describe the feature
@iodone 需要知道输出表某个字段加工口径,例如 c = concat(a, ' ', b) ,血缘信息中保留c 的加工表达式。
Motivation
No response
Describe the solution
No response
Additional context
No response
Are you willing to submit PR?
- [ ] Yes I am willing to submit a PR!
能够找一个复杂的例子具体说明一下么?比如带有子查询的SQL,对应的加工方式应该如何表达。
能够找一个复杂的例子具体说明一下么?比如带有子查询的SQL,对应的加工方式应该如何表达。
参考一下sqlflow演示图,能否做到保留路径信息,以及加工表达式?
INSERT INTO t2(a, b)
SELECT
tt1.a AS a,
tt1.b AS b
FROM (
SELECT
a AS a,
MAX(b + c) as b
FROM t1
WHERE d > 1
) AS tt1
b -> tt1.b-> max(b+c)
https://sqlflow.gudusoft.com/#/
INSERT INTO t2(a, b)
SELECT
tt1.a AS a,
tt1.b AS b
FROM (
SELECT
a AS a,
MAX(t2.b, t1.c) as b
FROM (select sum(a) + sum(c) as b from t1 ) t2
WHERE d > 1
) AS tt1
类似这种更复杂,有分叉的该怎么描述,感觉这个flow过程还不如看逻辑计划来的更清楚
对于业务人员希望看到的时候图形化,sql 是有层次的,关联层次展现就可以。
@melin 我这边做了一个SQL可视化展示和编辑的功能,但是由于缺少前端开发人员,导致展现的不太好。感兴趣的可以一块开发.
![insert](https://user-images.githubusercontent.com/8545796/195344868-c571f56b-36d2-4a0f-9eb4-2b9f9b66b59c.png)
![image](https://user-images.githubusercontent.com/1145830/195369148-56f76a34-a6f2-4e54-889e-bd1e97af4d56.png)
实线是直接关系,虚线是间接关系,groupby having where 是间接关系
![]()
实线是直接关系,虚线是间接关系,groupby having where 是间接关系
还是大佬这个页面展示的牛逼