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

INSERT into a partitioned table as SELECT statement uses a wrong schema.

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.9.0
    • Component/s: None
    • Labels:
      None

      Description

      Currently Tajo uses a output schema for INSERT into partitioned table statement. In most cases, this should not be a problem. But, Parquet file occurs a error because Parquet file format has schema meta data itself.
      The result file of the following query has wrong column meta.

      create table parquet_test (col1 text, col2 text) using parquet;
      insert into select substr(col1, 1, 3) from table1;
      

        Activity

        Hide
        githubbot ASF GitHub Bot added a comment -

        GitHub user babokim opened a pull request:

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

        TAJO-977: INSERT into a partitioned table as SELECT statement uses a wrong schema.

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

        $ git pull https://github.com/babokim/tajo TAJO-977

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

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


        commit c42dae2673824f6ac743be31bc1ba541cf963d8f
        Author: 김형준 <babokim@babokim-mbp.server.gruter.com>
        Date: 2014-07-25T10:57:38Z

        TAJO-977: INSERT into a partitioned table as SELECT statement uses a wrong schema.


        Show
        githubbot ASF GitHub Bot added a comment - GitHub user babokim opened a pull request: https://github.com/apache/tajo/pull/95 TAJO-977 : INSERT into a partitioned table as SELECT statement uses a wrong schema. You can merge this pull request into a Git repository by running: $ git pull https://github.com/babokim/tajo TAJO-977 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/tajo/pull/95.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 #95 commit c42dae2673824f6ac743be31bc1ba541cf963d8f Author: 김형준 <babokim@babokim-mbp.server.gruter.com> Date: 2014-07-25T10:57:38Z TAJO-977 : INSERT into a partitioned table as SELECT statement uses a wrong schema.
        Hide
        githubbot ASF GitHub Bot added a comment -

        Github user hyunsik commented on the pull request:

        https://github.com/apache/tajo/pull/95#issuecomment-50231900

        +1
        The patch and unit test look good to me.

        Show
        githubbot ASF GitHub Bot added a comment - Github user hyunsik commented on the pull request: https://github.com/apache/tajo/pull/95#issuecomment-50231900 +1 The patch and unit test look good to me.
        Hide
        hyunsik Hyunsik Choi added a comment -

        committed it to master branch.

        Show
        hyunsik Hyunsik Choi added a comment - committed it to master branch.
        Hide
        githubbot ASF GitHub Bot added a comment -

        Github user asfgit closed the pull request at:

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

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

        SUCCESS: Integrated in Tajo-master-build #314 (See https://builds.apache.org/job/Tajo-master-build/314/)
        TAJO-977: INSERT into a partitioned table as SELECT statement uses a wrong schema. (Hyoungjun Kim via hyunsik) (hyunsik: rev 9880f06fd9e13402593a48a834df972e5b170fe2)

        • tajo-core/src/main/java/org/apache/tajo/engine/planner/physical/ColPartitionStoreExec.java
        • CHANGES
        • tajo-core/src/test/java/org/apache/tajo/engine/query/TestInsertQuery.java
        Show
        hudson Hudson added a comment - SUCCESS: Integrated in Tajo-master-build #314 (See https://builds.apache.org/job/Tajo-master-build/314/ ) TAJO-977 : INSERT into a partitioned table as SELECT statement uses a wrong schema. (Hyoungjun Kim via hyunsik) (hyunsik: rev 9880f06fd9e13402593a48a834df972e5b170fe2) tajo-core/src/main/java/org/apache/tajo/engine/planner/physical/ColPartitionStoreExec.java CHANGES tajo-core/src/test/java/org/apache/tajo/engine/query/TestInsertQuery.java

          People

          • Assignee:
            hjkim Hyoungjun Kim
            Reporter:
            hjkim Hyoungjun Kim
          • Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development