[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)
