You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2022/10/18 02:22:28 UTC
[GitHub] [doris] zenyanggongmian1995 opened a new issue, #13431: [Bug] 无法正确识表别名
zenyanggongmian1995 opened a new issue, #13431:
URL: https://github.com/apache/doris/issues/13431
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues.
### Version
1.1.2.rc02
### What's Wrong?
无法正确识别表别名。
当我使用lateral view 侧视图时， 包含在侧视图内部的SQL语句，其中的表别名可以任意，SQL会正常跑，没有正确识别。
### What You Expected?
使别名可以正确识别
### How to Reproduce?
SELECT *
FROM (
SELECT
concat_ws('$', '1', xxapasdap_d.uv / 10000) AS uv,
concat_ws('$', '2', asdasapp_d.pv / 10000) AS pv,
concat_ws('$', '3', asdasdconapp_d.duration / 36000000) AS duration,
concat_ws('$', '24', arweepp_d.pv / app_d.uv) AS pv_capita,
concat_ws( '$', '25',app_d.duration / (app_d.uv * 3600)) AS duration_capita
FROM (SELECT * FROM test.test WHERE day_id = 20221016 AND uv IS NOT NULL) app_d
ORDER BY app_d.standard_app_id ) a lateral VIEW explode_split ( CONCAT_WS( ',', uv, pv, duration, pv_capita, duration_capita ), ',' ) tmp1 AS key_value
可以看见 我上面内层所有字段前的表别名都是随机写的，但是该SQL仍然可以运行，且结果是正确的。
### Anything Else?
_No response_
### Are you willing to submit PR?
- [ ] Yes I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
--
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: commits-unsubscribe@doris.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] dataalive closed issue #13431: [Bug] 无法正确识表别名
Posted by GitBox <gi...@apache.org>.
dataalive closed issue #13431: [Bug] 无法正确识表别名
URL: https://github.com/apache/doris/issues/13431
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] dataalive commented on issue #13431: [Bug] 无法正确识表别名
Posted by GitBox <gi...@apache.org>.
dataalive commented on issue #13431:
URL: https://github.com/apache/doris/issues/13431#issuecomment-1291418632
this issue has been fixed by https://github.com/apache/doris/pull/13600
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org