Difference between SQL Select and LOAD

Wed, 10 Sep 2014 11:33:38 GMT

Hello everyone,

Is there a difference between using

SQL Select

....

From Table;

and

LOAD ... ;

SQL SELECT

...

FROM. Table ;

when extracting data from a database ?

Re: Difference between SQL Select and LOAD

Wed, 10 Sep 2014 11:52:40 GMT

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;