hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pengcheng Xiong (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-8501) Fix CBO to use indexes when GenericUDFBridge is applied
Date Fri, 17 Oct 2014 21:22:34 GMT

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

Pengcheng Xiong commented on HIVE-8501:
---------------------------------------

it is confirmed that index is used/not used in

alter_concatenate_indexed_table.q,alter_index.q,authorization_index.q,drop_index_removes_partition_dirs.q,index_auth.q,index_auto.q,index_auto_empty.q,index_auto_file_format.q,index_auto_mult_tables.q,index_auto_mult_tables_compact.q,index_auto_multiple.q,index_auto_partitioned.q,index_auto_self_join.q,index_auto_unused.q,index_auto_update.q,index_bitmap.q,index_bitmap1.q,index_bitmap2.q,index_bitmap3.q,index_bitmap_auto.q,index_bitmap_auto_partitioned.q,index_bitmap_compression.q,index_bitmap_rc.q,index_compact.q,index_compact_1.q,index_compact_2.q,index_compact_3.q,index_compact_binary_search.q,index_compression.q,index_creation.q,index_serde.q,index_stale.q,index_stale_partitioned.q,show_indexes_edge_cases.q,show_indexes_syntax.q,udf_index.q

> Fix CBO to use indexes when GenericUDFBridge is applied 
> --------------------------------------------------------
>
>                 Key: HIVE-8501
>                 URL: https://issues.apache.org/jira/browse/HIVE-8501
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: Pengcheng Xiong
>            Assignee: Pengcheng Xiong
>            Priority: Minor
>         Attachments: HIVE-8501.1.patch
>
>
> previous https://issues.apache.org/jira/browse/HIVE-8389 assumes that
> we have predicate: ((UDFToDouble(key) > UDFToDouble(80)) and (UDFToDouble(key) <
UDFToDouble(100))) for example.
> This does not work for the case when we have predicate: ((UDFToDouble(key) > 80.0)
and (UDFToDouble(key) < 100.0))



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message