Rename

Renames attributes of a relation.

Usage

rename (indata, attr-map : outdata)

Details

Uses attr-map to rename columns of indata and outputs the result as outdata. The map is a comma-delimited string of "old new" (see example, below).

Notes

None.

Known Bugs

None.

Example

Using the input:

      RELATION books: title char, author char, pub_date date, pages number
      Title1|Author1|09-01-1991|34
      Title2|Author2|12-23-1954|479
      Title3|Author2|05-09-2002|733
      Title4|Author3|01-01-1968|32
      Title5|Author2|07-03-2001|1152

when executing the plan:

      PLAN test
      {
       INPUT: stream books
       OUTPUT: 
      
       BODY
       {
         rename (books, "author a, title t" : result)
       }
      }

generates the following output:

      ----------------------------------------------
      RELATION: urename1_result
         attrs: t, a, pub_date, pages, sentence
      ----------------------------------------------
      Title1|Author1|09-01-1991|34|The author of Title1 is Author1
      Title3|Author2|05-09-2002|733|The author of Title3 is Author2
      Title4|Author3|01-01-1968|32|The author of Title4 is Author3
      Title2|Author2|12-23-1954|479|The author of Title2 is Author2
      Title5|Author2|07-03-2001|1152|The author of Title5 is Author2
      ----------------------------------------------