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

Simple query with projection should be supported

    Details

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

      Description

      Tajo supports simple query as the following form:

      select * from tb1
      

      or

      select * from tb1 LIMIT N
      

      In many cases, users want to use some projections or functions like

      select x,y,z from tb1 LIMIT N
      

      This kind of queries are usually used to just see the data contents. Many users expect that this query will return the result immediately. But, the simple does not support this case. We need to support it.

        Activity

        Hide
        githubbot ASF GitHub Bot added a comment -

        GitHub user hyunsik opened a pull request:

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

        TAJO-1885: Simple query with projection should be supported.

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

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

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

        https://github.com/apache/tajo/pull/782.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 #782


        commit 148026af57ab058b441377262f7009c0f91d5ac2
        Author: Hyunsik Choi <hyunsik@apache.org>
        Date: 2015-09-24T05:44:54Z

        TAJO-1885: Simple query with projection should be supported.


        Show
        githubbot ASF GitHub Bot added a comment - GitHub user hyunsik opened a pull request: https://github.com/apache/tajo/pull/782 TAJO-1885 : Simple query with projection should be supported. You can merge this pull request into a Git repository by running: $ git pull https://github.com/hyunsik/tajo TAJO-1885 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/tajo/pull/782.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 #782 commit 148026af57ab058b441377262f7009c0f91d5ac2 Author: Hyunsik Choi <hyunsik@apache.org> Date: 2015-09-24T05:44:54Z TAJO-1885 : Simple query with projection should be supported.
        Hide
        githubbot ASF GitHub Bot added a comment -

        Github user blrunner commented on the pull request:

        https://github.com/apache/tajo/pull/782#issuecomment-143523930

        +1 LGTM.
        And it would be better if you commit this PR to 0.11.0 branch and master branch.

        Show
        githubbot ASF GitHub Bot added a comment - Github user blrunner commented on the pull request: https://github.com/apache/tajo/pull/782#issuecomment-143523930 +1 LGTM. And it would be better if you commit this PR to 0.11.0 branch and master branch.
        Hide
        githubbot ASF GitHub Bot added a comment -

        Github user asfgit closed the pull request at:

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

        Show
        githubbot ASF GitHub Bot added a comment - Github user asfgit closed the pull request at: https://github.com/apache/tajo/pull/782
        Hide
        hyunsik Hyunsik Choi added a comment -

        I just committed it to master branch and 0.11.0 branch.

        Show
        hyunsik Hyunsik Choi added a comment - I just committed it to master branch and 0.11.0 branch.
        Hide
        hudson Hudson added a comment -

        FAILURE: Integrated in Tajo-master-CODEGEN-build #542 (See https://builds.apache.org/job/Tajo-master-CODEGEN-build/542/)
        TAJO-1885: Simple query with projection should be supported. (hyunsik: rev cd01b739dfd0fd616e7dc75efc132793a30fcfab)

        • tajo-core-tests/src/test/resources/results/TestTajoCli/testNonForwardQueryPause.result
        • tajo-plan/src/main/java/org/apache/tajo/plan/util/PlannerUtil.java
        • tajo-core-tests/src/test/java/org/apache/tajo/cli/tsql/TestTajoCliNegatives.java
        • tajo-client/src/main/java/org/apache/tajo/client/QueryStatus.java
        • tajo-core-tests/src/test/java/org/apache/tajo/client/v2/TestTajoClientV2.java
        • tajo-core-tests/src/test/java/org/apache/tajo/client/TestTajoClient.java
        • tajo-core/src/main/java/org/apache/tajo/master/TajoMasterClientService.java
        • tajo-jdbc/src/test/java/org/apache/tajo/jdbc/TestTajoJdbcNegative.java
        • tajo-core/src/main/java/org/apache/tajo/master/exec/QueryExecutor.java
        • CHANGES
        • tajo-jdbc/src/test/java/org/apache/tajo/jdbc/TestTajoJdbc.java
        • tajo-core/src/main/java/org/apache/tajo/ws/rs/resources/QueryResultResource.java
        • tajo-core/src/main/java/org/apache/tajo/master/exec/NonForwardQueryResultFileScanner.java
        Show
        hudson Hudson added a comment - FAILURE: Integrated in Tajo-master-CODEGEN-build #542 (See https://builds.apache.org/job/Tajo-master-CODEGEN-build/542/ ) TAJO-1885 : Simple query with projection should be supported. (hyunsik: rev cd01b739dfd0fd616e7dc75efc132793a30fcfab) tajo-core-tests/src/test/resources/results/TestTajoCli/testNonForwardQueryPause.result tajo-plan/src/main/java/org/apache/tajo/plan/util/PlannerUtil.java tajo-core-tests/src/test/java/org/apache/tajo/cli/tsql/TestTajoCliNegatives.java tajo-client/src/main/java/org/apache/tajo/client/QueryStatus.java tajo-core-tests/src/test/java/org/apache/tajo/client/v2/TestTajoClientV2.java tajo-core-tests/src/test/java/org/apache/tajo/client/TestTajoClient.java tajo-core/src/main/java/org/apache/tajo/master/TajoMasterClientService.java tajo-jdbc/src/test/java/org/apache/tajo/jdbc/TestTajoJdbcNegative.java tajo-core/src/main/java/org/apache/tajo/master/exec/QueryExecutor.java CHANGES tajo-jdbc/src/test/java/org/apache/tajo/jdbc/TestTajoJdbc.java tajo-core/src/main/java/org/apache/tajo/ws/rs/resources/QueryResultResource.java tajo-core/src/main/java/org/apache/tajo/master/exec/NonForwardQueryResultFileScanner.java
        Hide
        hudson Hudson added a comment -

        SUCCESS: Integrated in Tajo-master-build #910 (See https://builds.apache.org/job/Tajo-master-build/910/)
        TAJO-1885: Simple query with projection should be supported. (hyunsik: rev cd01b739dfd0fd616e7dc75efc132793a30fcfab)

        • tajo-core-tests/src/test/java/org/apache/tajo/cli/tsql/TestTajoCliNegatives.java
        • tajo-core/src/main/java/org/apache/tajo/master/TajoMasterClientService.java
        • tajo-core/src/main/java/org/apache/tajo/ws/rs/resources/QueryResultResource.java
        • tajo-core/src/main/java/org/apache/tajo/master/exec/NonForwardQueryResultFileScanner.java
        • tajo-client/src/main/java/org/apache/tajo/client/QueryStatus.java
        • tajo-core-tests/src/test/java/org/apache/tajo/client/TestTajoClient.java
        • CHANGES
        • tajo-plan/src/main/java/org/apache/tajo/plan/util/PlannerUtil.java
        • tajo-core/src/main/java/org/apache/tajo/master/exec/QueryExecutor.java
        • tajo-core-tests/src/test/java/org/apache/tajo/client/v2/TestTajoClientV2.java
        • tajo-core-tests/src/test/resources/results/TestTajoCli/testNonForwardQueryPause.result
        • tajo-jdbc/src/test/java/org/apache/tajo/jdbc/TestTajoJdbc.java
        • tajo-jdbc/src/test/java/org/apache/tajo/jdbc/TestTajoJdbcNegative.java
        Show
        hudson Hudson added a comment - SUCCESS: Integrated in Tajo-master-build #910 (See https://builds.apache.org/job/Tajo-master-build/910/ ) TAJO-1885 : Simple query with projection should be supported. (hyunsik: rev cd01b739dfd0fd616e7dc75efc132793a30fcfab) tajo-core-tests/src/test/java/org/apache/tajo/cli/tsql/TestTajoCliNegatives.java tajo-core/src/main/java/org/apache/tajo/master/TajoMasterClientService.java tajo-core/src/main/java/org/apache/tajo/ws/rs/resources/QueryResultResource.java tajo-core/src/main/java/org/apache/tajo/master/exec/NonForwardQueryResultFileScanner.java tajo-client/src/main/java/org/apache/tajo/client/QueryStatus.java tajo-core-tests/src/test/java/org/apache/tajo/client/TestTajoClient.java CHANGES tajo-plan/src/main/java/org/apache/tajo/plan/util/PlannerUtil.java tajo-core/src/main/java/org/apache/tajo/master/exec/QueryExecutor.java tajo-core-tests/src/test/java/org/apache/tajo/client/v2/TestTajoClientV2.java tajo-core-tests/src/test/resources/results/TestTajoCli/testNonForwardQueryPause.result tajo-jdbc/src/test/java/org/apache/tajo/jdbc/TestTajoJdbc.java tajo-jdbc/src/test/java/org/apache/tajo/jdbc/TestTajoJdbcNegative.java
        Hide
        hudson Hudson added a comment -

        FAILURE: Integrated in Tajo-0.11.0-build #75 (See https://builds.apache.org/job/Tajo-0.11.0-build/75/)
        TAJO-1885: Simple query with projection should be supported. (hyunsik: rev eb9d5177747fd755021cc0767b0d286a6f7c061f)

        • tajo-core-tests/src/test/resources/results/TestTajoCli/testNonForwardQueryPause.result
        • tajo-core/src/main/java/org/apache/tajo/master/exec/NonForwardQueryResultFileScanner.java
        • CHANGES
        • tajo-core/src/main/java/org/apache/tajo/master/exec/QueryExecutor.java
        • tajo-plan/src/main/java/org/apache/tajo/plan/util/PlannerUtil.java
        • tajo-jdbc/src/test/java/org/apache/tajo/jdbc/TestTajoJdbc.java
        • tajo-core-tests/src/test/java/org/apache/tajo/cli/tsql/TestTajoCliNegatives.java
        • tajo-client/src/main/java/org/apache/tajo/client/QueryStatus.java
        • tajo-core-tests/src/test/java/org/apache/tajo/client/v2/TestTajoClientV2.java
        • tajo-core-tests/src/test/java/org/apache/tajo/client/TestTajoClient.java
        • tajo-core/src/main/java/org/apache/tajo/master/TajoMasterClientService.java
        • tajo-jdbc/src/test/java/org/apache/tajo/jdbc/TestTajoJdbcNegative.java
        • tajo-core/src/main/java/org/apache/tajo/ws/rs/resources/QueryResultResource.java
        Show
        hudson Hudson added a comment - FAILURE: Integrated in Tajo-0.11.0-build #75 (See https://builds.apache.org/job/Tajo-0.11.0-build/75/ ) TAJO-1885 : Simple query with projection should be supported. (hyunsik: rev eb9d5177747fd755021cc0767b0d286a6f7c061f) tajo-core-tests/src/test/resources/results/TestTajoCli/testNonForwardQueryPause.result tajo-core/src/main/java/org/apache/tajo/master/exec/NonForwardQueryResultFileScanner.java CHANGES tajo-core/src/main/java/org/apache/tajo/master/exec/QueryExecutor.java tajo-plan/src/main/java/org/apache/tajo/plan/util/PlannerUtil.java tajo-jdbc/src/test/java/org/apache/tajo/jdbc/TestTajoJdbc.java tajo-core-tests/src/test/java/org/apache/tajo/cli/tsql/TestTajoCliNegatives.java tajo-client/src/main/java/org/apache/tajo/client/QueryStatus.java tajo-core-tests/src/test/java/org/apache/tajo/client/v2/TestTajoClientV2.java tajo-core-tests/src/test/java/org/apache/tajo/client/TestTajoClient.java tajo-core/src/main/java/org/apache/tajo/master/TajoMasterClientService.java tajo-jdbc/src/test/java/org/apache/tajo/jdbc/TestTajoJdbcNegative.java tajo-core/src/main/java/org/apache/tajo/ws/rs/resources/QueryResultResource.java

          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