spark-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Wenchen Fan (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (SPARK-22676) Avoid iterating all partition paths when spark.sql.hive.verifyPartitionPath=true
Date Tue, 17 Apr 2018 13:54:00 GMT

     [ https://issues.apache.org/jira/browse/SPARK-22676?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Wenchen Fan resolved SPARK-22676.
---------------------------------
       Resolution: Fixed
    Fix Version/s: 2.4.0

Issue resolved by pull request 19868
[https://github.com/apache/spark/pull/19868]

> Avoid iterating all partition paths when spark.sql.hive.verifyPartitionPath=true
> --------------------------------------------------------------------------------
>
>                 Key: SPARK-22676
>                 URL: https://issues.apache.org/jira/browse/SPARK-22676
>             Project: Spark
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 2.2.0
>            Reporter: jin xing
>            Assignee: jin xing
>            Priority: Major
>             Fix For: 2.4.0
>
>
> In current code, it will scanning all partition paths when spark.sql.hive.verifyPartitionPath=true.
> e.g. table like below:
> CREATE TABLE `test`(
>   `id` int,
>   `age` int,
>   `name` string)
> PARTITIONED BY (
>   `A` string,
>   `B` string)
> load data local inpath '/tmp/data1' into table test partition(A='00', B='00')
> load data local inpath '/tmp/data1' into table test partition(A='01', B='01')
> load data local inpath '/tmp/data1' into table test partition(A='10', B='10')
> load data local inpath '/tmp/data1' into table test partition(A='11', B='11')
> If I query with SQL -- "select * from test where year=2017 and month=12 and day=03",
current code will scan all partition paths including '/data/A=00/B=00', '/data/A=00/B=00',
'/data/A=01/B=01', '/data/A=10/B=10', '/data/A=11/B=11'. It costs much time and memory cost.




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org


Mime
View raw message