You are viewing a plain text version of this content. The canonical link for it is here.
Posted to reviews@spark.apache.org by "haoyanzhang (via GitHub)" <gi...@apache.org> on 2023/03/06 15:08:27 UTC

[GitHub] [spark] haoyanzhang opened a new pull request, #40298: [SPARK-42595][SQL] Support query inserted partitions after insert data into table when hive.exec.dynamic.partition=true

haoyanzhang opened a new pull request, #40298:
URL: https://github.com/apache/spark/pull/40298

   ### What changes were proposed in this pull request?
   
   Introduce spark.hive.exec.dynamic.partition.savePartitions=true (default false) spark.hive.exec.dynamic.partition.savePartitions.tableNamePrefix=hive_dynamic_inserted_partitions
   when spark.hive.exec.dynamic.partition.savePartitions=true we save the partitions to the 
   temporary view $spark.hive.exec.dynamic.partition.savePartitions.tableNamePrefix_$dbName_$tableName
   
   
   ### Why are the changes needed?
   
   When hive.exec.dynamic.partition=true and hive.exec.dynamic.partition.mode=nonstrict, we can insert table by sql like 'insert overwrite table aaa partition(dt) select xxxx',  of course we can know the partitions inserted into the table by the sql itself,  but if we want do something for common use, we need some common way to get the inserted partitions,  for example:
   
       spark.sql("insert overwrite table aaa partition(dt) select xxxx")  //insert table
       val partitions = getInsertedPartitions()   //need some way to get inserted partitions
       monitorInsertedPartitions(partitions)    //do something for common use
   This pull request will allow user to get inserted partitions in a common way
   
   ### Does this PR introduce _any_ user-facing change?
   no
   
   
   ### How was this patch tested?
   new unit test
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


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


[GitHub] [spark] github-actions[bot] closed pull request #40298: [SPARK-42595][SQL] Support query inserted partitions after insert data into table when hive.exec.dynamic.partition=true

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] closed pull request #40298: [SPARK-42595][SQL] Support query inserted partitions after insert data into table when hive.exec.dynamic.partition=true
URL: https://github.com/apache/spark/pull/40298


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


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


[GitHub] [spark] github-actions[bot] commented on pull request #40298: [SPARK-42595][SQL] Support query inserted partitions after insert data into table when hive.exec.dynamic.partition=true

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #40298:
URL: https://github.com/apache/spark/pull/40298#issuecomment-1592155333

   We're closing this PR because it hasn't been updated in a while. This isn't a judgement on the merit of the PR in any way. It's just a way of keeping the PR queue manageable.
   If you'd like to revive this PR, please reopen it and ask a committer to remove the Stale tag!


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


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