Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-945

INSERT column reordering doesn't work with SELECT clause

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: Impala 1.3
    • Fix Version/s: Impala 1.3.1
    • Component/s: None
    • Labels:
      None

      Description

      create table perm(a int, b string);
      insert into perm(b, a) values("str", 1);
      select * from perm;
      Query: select * from perm
      ERRORS: 
      Backend 0:Error converting column: 0 TO INT (Data is: foo)
      file: hdfs://localhost:20500/test-warehouse/hank.db/perm/a3434a92e7916052-a3961350052f90b6_768277005_data.0
      record: foo 2
      
      +------+---+
      | a    | b |
      +------+---+
      | NULL | 2 |
      +------+---+
      ERRORS: 
      Backend 0:Error converting column: 0 TO INT (Data is: foo)
      file: hdfs://localhost:20500/test-warehouse/hank.db/perm/a3434a92e7916052-a3961350052f90b6_768277005_data.0
      record: foo 2
      

      Analysis is fine, but the columns aren't getting permuted correctly in the backend.

        Attachments

          Activity

            People

            • Assignee:
              henryr Henry Robinson
              Reporter:
              henryr Henry Robinson
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: