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/05/13 07:28:08 UTC
[GitHub] [incubator-doris] gj-zhang opened a new issue, #9544: [Bug] After left join, there are two rows of the same key after group by
gj-zhang opened a new issue, #9544:
URL: https://github.com/apache/incubator-doris/issues/9544
### 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.0.0-rc03
### What's Wrong?
![image](https://user-images.githubusercontent.com/21170229/168232856-7f25c44d-9fd6-4645-8117-ef7403df9fd3.png)
### What You Expected?
result one row
### How to Reproduce?
```sql
CREATE TABLE `left_table`
(
`id` text NULL COMMENT "",
`device_id` text NULL COMMENT ""
) ENGINE = OLAP UNIQUE KEY(`id`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`id`) BUCKETS 4
PROPERTIES (
"replication_allocation" = "tag.location.default: 2",
"in_memory" = "false",
"storage_format" = "V2"
);
insert into left_table values ('1', '1'),('2', '2'), ('3', '3'), ('4', '4');
CREATE TABLE `right_table`
(
`device_id` text NULL COMMENT "",
`device_name` text NULL COMMENT ""
) ENGINE = OLAP UNIQUE KEY(`device_id`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`device_id`) BUCKETS 4
PROPERTIES (
"replication_allocation" = "tag.location.default: 2",
"in_memory" = "false",
"storage_format" = "V2"
);
insert into right_table values ('1', 'device_name1'), ('3', null);
select count(left_table.device_id), rt.device_name
from left_table
left join right_table rt
on left_table.device_id = rt.device_id
where rt.device_name is null
group by rt.device_name
order by rt.device_name nulls first
```
### 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] [incubator-doris] LOVEGISER commented on issue #9544: [Bug] After left join, there are two rows of the same key after group by
Posted by GitBox <gi...@apache.org>.
LOVEGISER commented on issue #9544:
URL: https://github.com/apache/incubator-doris/issues/9544#issuecomment-1125774002
1. i am run this sql command in Doris version 1.0.0-rc03-8b9a70c , the result is correct,try to update to this version.
mysql> select count(left_table.device_id), rt.device_name from left_table left join right_table rt
on left_table.device_id = rt.device_id where rt.device_name is null group by rt.device_name order by rt.device_name ;
+---------------------------------+-------------+
| count(`left_table`.`device_id`) | device_name |
+---------------------------------+-------------+
| 3 | NULL |
+---------------------------------+-------------+
1 row in set (0.03 sec)
--
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] [incubator-doris] HappenLee closed issue #9544: [Bug] After left join, there are two rows of the same key after group by
Posted by GitBox <gi...@apache.org>.
HappenLee closed issue #9544: [Bug] After left join, there are two rows of the same key after group by
URL: https://github.com/apache/incubator-doris/issues/9544
--
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] [incubator-doris] LOVEGISER commented on issue #9544: [Bug] After left join, there are two rows of the same key after group by
Posted by GitBox <gi...@apache.org>.
LOVEGISER commented on issue #9544:
URL: https://github.com/apache/incubator-doris/issues/9544#issuecomment-1125902786
1. I am test in version of 1.0.0-rc03-8b9a70c
2. use follow command to get 8b9a70c commit and rebuild
> git checkout 8b9a70c -b 1.0.0-rc03-8b9a70c
--
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] [incubator-doris] gj-zhang commented on issue #9544: [Bug] After left join, there are two rows of the same key after group by
Posted by GitBox <gi...@apache.org>.
gj-zhang commented on issue #9544:
URL: https://github.com/apache/incubator-doris/issues/9544#issuecomment-1127103206
Hello, 1.0.0-rc03-8b9a70c what I built with this tag
--
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] [incubator-doris] gj-zhang commented on issue #9544: [Bug] After left join, there are two rows of the same key after group by
Posted by GitBox <gi...@apache.org>.
gj-zhang commented on issue #9544:
URL: https://github.com/apache/incubator-doris/issues/9544#issuecomment-1128593454
> Hello, 1.0.0-rc03-8b9a70c what I built with this tag. and i merge #8822 code. Does it matter?
yes. i remove #8822 code. it works well.
--
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] [incubator-doris] cambyzju commented on issue #9544: [Bug] After left join, there are two rows of the same key after group by
Posted by GitBox <gi...@apache.org>.
cambyzju commented on issue #9544:
URL: https://github.com/apache/incubator-doris/issues/9544#issuecomment-1128682761
reproduce it with version(1.0.0-rc03-8b9a70c) while `set enable_vectorized_engine=true;`.
--
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] [incubator-doris] gj-zhang commented on issue #9544: [Bug] After left join, there are two rows of the same key after group by
Posted by GitBox <gi...@apache.org>.
gj-zhang commented on issue #9544:
URL: https://github.com/apache/incubator-doris/issues/9544#issuecomment-1125795426
>
how to get the code or binary file?
--
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