Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The SAS Parquet Summarizer Executor can be configured using the Rest API. 

Easy Heading Free
navigationTitleOn this Page
wrapNavigationTexttrue
navigationExpandOptionexpand-all-by-default

Create

SAS

Parquet Summarizer Executor


Field

Required

Default

Multiple

NotesExample
typeYes-No

The value must be "application".

"application"

_typeYes-No

The value must be "application".

"application"

appNameYes-NoThe name of the application"SASParquet-Executor"
appTypeYes-NoThe value must be "sasparquet-summarize-executor"."sasparquet-summarize-executor"
configYes-NoThe value must be "com.accenture.aspire:app-sassummarizeparquetsummarize-executor"."com.accenture.aspire:app-sassummarizeparquetsummarize-executor"
descriptionYes-NoThe description

"SASParquet-Executor"

propertiesYes-NoConfiguration object
addSchemaYestrueNoIf enabled the table schema will be added to the processed columns.true
useTempFileYestrueNoEnable to download the content stream to a temporary file before processing it.true
threadPoolYes5NoThe number of threads to use for parallel processing.5
logFrequencyYes1000NoThe frequency for reporting the processed rows.1000
filterRowsYesfalseNoEnable to filter the rows to process.true
useFilterFileYestrueNoEnable to use a groovy file to filter the rowstrue
groovyPathNo-NoThe path of the groovy script that contains the filter logic.  It must return a boolean value, if true the row will be filtered"C:\\Aspire\\config\\rowsGroovyFilter.txt"
groovyScriptNo-NoScript used to filter the rows. It must return a boolean value, if true the row will be filtered"row.getBoolean(\"sensitive\") == true"

Example

Code Block
themeRDark
titlePOST /aspire/_api/workflows/{workflow}/rules
{
  "type": "application",
  "_type": "application",
  "description": "SASParquet-Executor",
  "config": "com.accenture.aspire:app-sassummarizeparquetsummarize-executor",
  "appType": "sasparquet-summarize-executor",
  "appName": "SASParquet Summarize Executor",
  "properties": {
    "addSchema": true,
    "useTempFile": true,
    "debug": false,
    "threadPool": 5,
    "logFrequency": 1000,
    "filterRows": true,
    "useFilterFile": false,
    "groovyScript": "// This script must return a boolean.\n// The references of the job, doc, component, row and table objects are available.\n// Javadoc references \n// Row (row) - http://{manager}/javadocs/com/accenture/aspire/services/summarization/Row.html\n// Table (table) - http://{manager}/javadocs/com/accenture/aspire/services/summarization/Table.html\nrow.getBoolean(\"sensitive\") == true"
  }
}

Update

SAS

Parquet Summarizer Executor


Field

Required

Default

Multiple

NotesExample
idYes-NoId of the application to update"61014782-442a-4587-ab85-ba1439a7f7b5"
typeYes-No

The value must be "application".

"application"

_typeYes-No

The value must be "application".

"application"

appNameYes-NoThe name of the application"SASParquet-Executor"
appTypeYes-NoThe value must be "sasparquet-summarize-executor"."sasparquet-summarize-executor"
configYes-NoThe value must be "com.accenture.aspire:app-sassummarizeparquetsummarize-executor"."com.accenture.aspire:app-sassummarizeparquetsummarize-executor"
descriptionYes-NoThe description

"SASParquet-Executor"

propertiesYes-NoConfiguration object
addSchemaYestrueNoIf enabled the table schema will be added to the processed columns.true
useTempFileYestrueNoEnable to download the content stream to a temporary file before processing it.true
threadPoolYes5NoThe number of threads to use for parallel processing.5
logFrequencyYes1000NoThe frequency for reporting the processed rows.1000
filterRowsYesfalseNoEnable to filter the rows to process.true
useFilterFileYestrueNoEnable to use a groovy file to filter the rowstrue
groovyPathNo-NoThe path of the groovy script that contains the filter logic.  It must return a boolean value, if true the row will be filtered"C:\\Aspire\\config\\rowsGroovyFilter.txt"
groovyScriptNo-NoScript used to filter the rows. It must return a boolean value, if true the row will be filtered"row.getBoolean(\"sensitive\") == true"

Example

Code Block
themeRDark
titlePUT /aspire/_api/workflows/{workflow}/rules/{id}
{
  "id": "61014782-442a-4587-ab85-ba1439a7f7b5", 
   "type": "application",
  "_type": "application",
  "description": "SASParquet-Executor",
  "config": "com.accenture.aspire:app-sassummarizeparquetsummarize-executor",
  "appType": "sasparquet-summarize-executor",
  "appName": "SASParquet Summarize Executor",
  "properties": {
    "addSchema": true,
    "useTempFile": true,
    "debug": false,
    "threadPool": 5,
    "logFrequency": 1000,
    "filterRows": true,
    "useFilterFile": false,
    "groovyScript": "// This script must return a boolean.\n// The references of the job, doc, component, row and table objects are available.\n// Javadoc references \n// Row (row) - http://{manager}/javadocs/com/accenture/aspire/services/summarization/Row.html\n// Table (table) - http://{manager}/javadocs/com/accenture/aspire/services/summarization/Table.html\nrow.getBoolean(\"sensitive\") == true"
  }
}