SqlDataFrame in Expression Language: Difference between revisions

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search
(Created page with "{| class="wikitable" !'''SqlDataFrame functions''' ! '''Parameters''' ! '''Description''' |- || || || |}")
 
No edit summary
Line 1: Line 1:
SqlDataFrame represents tabular data similar to a result of an SQL query. Data in the SqlDataFrames are processed in the original datasource where the data is located (not in the QPR ProcessAnalyzer server in-memory). For each SqlDataFrame, there is an SQL query that processes and generates the actual data in the datasource.
Running SqlDataFrames and operations between them don't yet execute the SQL in the original datasource. This happens when the '''Collect''' function is called for an SqlDataFrame, which executes the SQL query of the SqlDataFrames and loads the data into QPR ProcessAnalyzer server in-memory dataframe (where it can be presented in a dashboard).
Each SqlDataFrames knows the datasource where the SQL query is executed.
There is a similar API for the SqlDataFrames as there is for the DataFrames.
{| class="wikitable"
{| class="wikitable"
!'''SqlDataFrame functions'''
!'''SqlDataFrame functions'''

Revision as of 20:59, 4 May 2021

SqlDataFrame represents tabular data similar to a result of an SQL query. Data in the SqlDataFrames are processed in the original datasource where the data is located (not in the QPR ProcessAnalyzer server in-memory). For each SqlDataFrame, there is an SQL query that processes and generates the actual data in the datasource.

Running SqlDataFrames and operations between them don't yet execute the SQL in the original datasource. This happens when the Collect function is called for an SqlDataFrame, which executes the SQL query of the SqlDataFrames and loads the data into QPR ProcessAnalyzer server in-memory dataframe (where it can be presented in a dashboard).

Each SqlDataFrames knows the datasource where the SQL query is executed.

There is a similar API for the SqlDataFrames as there is for the DataFrames.

SqlDataFrame functions Parameters Description