[
https://issues.apache.org/jira/browse/ARROW-10574?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Weiyang Zhao updated ARROW-10574:
---------------------------------
Description:
I would like to enhance partition filters in methods such as:
{{pyarrow.parquet.ParquetDataset(path, filters)}}
I am proposing the below enhancements:
# for operator "in", "not in", the value should be any typing.Container. But
currently only set is supported while other containers, such as list, tuple
cannot function correctly. I would like to change it to accept any container.
# I would like to add a 'like' operator which has a semantics of a sql like.
Alternatively, a regular expression can be used. I prefer sql like semantics
for reasons to achieve sql consistency.
# Enhance the documents about the partition filters.
I have already made the changes and test cases locally. Once this is approved,
I can submit it.
Thank you.
was:
I would like to enhance partition filters in methods such as:
{{pyarrow.parquet.ParquetDataset(path, filters)}}
I am proposing the below enhancements:
# for operator "in", "not in", the value currently must be a set. My
experience is that if I passed in a list, it will simply not result any values
without good warning. I would like to change it to accept any Iterable, which
includes set, list, tuple and etc. but not strings. Internally I will construct
a set from the Iterable to avoid duplicate elements.
# I would like to add a 'like' operator which has a semantics of a sql like.
Alternatively, a regular expression can be used. I prefer sql like semantics
for reasons to achieve sql consistency.
# Enhance the documents about the partition filters.
I have already made the changes and test cases locally. Once this is approved,
I can submit it.
Thank you.
> [Python][Parquet] Enhance hive partition filtering with 'like' operator
> -----------------------------------------------------------------------
>
> Key: ARROW-10574
> URL: https://issues.apache.org/jira/browse/ARROW-10574
> Project: Apache Arrow
> Issue Type: Improvement
> Components: Python
> Reporter: Weiyang Zhao
> Assignee: Weiyang Zhao
> Priority: Major
>
> I would like to enhance partition filters in methods such as:
> {{pyarrow.parquet.ParquetDataset(path, filters)}}
> I am proposing the below enhancements:
> # for operator "in", "not in", the value should be any typing.Container. But
> currently only set is supported while other containers, such as list, tuple
> cannot function correctly. I would like to change it to accept any container.
> # I would like to add a 'like' operator which has a semantics of a sql like.
> Alternatively, a regular expression can be used. I prefer sql like semantics
> for reasons to achieve sql consistency.
> # Enhance the documents about the partition filters.
> I have already made the changes and test cases locally. Once this is
> approved, I can submit it.
>
> Thank you.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
