You are viewing a plain text version of this content. The canonical link for it is here.
Posted to reviews@spark.apache.org by GitBox <gi...@apache.org> on 2021/02/07 07:38:55 UTC

[GitHub] [spark] AngersZhuuuu opened a new pull request #31505: [SPARK-34174][SQL] Add 'SHOW PARTITIONS' as table-valued function

AngersZhuuuu opened a new pull request #31505:
URL: https://github.com/apache/spark/pull/31505


   ### What changes were proposed in this pull request?
   Add `SHOW PARTITIONS` as  table-valued function 'show_partitions'
   In origin, we can't directly analysis partition metadata information  in SQL, we need export it out and then analysis on it. 
   Now, we can just use SQL to do this.
   
   Analysis such as which partition is  lost? how many partitions in a partition value range etc
   
   ### Why are the changes needed?
   Make it convenient for user to analysis metadata
   
   
   ### Does this PR introduce _any_ user-facing change?
   User can use `show_partitions` table-valued function such as .
   
   ```
   sql("CREATE TABLE t(id INT) PARTITIONED BY (part STRING)")
   sql("INSERT OVERWRITE TABLE t PARTITION (part = '1') SELECT 1")
   sql("INSERT OVERWRITE TABLE t PARTITION (part = '2') SELECT 2")
   sql("SELECT * FROM show_partitions('t')").show()
   
   +---------+
   |partition|
   +---------+
   |   part=1|
   |   part=2|
   +---------+
   ```
   ### How was this patch tested?
   added UT
   


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

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] AmplabJenkins removed a comment on pull request #31505: [SPARK-34174][SQL] Add 'SHOW PARTITIONS' as table-valued function

Posted by GitBox <gi...@apache.org>.
AmplabJenkins removed a comment on pull request #31505:
URL: https://github.com/apache/spark/pull/31505#issuecomment-774655893


   
   Refer to this link for build results (access rights to CI server needed): 
   https://amplab.cs.berkeley.edu/jenkins//job/SparkPullRequestBuilder-K8s/39568/
   


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

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] AngersZhuuuu commented on pull request #31505: [SPARK-34174][SQL] Add 'SHOW PARTITIONS' as table-valued function

Posted by GitBox <gi...@apache.org>.
AngersZhuuuu commented on pull request #31505:
URL: https://github.com/apache/spark/pull/31505#issuecomment-787413485


   > Do other DBMSs support this as a built-in show_columns function? If then, could you update the PR description by adding those references?
   
   after a long time search, no other DBMS support this kind of functions. But it's really helpful for data analysis user to have a better insight  for metadata.


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

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] SparkQA commented on pull request #31505: [SPARK-34174][SQL] Add 'SHOW PARTITIONS' as table-valued function

Posted by GitBox <gi...@apache.org>.
SparkQA commented on pull request #31505:
URL: https://github.com/apache/spark/pull/31505#issuecomment-774668087


   **[Test build #134985 has finished](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/134985/testReport)** for PR 31505 at commit [`15f162e`](https://github.com/apache/spark/commit/15f162e86da7a732281e2a1b5bd5cd8b23aad2b4).
    * This patch passes all tests.
    * This patch merges cleanly.
    * This patch adds no public classes.


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

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] SparkQA commented on pull request #31505: [SPARK-34174][SQL] Add 'SHOW PARTITIONS' as table-valued function

Posted by GitBox <gi...@apache.org>.
SparkQA commented on pull request #31505:
URL: https://github.com/apache/spark/pull/31505#issuecomment-774639792


   Kubernetes integration test starting
   URL: https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder-K8s/39568/
   


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

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] AmplabJenkins commented on pull request #31505: [SPARK-34174][SQL] Add 'SHOW PARTITIONS' as table-valued function

Posted by GitBox <gi...@apache.org>.
AmplabJenkins commented on pull request #31505:
URL: https://github.com/apache/spark/pull/31505#issuecomment-774672361


   
   Refer to this link for build results (access rights to CI server needed): 
   https://amplab.cs.berkeley.edu/jenkins//job/SparkPullRequestBuilder/134985/
   


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

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] SparkQA commented on pull request #31505: [SPARK-34174][SQL] Add 'SHOW PARTITIONS' as table-valued function

Posted by GitBox <gi...@apache.org>.
SparkQA commented on pull request #31505:
URL: https://github.com/apache/spark/pull/31505#issuecomment-774651767


   Kubernetes integration test status failure
   URL: https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder-K8s/39568/
   


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

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] AmplabJenkins commented on pull request #31505: [SPARK-34174][SQL] Add 'SHOW PARTITIONS' as table-valued function

Posted by GitBox <gi...@apache.org>.
AmplabJenkins commented on pull request #31505:
URL: https://github.com/apache/spark/pull/31505#issuecomment-774655893


   
   Refer to this link for build results (access rights to CI server needed): 
   https://amplab.cs.berkeley.edu/jenkins//job/SparkPullRequestBuilder-K8s/39568/
   


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

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] SparkQA commented on pull request #31505: [SPARK-34174][SQL] Add 'SHOW PARTITIONS' as table-valued function

Posted by GitBox <gi...@apache.org>.
SparkQA commented on pull request #31505:
URL: https://github.com/apache/spark/pull/31505#issuecomment-774632659


   **[Test build #134985 has started](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/134985/testReport)** for PR 31505 at commit [`15f162e`](https://github.com/apache/spark/commit/15f162e86da7a732281e2a1b5bd5cd8b23aad2b4).


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

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] SparkQA removed a comment on pull request #31505: [SPARK-34174][SQL] Add 'SHOW PARTITIONS' as table-valued function

Posted by GitBox <gi...@apache.org>.
SparkQA removed a comment on pull request #31505:
URL: https://github.com/apache/spark/pull/31505#issuecomment-774632659


   **[Test build #134985 has started](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/134985/testReport)** for PR 31505 at commit [`15f162e`](https://github.com/apache/spark/commit/15f162e86da7a732281e2a1b5bd5cd8b23aad2b4).


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

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] AmplabJenkins removed a comment on pull request #31505: [SPARK-34174][SQL] Add 'SHOW PARTITIONS' as table-valued function

Posted by GitBox <gi...@apache.org>.
AmplabJenkins removed a comment on pull request #31505:
URL: https://github.com/apache/spark/pull/31505#issuecomment-774672361


   
   Refer to this link for build results (access rights to CI server needed): 
   https://amplab.cs.berkeley.edu/jenkins//job/SparkPullRequestBuilder/134985/
   


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

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 #31505: [SPARK-34174][SQL] Add 'SHOW PARTITIONS' as table-valued function

Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on pull request #31505:
URL: https://github.com/apache/spark/pull/31505#issuecomment-857274555


   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.

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 #31505: [SPARK-34174][SQL] Add 'SHOW PARTITIONS' as table-valued function

Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed pull request #31505:
URL: https://github.com/apache/spark/pull/31505


   


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

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