[
https://issues.apache.org/jira/browse/HIVE-10936?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
N Campbell updated HIVE-10936:
------------------------------
Attachment: GO_TIME_DIM.zip
> 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)
