You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Krisztian Kasa (Jira)" <ji...@apache.org> on 2023/04/14 09:04:00 UTC
[jira] [Created] (HIVE-27264) Literals in conjunction of two in expression are considered not equals if type precision is different
Krisztian Kasa created HIVE-27264:
-------------------------------------
Summary: Literals in conjunction of two in expression are considered not equals if type precision is different
Key: HIVE-27264
URL: https://issues.apache.org/jira/browse/HIVE-27264
Project: Hive
Issue Type: Bug
Components: CBO
Reporter: Krisztian Kasa
Assignee: Krisztian Kasa
{code}
create table r_table (
string_col varchar(30)
);
create table l_table (
string_col varchar(14)
);
insert into r_table VALUES ('AAA111');
insert into l_table VALUES ('AAA111');
SELECT l_table.string_col from l_table, r_table
WHERE r_table.string_col = l_table.string_col AND l_table.string_col IN ('AAA111', 'BBB222') AND r_table.string_col IN ('AAA111', 'BBB222');
{code}
Should give one row
{code}
AAA111
{code}
but it returns empty rs
Workaround
{code}
set hive.optimize.point.lookup=false;
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)