[
https://issues.apache.org/jira/browse/HIVE-24666?focusedWorklogId=553268&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-553268
]
ASF GitHub Bot logged work on HIVE-24666:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 17/Feb/21 00:07
Start Date: 17/Feb/21 00:07
Worklog Time Spent: 10m
Work Description: dengzhhu653 closed pull request #1890:
URL: https://github.com/apache/hive/pull/1890
----------------------------------------------------------------
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:
us...@infra.apache.org
Issue Time Tracking
-------------------
Worklog Id: (was: 553268)
Time Spent: 40m (was: 0.5h)
> Vectorized UDFToBoolean may unable to filter rows if input is string
> --------------------------------------------------------------------
>
> Key: HIVE-24666
> URL: https://issues.apache.org/jira/browse/HIVE-24666
> Project: Hive
> Issue Type: Bug
> Components: Vectorization
> Reporter: Zhihua Deng
> Assignee: Zhihua Deng
> Priority: Minor
> Labels: pull-request-available
> Fix For: 4.0.0
>
> Attachments: HIVE-24666.2.patch
>
> Time Spent: 40m
> Remaining Estimate: 0h
>
> If we use cast boolean to filter rows, in vectorization mode the filter may
> be unable to filter rows, step to reproduce:
> {code:java}
> create table vtb (key string, value string);
> insert into table vtb values('0', 'val0'), ('false', 'valfalse'),('off',
> 'valoff'),('no','valno'),('vk', 'valvk');
> select distinct value from vtb where cast(key as boolean); {code}
> It's seems we don't generate a SelectColumnIsTrue to filter the rows if the
> casted type is string:
>
> [https://github.com/apache/hive/blob/ff6f3565e50148b7bcfbcf19b970379f2bd59290/ql/src/java/org/apache/hadoop/hive/ql/exec/vector/VectorizationContext.java#L2995-L2996]
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
