You are viewing a plain text version of this content. The canonical link for it is here.
Posted to gitbox@hive.apache.org by GitBox <gi...@apache.org> on 2021/06/14 09:25:12 UTC
[GitHub] [hive] zeroflag opened a new pull request #2390: HIVE-25242. Query performs extremely slow with vectorized.adaptor = chosen
zeroflag opened a new pull request #2390:
URL: https://github.com/apache/hive/pull/2390
If hive.vectorized.adaptor.usage.mode is set to chosen only certain UDFS are vectorized through the vectorized adaptor.
Queries like this one, performs very slowly because the concat is not chosen to be vectorized.
```
select count(*) from tbl where to_date(concat(year, '-', month, '-', day)) between to_date('2018-12-01') and to_date('2021-03-01');
```
--
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: gitbox-unsubscribe@hive.apache.org
For additional commands, e-mail: gitbox-help@hive.apache.org
[GitHub] [hive] zeroflag commented on pull request #2390: HIVE-25242. Query performs extremely slow with vectorized.adaptor = chosen
Posted by GitBox <gi...@apache.org>.
zeroflag commented on pull request #2390:
URL: https://github.com/apache/hive/pull/2390#issuecomment-861446954
retest this please
--
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: gitbox-unsubscribe@hive.apache.org
For additional commands, e-mail: gitbox-help@hive.apache.org
[GitHub] [hive] zeroflag commented on pull request #2390: HIVE-25242. Query performs extremely slow with vectorized.adaptor = chosen
Posted by GitBox <gi...@apache.org>.
zeroflag commented on pull request #2390:
URL: https://github.com/apache/hive/pull/2390#issuecomment-865088192
@pgaref yes, I added a note on the ticket about whitelisting the concat. The patch was tested by a customer and didn't report any side effects.
--
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: gitbox-unsubscribe@hive.apache.org
For additional commands, e-mail: gitbox-help@hive.apache.org
[GitHub] [hive] abstractdog commented on pull request #2390: HIVE-25242. Query performs extremely slow with vectorized.adaptor = chosen
Posted by GitBox <gi...@apache.org>.
abstractdog commented on pull request #2390:
URL: https://github.com/apache/hive/pull/2390#issuecomment-867493230
merged, thanks @zeroflag for the patch and @pgaref for the review!
--
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: gitbox-unsubscribe@hive.apache.org
For additional commands, e-mail: gitbox-help@hive.apache.org
[GitHub] [hive] zeroflag commented on pull request #2390: HIVE-25242. Query performs extremely slow with vectorized.adaptor = chosen
Posted by GitBox <gi...@apache.org>.
zeroflag commented on pull request #2390:
URL: https://github.com/apache/hive/pull/2390#issuecomment-865088192
@pgaref yes, I added a note on the ticket about whitelisting the concat. The patch was tested by a customer and didn't report any side effects.
--
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: gitbox-unsubscribe@hive.apache.org
For additional commands, e-mail: gitbox-help@hive.apache.org
[GitHub] [hive] abstractdog merged pull request #2390: HIVE-25242. Query performs extremely slow with vectorized.adaptor = chosen
Posted by GitBox <gi...@apache.org>.
abstractdog merged pull request #2390:
URL: https://github.com/apache/hive/pull/2390
--
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: gitbox-unsubscribe@hive.apache.org
For additional commands, e-mail: gitbox-help@hive.apache.org