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/07/26 13:04:29 UTC
[GitHub] [doris] morrySnow opened a new issue, #11220: [Bug] throw exception: Unexpected exception: Failed analysis after expr substitution.
morrySnow opened a new issue, #11220:
URL: https://github.com/apache/doris/issues/11220
### 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
master
### What's Wrong?
throw exception: Unexpected exception: Failed analysis after expr substitution.
when use lateral view in subquery in where clause
### What You Expected?
execute query normally
### How to Reproduce?
```sql
CREATE TABLE `user_tag_bitmap` (
`tag_id` bigint(20) NULL COMMENT "标签id",
`hid` smallint(6) NULL COMMENT "分桶id",
`user_hash_bitmap` bitmap BITMAP_UNION NULL COMMENT ""
) ENGINE=OLAP
AGGREGATE KEY(`tag_id`, `hid`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`hid`) BUCKETS 3
PROPERTIES (
"replication_allocation" = "tag.location.default: 1",
"in_memory" = "false",
"storage_format" = "V2");
CREATE TABLE `tag_group_width` (
`device_id` varchar(128) NOT NULL COMMENT "设备id",
`user_hash` bigint(20) NOT NULL COMMENT "用户hash，通过对hash算法计算device_id生成",
`uuid` varchar(128) MAX NULL COMMENT "用户uuid",
`group_1` varchar(32) MAX NULL COMMENT "标签值"
) ENGINE=OLAP
AGGREGATE KEY(`device_id`, `user_hash`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`device_id`) BUCKETS 3
PROPERTIES (
"replication_allocation" = "tag.location.default: 1",
"in_memory" = "false",
"storage_format" = "V2"
);
select *
from tag_group_width
where user_hash in
(
select user_hash
from
(
select bitmap_intersect(user_hash_bitmap) as user_bm
from user_tag_bitmap
where tag_id in (20001, 30001) and hid=3) t
lateral view explode_bitmap(user_bm) tmp as user_hash
);
```
### Anything Else?
_No response_
### Are you willing to submit PR?
- [X] 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] kpfly commented on issue #11220: [Bug] throw exception: Unexpected exception: Failed analysis after expr substitution.
Posted by GitBox <gi...@apache.org>.
kpfly commented on issue #11220:
URL: https://github.com/apache/doris/issues/11220#issuecomment-1195479257
Does v1.1.1 have this bug?
--
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] yiguolei closed issue #11220: [Bug] throw exception: Unexpected exception: Failed analysis after expr substitution.
Posted by GitBox <gi...@apache.org>.
yiguolei closed issue #11220: [Bug] throw exception: Unexpected exception: Failed analysis after expr substitution.
URL: https://github.com/apache/doris/issues/11220
--
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] zdx0317 commented on issue #11220: [Bug] throw exception: Unexpected exception: Failed analysis after expr substitution.
Posted by "zdx0317 (via GitHub)" <gi...@apache.org>.
zdx0317 commented on issue #11220:
URL: https://github.com/apache/doris/issues/11220#issuecomment-1475539981
我也出现这个问题，Does v1.1.5修正这个bug了吗
--
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] morrySnow commented on issue #11220: [Bug] throw exception: Unexpected exception: Failed analysis after expr substitution.
Posted by GitBox <gi...@apache.org>.
morrySnow commented on issue #11220:
URL: https://github.com/apache/doris/issues/11220#issuecomment-1196238568
> Does v1.1.1 have this bug?
yes
--
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