[jira] [Updated] (ARROW-10574) [Python][Parquet] Enhance hive partition filtering

["Weiyang Zhao (Jira)" <ji...@apache.org>]

     [ 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 two 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 in 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. 

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 two 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. 

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
> --------------------------------------------------
>
>                 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 two 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 in 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. 
> 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)