You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "WangMeng (JIRA)" <ji...@apache.org> on 2015/09/18 15:08:04 UTC
[jira] [Updated] (HIVE-11880) IndexOutOfBoundsException when
execute query with filter condition on type incompatible column on
data(generated by UNION ALL with an union column is constant and it has
incompatible type with corresponding column)
[ https://issues.apache.org/jira/browse/HIVE-11880?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
WangMeng updated HIVE-11880:
----------------------------
Summary: IndexOutOfBoundsException when execute query with filter condition on type incompatible column on data(generated by UNION ALL with an union column is constant and it has incompatible type with corresponding column) (was: IndexOutOfBoundsException when execute query with filter condition on type incompatible column(A) on data(composed by UNION ALL when a union column is constant and it has incompatible type with corresponding column) )
> IndexOutOfBoundsException when execute query with filter condition on type incompatible column on data(generated by UNION ALL with an union column is constant and it has incompatible type with corresponding column)
> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: HIVE-11880
> URL: https://issues.apache.org/jira/browse/HIVE-11880
> Project: Hive
> Issue Type: Bug
> Components: Query Processor
> Affects Versions: 1.2.1
> Reporter: WangMeng
> Assignee: WangMeng
>
> For Hive UNION ALL , when a union column is constant(column a such as '0L') and it has incompatible type with the corresponding column A. The query with filter condition on type incompatible column a on this UNION-ALL results will cause IndexOutOfBoundsException
> Such as TPC-H table "orders", we CREATE VIEW `view_orders` AS select `oo`.`o_orderkey` , `oo`.`o_custkey` from ( select `orders`.`o_orderkey` , `rcfileorders`.`o_custkey` from `tpch270g`.`rcfileorders` union all select `orcfileorders`.`o_orderkey` , 0L as `o_custkey` from `tpch270g`.`textfileorders`) `oo`.
> Type of "o_custkey" is INT, the type of corresponding constant "0" is BIGINT.
> Then the fllowing query(with filter incompatible column 0_custkey) will fail with java.lang.IndexOutOfBoundsException:
> "select count(1) from view_orders where o_custkey<100000 ".
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)