You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@kyuubi.apache.org by GitBox <gi...@apache.org> on 2022/09/13 06:11:45 UTC
[GitHub] [incubator-kyuubi] melin opened a new issue, #3480: [FEATURE] 支持算子血缘
melin opened a new issue, #3480:
URL: https://github.com/apache/incubator-kyuubi/issues/3480
### Code of Conduct
- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
### Search before asking
- [X] I have searched in the [issues](https://github.com/apache/incubator-kyuubi/issues?q=is%3Aissue) 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!
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@kyuubi.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@kyuubi.apache.org
For additional commands, e-mail: notifications-help@kyuubi.apache.org
[GitHub] [incubator-kyuubi] gabrywu commented on issue #3480: [FEATURE] 支持算子血缘
Posted by GitBox <gi...@apache.org>.
gabrywu commented on issue #3480:
URL: https://github.com/apache/incubator-kyuubi/issues/3480#issuecomment-1277110203
> <img alt="image" width="876" src="https://user-images.githubusercontent.com/1145830/195369148-56f76a34-a6f2-4e54-889e-bd1e97af4d56.png">
>
> 实线是直接关系，虚线是间接关系，groupby having where 是间接关系 <img alt="image" width="996" src="https://user-images.githubusercontent.com/1145830/195368839-a1317739-820e-49dd-9628-46959c1daf11.png">
还是大佬这个页面展示的牛逼
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@kyuubi.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@kyuubi.apache.org
For additional commands, e-mail: notifications-help@kyuubi.apache.org
[GitHub] [incubator-kyuubi] melin commented on issue #3480: [FEATURE] 支持算子血缘
Posted by GitBox <gi...@apache.org>.
melin commented on issue #3480:
URL: https://github.com/apache/incubator-kyuubi/issues/3480#issuecomment-1246179374
> 能够找一个复杂的例子具体说明一下么？比如带有子查询的SQL，对应的加工方式应该如何表达。
参考一下sqlflow演示图，能否做到保留路径信息，以及加工表达式？
```sql
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/#/
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@kyuubi.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@kyuubi.apache.org
For additional commands, e-mail: notifications-help@kyuubi.apache.org
[GitHub] [incubator-kyuubi] gabrywu commented on issue #3480: [FEATURE] 支持算子血缘
Posted by GitBox <gi...@apache.org>.
gabrywu commented on issue #3480:
URL: https://github.com/apache/incubator-kyuubi/issues/3480#issuecomment-1276106934
like this?
<img width="390" alt="insert" src="https://user-images.githubusercontent.com/8545796/195344868-c571f56b-36d2-4a0f-9eb4-2b9f9b66b59c.png">
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@kyuubi.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@kyuubi.apache.org
For additional commands, e-mail: notifications-help@kyuubi.apache.org
[GitHub] [incubator-kyuubi] iodone commented on issue #3480: [FEATURE] 支持算子血缘
Posted by GitBox <gi...@apache.org>.
iodone commented on issue #3480:
URL: https://github.com/apache/incubator-kyuubi/issues/3480#issuecomment-1246128983
能够找一个复杂的例子具体说明一下么？比如带有子查询的SQL，对应的加工方式应该如何表达。
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@kyuubi.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@kyuubi.apache.org
For additional commands, e-mail: notifications-help@kyuubi.apache.org
[GitHub] [incubator-kyuubi] melin commented on issue #3480: [FEATURE] 支持算子血缘
Posted by GitBox <gi...@apache.org>.
melin commented on issue #3480:
URL: https://github.com/apache/incubator-kyuubi/issues/3480#issuecomment-1276265274
<img width="996" alt="image" src="https://user-images.githubusercontent.com/1145830/195368839-a1317739-820e-49dd-9628-46959c1daf11.png">
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@kyuubi.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@kyuubi.apache.org
For additional commands, e-mail: notifications-help@kyuubi.apache.org
[GitHub] [incubator-kyuubi] iodone commented on issue #3480: [FEATURE] 支持算子血缘
Posted by GitBox <gi...@apache.org>.
iodone commented on issue #3480:
URL: https://github.com/apache/incubator-kyuubi/issues/3480#issuecomment-1246288419
```
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过程还不如看逻辑计划来的更清楚
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@kyuubi.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@kyuubi.apache.org
For additional commands, e-mail: notifications-help@kyuubi.apache.org
[GitHub] [incubator-kyuubi] melin commented on issue #3480: [FEATURE] 支持算子血缘
Posted by GitBox <gi...@apache.org>.
melin commented on issue #3480:
URL: https://github.com/apache/incubator-kyuubi/issues/3480#issuecomment-1246383764
对于业务人员希望看到的时候图形化，sql 是有层次的，关联层次展现就可以。
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@kyuubi.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@kyuubi.apache.org
For additional commands, e-mail: notifications-help@kyuubi.apache.org