[
https://issues.apache.org/jira/browse/HIVE-13717?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Amey Barve updated HIVE-13717:
------------------------------
Description:
Custom storage-handler/s are able to get predicate information from hive for
'=', '!=', '<', '<=', '>' and '>=' operators.
But cannot get predicates information from hive for 'like', 'between' operators.
Eg:
final String expression = conf.get(TableScanDesc.FILTER_EXPR_CONF_STR);
here expression remains null for like and between operators but not null for
above operators.
custom storage handlers need information for predicate push down for these
operators.
Is there some other mechanism to get predicates for 'like' operator?
I tested with hive version 1.2 and 0.14.
Example query:
select col_string from datatypes1 where col_string = 'hello world' // here we
get information for predicate push down.
select col_string from datatypes1 where col_string like 'hello world' // No
information is obtained for predicate push down.
was:
Custom storage-handler/s are able to get predicate information from hive for
'=', '!=', '<', '<=', '>' and '>=' operators.
But cannot get predicates information from hive for 'like', 'between' operators.
Eg:
final String expression = conf.get(TableScanDesc.FILTER_EXPR_CONF_STR);
here expression remains null for like and between operators but not null for
above operators.
custom storage handlers need information for predicate push down for these
operators.
Is there some other mechanism to get predicates for 'like' operator?
I tested with hive version 1.2 and 0.14.
> Push Predicate information for 'like' and 'between' operators to custom
> storage handler.
> ----------------------------------------------------------------------------------------
>
> Key: HIVE-13717
> URL: https://issues.apache.org/jira/browse/HIVE-13717
> Project: Hive
> Issue Type: Bug
> Components: Query Processor
> Environment: TableScanDesc
> Reporter: Amey Barve
>
> Custom storage-handler/s are able to get predicate information from hive for
> '=', '!=', '<', '<=', '>' and '>=' operators.
> But cannot get predicates information from hive for 'like', 'between'
> operators.
> Eg:
> final String expression = conf.get(TableScanDesc.FILTER_EXPR_CONF_STR);
> here expression remains null for like and between operators but not null for
> above operators.
> custom storage handlers need information for predicate push down for these
> operators.
> Is there some other mechanism to get predicates for 'like' operator?
> I tested with hive version 1.2 and 0.14.
> Example query:
> select col_string from datatypes1 where col_string = 'hello world' // here we
> get information for predicate push down.
> select col_string from datatypes1 where col_string like 'hello world' // No
> information is obtained for predicate push down.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
