Uploaded image for project: 'Tajo'
  1. Tajo
  2. TAJO-1624

Add managed table or external description in Table management section

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.11.0
    • Component/s: Documentation
    • Labels:
      None

      Description

      See the title. This patch adds more description for table management section.

        Activity

        Hide
        githubbot ASF GitHub Bot added a comment -

        GitHub user hyunsik opened a pull request:

        https://github.com/apache/tajo/pull/588

        TAJO-1624: Add managed table or external description in Table managem…

        …ent section.

        You can merge this pull request into a Git repository by running:

        $ git pull https://github.com/hyunsik/tajo TAJO-1624

        Alternatively you can review and apply these changes as the patch at:

        https://github.com/apache/tajo/pull/588.patch

        To close this pull request, make a commit to your master/trunk branch
        with (at least) the following in the commit message:

        This closes #588


        commit 898107bd0816d34e35bccb7f936277c46f1638b3
        Author: Hyunsik Choi <hyunsik@apache.org>
        Date: 2015-05-27T02:49:53Z

        TAJO-1624: Add managed table or external description in Table management section.


        Show
        githubbot ASF GitHub Bot added a comment - GitHub user hyunsik opened a pull request: https://github.com/apache/tajo/pull/588 TAJO-1624 : Add managed table or external description in Table managem… …ent section. You can merge this pull request into a Git repository by running: $ git pull https://github.com/hyunsik/tajo TAJO-1624 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/tajo/pull/588.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #588 commit 898107bd0816d34e35bccb7f936277c46f1638b3 Author: Hyunsik Choi <hyunsik@apache.org> Date: 2015-05-27T02:49:53Z TAJO-1624 : Add managed table or external description in Table management section.
        Hide
        githubbot ASF GitHub Bot added a comment -

        Github user jihoonson commented on a diff in the pull request:

        https://github.com/apache/tajo/pull/588#discussion_r31194129

        — Diff: tajo-docs/src/main/sphinx/table_management/table_overview.rst —
        @@ -8,12 +8,36 @@ Overview
        Managed Table
        ================

        -.. todo::
        +``CREATE TABLE`` statement with ``EXTERNAL`` keyword lets you create a table located in the warehouse directory specified by the configuration property ``tajo.warehouse.directory`` or ``$

        {tajo.root}

        /warehouse`` by default. For example:
        +
        +.. code-block:: sql
        +
        + CREATE TABLE employee (
        + id int,
        + name text,
        + age
        + );
        +

        External Table
        ================

        -.. todo::
        +``CREATE EXTERNAL TABLE`` statement lets you create a table located in a specify location so that Tajo does not use a default data warehouse location for the table. External tables are in common used if you already have data generated. LOCATION clause must be required for an external table.
        +
        +.. code-block:: sql
        +
        + CREATE EXTERNAL TABLE employee (
        + id int,
        + name text,
        + age
        + ) LOCATION 'hdfs://table/path';
        +
        +
        +The location can be a directory located in HDFS, Amazon S3, HBase, or local file system (if a Tajo cluster runs in a single machine). URI examples are as follows:
        — End diff –

        Please add swift as a supported storage type.

        Show
        githubbot ASF GitHub Bot added a comment - Github user jihoonson commented on a diff in the pull request: https://github.com/apache/tajo/pull/588#discussion_r31194129 — Diff: tajo-docs/src/main/sphinx/table_management/table_overview.rst — @@ -8,12 +8,36 @@ Overview Managed Table ================ -.. todo:: +``CREATE TABLE`` statement with ``EXTERNAL`` keyword lets you create a table located in the warehouse directory specified by the configuration property ``tajo.warehouse.directory`` or ``$ {tajo.root} /warehouse`` by default. For example: + +.. code-block:: sql + + CREATE TABLE employee ( + id int, + name text, + age + ); + External Table ================ -.. todo:: +``CREATE EXTERNAL TABLE`` statement lets you create a table located in a specify location so that Tajo does not use a default data warehouse location for the table. External tables are in common used if you already have data generated. LOCATION clause must be required for an external table. + +.. code-block:: sql + + CREATE EXTERNAL TABLE employee ( + id int, + name text, + age + ) LOCATION 'hdfs://table/path'; + + +The location can be a directory located in HDFS, Amazon S3, HBase, or local file system (if a Tajo cluster runs in a single machine). URI examples are as follows: — End diff – Please add swift as a supported storage type.
        Hide
        githubbot ASF GitHub Bot added a comment -

        Github user jihoonson commented on the pull request:

        https://github.com/apache/tajo/pull/588#issuecomment-106122060

        +1. I left a trivial comment. Please reflect before commit.

        Show
        githubbot ASF GitHub Bot added a comment - Github user jihoonson commented on the pull request: https://github.com/apache/tajo/pull/588#issuecomment-106122060 +1. I left a trivial comment. Please reflect before commit.
        Hide
        githubbot ASF GitHub Bot added a comment -

        Github user asfgit closed the pull request at:

        https://github.com/apache/tajo/pull/588

        Show
        githubbot ASF GitHub Bot added a comment - Github user asfgit closed the pull request at: https://github.com/apache/tajo/pull/588
        Hide
        hudson Hudson added a comment -

        ABORTED: Integrated in Tajo-master-CODEGEN-build #364 (See https://builds.apache.org/job/Tajo-master-CODEGEN-build/364/)
        TAJO-1624: Add managed table or external description in Table management section. (hyunsik: rev 03294e1453586f64fe96458461f149851b443b42)

        • tajo-docs/src/main/sphinx/table_management/table_overview.rst
        • CHANGES
        Show
        hudson Hudson added a comment - ABORTED: Integrated in Tajo-master-CODEGEN-build #364 (See https://builds.apache.org/job/Tajo-master-CODEGEN-build/364/ ) TAJO-1624 : Add managed table or external description in Table management section. (hyunsik: rev 03294e1453586f64fe96458461f149851b443b42) tajo-docs/src/main/sphinx/table_management/table_overview.rst CHANGES
        Hide
        hudson Hudson added a comment -

        SUCCESS: Integrated in Tajo-master-build #724 (See https://builds.apache.org/job/Tajo-master-build/724/)
        TAJO-1624: Add managed table or external description in Table management section. (hyunsik: rev 03294e1453586f64fe96458461f149851b443b42)

        • CHANGES
        • tajo-docs/src/main/sphinx/table_management/table_overview.rst
        Show
        hudson Hudson added a comment - SUCCESS: Integrated in Tajo-master-build #724 (See https://builds.apache.org/job/Tajo-master-build/724/ ) TAJO-1624 : Add managed table or external description in Table management section. (hyunsik: rev 03294e1453586f64fe96458461f149851b443b42) CHANGES tajo-docs/src/main/sphinx/table_management/table_overview.rst

          People

          • Assignee:
            hyunsik Hyunsik Choi
            Reporter:
            hyunsik Hyunsik Choi
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development