8 Replies Latest reply: Nov 1, 2017 11:43 AM by Aehman K RSS

    add 1 or 2 columns into the load commands

    ramesh konda

      Hi, do we have the option to load the column data from one table to another table?

       

      Section01:

      [POSTAL DATA]:

      LIB CONNECT TO HIVEODBC;

      LOAD ID,

      Postcode,

      Postdesc,

      Sate,

      StateDesc;

      SQL SELECT ID,

      Postcode,

      Postdesc,

      Sate,

      StateDesc

      FROM HIVE.POSTTAB;

       

       

      Section2:

      [KMLFile]:

      LOAD ID,

      SADIGIT,

      LONG,

      LAT

      FROM [lib://kmlfile/kmlfile.csv]

      (txt, utf8, embedded labels, delimiter is ',', msq);

       

       

      ( Now as per the above, the two tables gets Join with ID) Here, I want to load the Postcode, Postdesc into the section2 (KMLFile] Table as well, how to achieve it.

       

       

      Output should be:

      [POSTAL DATA] : (ID,Postcode,Postdesc,State,StateDesc) Colums

      [KMLFile]: (ID,SADIGIT,LONG,LAT,Postcode,Postdesc), ( 2 (Postcode,Postdesc) columns from [POSTAL DATA] should add to this [KMLFile] Table).

       

      Rams.