[
https://issues.apache.org/jira/browse/TAJO-997?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hyunsik Choi resolved TAJO-997.
-------------------------------
Resolution: Won't Fix
It was already resolved.
> Shifted columns after ALTER TABLE ADD COLUMN new_column
> -------------------------------------------------------
>
> Key: TAJO-997
> URL: https://issues.apache.org/jira/browse/TAJO-997
> Project: Tajo
> Issue Type: Bug
> Affects Versions: 0.9.0
> Environment: Tajo version: 0.9.0-SNAPSHOT
> Compiled at 2014-07-27T17:32Z
> Java version: 1.7.0_51
> Reporter: Christian Schwabe
> Assignee: Hyunsik Choi
>
> 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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
