[jira] [Commented] (HIVE-10936) incorrect result set when hive.vectorized.execution.enabled = true with predicate casting to CHAR or VARCHAR

["Mostafa Mokhtar (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-10936?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14574829#comment-14574829 ] 

Mostafa Mokhtar commented on HIVE-10936:
----------------------------------------

[~mmccline] FYI

> 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
>         Attachments: GO_TIME_DIM.zip
>
>
> 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)