LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only
  • 1.  SQL inside LAE

    Employee
    Posted 05-21-2015 00:25

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: ThomasT

    I guess someone already asked the question, but I will also do it anyway
    Is it possible to emit SQL statements to data already imported into LAE?
    Sometimes brainscript just isn't enough to achieve what you would like to do(or takes a whole lot working around).

    Br.
    Thomas


  • 2.  RE: SQL inside LAE

    Employee
    Posted 05-21-2015 05:53

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: stonysmith

    The temporary files used between nodes are flat text files.
    There is no "database engine" to which you could issue SQL commands.

    The question becomes .. what specifically do you wish to accomplish?

    When comparing LAE to SQL, the LAE Join and Agg nodes are significantly more capable than SQL.
    If you treat BrainScript as a procedural language, you will find a good bit of power hidden there.


  • 3.  RE: SQL inside LAE

    Employee
    Posted 05-22-2015 05:48

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: ThomasT

    Thank you for answering Stony.
    So far I always been able to transfer SQL into brainscript, this was more of a general question.