1 Reply Latest reply: Jul 7, 2011 2:15 AM by jiji.ambat RSS

    Load from resident table

      TableOne:
      LOAD * INLINE [
          ID, Date1, Value
          1, 01/01/2011, 10
      ];


      TableTwo:
      LOAD * INLINE [
          ID, Details
          1, Pr1
      ];

       

      // TableThree not loading

      TableThree:
      LOAD * RESIDENT TableOne;
      JOIN LOAD * RESIDENT TableTwo;

       

      After reloading the script, when I try the table viewer (Ctrl+T), I could see only TableOne and TableTwo. TableThree is not present.

       

      But if I change the TableThree script as below, I could see TableThree also in table viewer. Here I have removed one field form the load script.

       

      // TableThree is loaded

      TableThree:

      LOAD ID, Date RESIDENT TableOne;

      JOIN LOAD * RESIDENT TableTwo;

       

      Why is it that I cannot load all the fields of TableOne in the initial LOAD statement for TableThree ?

       

      Even if I just try to load all fields of TableOne to TableThree (by removing the join statement above) as shown below TableThree is not loaded.

       

      // TableThree not loading

      TableThree:

      LOAD * RESIDENT TableOne;

       

      Is there any reson for this behavior or soultion ?