Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-2269

Cannot set ROW_NUMBER() on Transformation Editor

    Details

      Description

      This actually affects Teiid Designer 8.5.0.Final-v20140616-1350-B2658

      1. Create Teiid Model project using Teiid Designer.
      2. Import Flat File (I used VA.TXT from http://www.ssa.gov/oact/babynames/state/namesbystate.zip)
      3. Edit transformation on View model to:

      SELECT ROW_NUMBER() OVER (ORDER BY A.state) as id , A.name, A.state, A.gender, A.birthyear,  A.occurences FROM 
                  (EXEC file_source.getTextFiles('VA.TXT')) AS f,              
                  TEXTTABLE(f.file COLUMNS state string, gender char, birthyear integer, name string, occurences integer) AS A;
      

      4. Try to save. ROW_NUMBER() removed and ERROR: Parsing error: Encountered "OVER" at line xxx

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                mdrillin Mark Drilling
                Reporter:
                rlucente-se-jboss Rich Lucente
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: