N Campbell created HIVE-10936:
---------------------------------
Summary: incorrect result set when
hive.vectorized.execution.enabled = true with predicate casting to CHAR or
VARCHAR
Key: HIVE-10936
URL: https://issues.apache.org/jira/browse/HIVE-10936
Project: Hive
Issue Type: Bug
Components: Hive
Affects Versions: 0.14.0
Environment: In this case using HDP install of Hive - 0.14.0.2.2.4.2-2
Reporter: N Campbell
Query returns data when set hive.vectorized.execution.enabled = false -or- if
target of CAST is STRING and not CHAR/VARCHAR
set hive.vectorized.execution.enabled = true;
select
`GO_TIME_DIM`.`day_key`
from
`gosalesdw1021`.`go_time_dim` `GO_TIME_DIM`
where
CAST(`GO_TIME_DIM`.`current_year` AS CHAR(4)) = '2010'
group by
`GO_TIME_DIM`.`day_key`;
create table GO_TIME_DIM ( DAY_KEY int , DAY_DATE timestamp , MONTH_KEY int ,
CURRENT_MONTH smallint , MONTH_NUMBER int , QUARTER_KEY int , CURRENT_QUARTER
smallint , CURRENT_YEAR smallint , DAY_OF_WEEK smallint , DAY_OF_MONTH smallint
, DAYS_IN_MONTH smallint , DAY_OF_YEAR smallint , WEEK_OF_MONTH smallint ,
WEEK_OF_QUARTER smallint , WEEK_OF_YEAR smallint , MONTH_EN string , WEEKDAY_EN
string , MONTH_DE string , WEEKDAY_DE string , MONTH_FR string , WEEKDAY_FR
string , MONTH_JA string , WEEKDAY_JA string , MONTH_AR string , WEEKDAY_AR
string , MONTH_CS string , WEEKDAY_CS string , MONTH_DA string , WEEKDAY_DA
string , MONTH_EL string , WEEKDAY_EL string , MONTH_ES string , WEEKDAY_ES
string , MONTH_FI string , WEEKDAY_FI string , MONTH_HR string , WEEKDAY_HR
string , MONTH_HU string , WEEKDAY_HU string , MONTH_ID string , WEEKDAY_ID
string , MONTH_IT string , WEEKDAY_IT string , MONTH_KK string , WEEKDAY_KK
string , MONTH_KO string , WEEKDAY_KO string , MONTH_MS string , WEEKDAY_MS
string , MONTH_NL string , WEEKDAY_NL string , MONTH_NO string , WEEKDAY_NO
string , MONTH_PL string , WEEKDAY_PL string , MONTH_PT string , WEEKDAY_PT
string , MONTH_RO string , WEEKDAY_RO string , MONTH_RU string , WEEKDAY_RU
string , MONTH_SC string , WEEKDAY_SC string , MONTH_SL string , WEEKDAY_SL
string , MONTH_SV string , WEEKDAY_SV string , MONTH_TC string , WEEKDAY_TC
string , MONTH_TH string , WEEKDAY_TH string , MONTH_TR string , WEEKDAY_TR
string )
ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n'
STORED AS TEXTFILE
LOCATION '....../GO_TIME_DIM';
Then create an ORC equivalent table and load it
insert overwrite table
GO_TIME_DIM
select * from TEXT.GO_TIME_DIM
;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
