You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Arina Ielchiieva (Jira)" <ji...@apache.org> on 2019/11/04 12:54:00 UTC
[jira] [Updated] (DRILL-7015) Improve documentation for PARTITION
BY
[ https://issues.apache.org/jira/browse/DRILL-7015?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Arina Ielchiieva updated DRILL-7015:
------------------------------------
Fix Version/s: (was: 1.17.0)
> Improve documentation for PARTITION BY
> --------------------------------------
>
> Key: DRILL-7015
> URL: https://issues.apache.org/jira/browse/DRILL-7015
> Project: Apache Drill
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 1.15.0
> Reporter: Boaz Ben-Zvi
> Assignee: Bridget Bevens
> Priority: Minor
>
> The documentation for CREATE TABLE AS (CTAS) shows the syntax of the command, without the optional PARTITION BY clause. That option is only mentioned later under the usage notes.
> *+_Suggestion_+*: Add this optional clause to the syntax (same as for CREATE TEMPORARY TABLE (CTTAS)). And mention that this option is only applicable when storing in Parquet.
> And the documentation for CREATE TEMPORARY TABLE (CTTAS), the comment says:
> {panel}
> An optional parameter that can *only* be used to create temporary tables with the Parquet data format.
> {panel}
> Which can mistakenly be understood as "only for temporary tables". *_+Suggestion+_*: erase the "to create temporary tables" part (not needed, as it is implied from the context of this page).
> *_+Last suggestion+_*: In the documentation for the PARTITION BY clause, can add an example using the implicit column "filename" to demonstrate how the partitioning column puts each distinct value into a separate file. For example, add in the "Other Examples" section :
> {noformat}
> 0: jdbc:drill:zk=local> select distinct r_regionkey, filename from mytable1;
> +--------------+----------------+
> | r_regionkey | filename |
> +--------------+----------------+
> | 2 | 0_0_3.parquet |
> | 1 | 0_0_2.parquet |
> | 0 | 0_0_1.parquet |
> | 3 | 0_0_4.parquet |
> | 4 | 0_0_5.parquet |
> +--------------+----------------+
> {noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)