Advanced Processing and Analytics in Kognitio - External Scripting¶
Kognitio external scripts are a very powerful feature that enables you to embed advanced non-SQL processing within Kognitio SQL using many programming languages such as Python, R, etc.
External script concepts - understand the different features of Kognitio external scripts and how they can be utilized for the efficient processing of your data - recommended starting point for users new to external scripting.
Define script environments - define the environments that external scripts run within.
Learn how to use external scripts and their output in your SQL queries - some simple examples of how to create external scripts objects, run them inline in your SQL and use output as dervied tables.
External script DDL - reference guide covering the full syntax for external scripts.
Default behaviour for external scripts - default settings and how they can be changed in the script environment or the script definition.
Advanced external script configuration - how to set up external scripts to utilize your Kognitio resources efficiently.
Gain insight into how you can use external scripts in your organisation:
Sentiment analysis - A Python External Script is used to run sentiment analysis over millions of Amazon reviews.
On demand complex analytics - Kognitio external scripts are utilized to allow Qliksense users to access complex forecasting using R.
Note: this framework is referred to as external scripting because of it’s ability to access resources outside of Kognitio’s SQL execution environment