Github user eminency commented on a diff in the pull request:
https://github.com/apache/tajo/pull/677#discussion_r37380187
--- Diff: tajo-docs/src/main/sphinx/partitioning/define_partition_table.rst
---
@@ -0,0 +1,73 @@
+*********************************
+Define Partition Table
+*********************************
+
+Tajo makes it easy to specify an automatic partition scheme when the table
is created.
+
+================================================
+How to Create Partitione Table
+================================================
+
+You can create a partitioned table by using the ``PARTITION BY`` clause.
For a column partitioned table, you should use
+the ``PARTITION BY COLUMN`` clause with partition keys.
+
+For example, assume there is a table ``student`` composed of the following
schema.
+
+.. code-block:: sql
+
+ id INT,
+ name TEXT,
+ grade TEXT
+
+Now you want to partition on country. Your Tajo definition would be this:
+
+.. code-block:: sql
+
+ CREATE TABLE student (
+ id INT,
+ name TEXT,
+ grade TEXT
+ ) PARTITION BY COLUMN (country TEXT);
+
+Now your users will still query on ``WHERE country = '...'`` but the 2nd
column will be the original values.
+Here's an example statement to create a table:
+
+.. code-block:: sql
+
+ CREATE TABLE student (
+ id INT,
+ name TEXT,
+ grade TEXT
+ ) USING PARQUET
+ PARTITION BY COLUMN (country TEXT, city TEXT);
+
+The statement above creates the student table with id, name, grade. The
table is also partitioned and data is stored in parquet files.
--- End diff --
Is 'parquet files' right?
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---
