[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)
[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 ] Bridget Bevens updated DRILL-7015: -- Fix Version/s: (was: 1.16.0) 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 > Fix For: 1.17.0 > > > 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 (v7.6.3#76005)