Uploaded image for project: 'Tajo (Retired)'
  1. Tajo (Retired)
  2. TAJO-997

Shifted columns after ALTER TABLE ADD COLUMN new_column

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Won't Fix
    • 0.9.0
    • None
    • None
    • None
    • Tajo version: 0.9.0-SNAPSHOT
      Compiled at 2014-07-27T17:32Z
      Java version: 1.7.0_51

    Description

      As a source for sample data sets serve me in this case, the following source: http://tajo.apache.org/docs/0.8.0/getting_started/first_query.html#first-query-execution

      Below i describe my steps to reprodduce:

      >>First Step (original data set):<<
      default> SELECT * FROM table1;
      id, name, score, type
      -------------------------------
      1, abc, 1.1, a
      2, def, 2.3, b
      3, ghi, 3.4, c
      4, jkl, 4.5, d
      5, mno, 5.6, e
      (5 rows, 0.665 sec, 59 B selected)

      >>Second step (ALTER TABLE):<<
      default> ALTER TABLE table1 ADD COLUMN new_column text;
      OK

      >>Third step (show new structure):<<
      default> SELECT * FROM table1;
      id, new_column, name, score, type
      -------------------------------
      1, abc, 1.1, ,
      2, def, 2.3, ,
      3, ghi, 3.4, ,
      4, jkl, 4.5, ,
      5, mno, 5.6, ,
      (5 rows, 0.042 sec, 59 B selected)

      Logs:
      014-08-06 12:43:57,129 INFO org.apache.tajo.master.GlobalEngine: Query: ALTER TABLE table1 ADD COLUMN new_column text
      2014-08-06 12:43:57,139 INFO org.apache.tajo.master.GlobalEngine: Non Optimized Query:

      -----------------------------
      Query Block Graph
      -----------------------------

      -#ROOT
      -----------------------------
      Optimization Log:
      -----------------------------

      No Exception was thrown.

      Kind regards,
      Chris.

      P.S.: Sorry for that. It's my first time to report an issue. I hope I have made all the necessary information and have forgotten nothing.

      Attachments

        Issue Links

          Activity

            People

              hyunsik.choi Hyunsik Choi
              Christian Schwabe Christian Schwabe
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: