Difference between SQL Select and LOAD

[#1]

Hello everyone,

Is there a difference between using

SQL Select

....

From Table;

and

LOAD ... ;

SQL SELECT

...

FROM. Table ;

when extracting data from a database ?

[#2 · Accepted solution]

Select is actual what we are fetch data  from the database or from any other source.

You can not use any function when we are using

SQL Select

....

From Table;

If you want to use function to transform the data you need to use LOAD. ...;

2.........

load is always load column from preloaded table i.e. SELECT.

3............

you can use multiple load for one SELECT.

e.x.

load c1,c4 as c5,*;

load c1, c2 as c4;

select c1,c2,c3 from XXX;