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