ghas-results / vantage-dss-plugin-mle-functions Goto Github PK
View Code? Open in Web Editor NEWThis project forked from teradata/vantage-dss-plugin-mle-functions
License: MIT License
This project forked from teradata/vantage-dss-plugin-mle-functions
License: MIT License
------------------------------------------------------------------------- - README file: The Teradata Vantage ML Engine Functions Plugin - - Version: 1.1-2 - - April 2021 - - Copyright (c) 2021 Teradata ------------------------------------------------------------------------- NOTE: This is the last planned release of the plugin. As of November 2021 the present plugin is not maintained any longer. The Teradata Vantage Machine Learning Engine Functions Plugin allows end users to leverage Vantage analytics within their DSS data science workflows. This plugin supports all 180+ Vantage Machine Learning and Graph Engine functions in 16.20. Note that Dataiku DSS itself also supports ANSI SQL push-down for most of their data preprocessing Visual recipes. The present plugin has been tested with Vantage 1.1 Release Candidate 9. I. System Requirements ---------------------- The following component versions are required for the Teradata Vantage Plugin: 1. Dataiku Data Science Studio version 8.0.2 - 8.0.6 2. Teradata Vantage 1.1 3. Teradata JDBC Driver 16.20 (minimum), Teradata JDBC Driver 17.00 (recommended) II. Install / Upgrade Instructions ---------------------------------- To install the Teradata Vantage ML Engine Functions plugin for Dataiku DSS, perform the following: 1. In DSS Settings page (accessible through the Admin Tools button), select the [Plugins] link, then click on the [Installed] tab. 2. Click on [ADD PLUGIN] button and select the "Upload" link". 3. In the pop-up window, browse to the location of the present plugin zip file in your local filesystem. 3. If a previous installation of the plugin exists, check the button next to "This is an update for an installed plugin". 4. Click on [UPLOAD] button. 5. When the upload succeeds, click on [Reload] button, or do a hard refresh (Ctrl + F5) on all open Dataiku browsers for the change to take effect. Documentation for the present plugin exists in the folder "resource/documentation" of the plugin zip file. III. Limitations ---------------- 1. For analytic functions that: - take in output table names as arguments, and - where the select query produces only a message table indicating the name of the output model/metrics table, it is the responsibility of the user to specify output table names that are different from those of the existing tables. Some analytic functions provide an option to delete an already existing output table prior to executing an algorithm, but others do not. 2. The present version of the Teradata Vantage ML Engine Functions plugin has been tested to work with the ML Engine analytic functions on Vantage 1.1 systems. Earlier or later analytic function versions may require a different set of function metadata. 3. The plugin only supports Vantage Advanced SQL Engine Database datasets as input and output. 4. Due to the mode the plugin creates output tables, the function output is checked for duplicate rows. If any duplicate rows are found, then they are removed from the output table. This behavior is not adjustable in the present version of the plugin. 5. Functions with any OUTPUT TABLE type arguments will require the user to add an output dataset for the SELECT statement results of the query and any additional output tables. Please refer to the Vantage ML Engine Analytic Functions documentation page at docs.teradata.com to learn about the output tables of each function. 6. MapReduce Function pairs are currently limited to the following select few: - ApproxDCount, - ApproxPercentile, - Correlation, - PCA, - Naïve Bayes. In order to use these functions, please call their corresponding Map Functions on the function selection box and it will display the arguments for both functions. 7. The following issues are still open at the time of the release of the plugin: |-------------------------------------|---------------------------------------|------| | Functional Category - Function Name | Issue | JIRA | |-------------------------------------|---------------------------------------|------| | Text - AnalysisTextTokenizer | Chinese characters might be causing | N/A | | | the plugin to fail. The same function| | | | runs in other query tools (Teradata | | | | Studio). | | |-------------------------------------|---------------------------------------|------| | Statistical Analysis - | Function requires a different | ANLY-| | ApproxPercentileReduce | requiredInputKind than PartitionByAny | 8404 | | | APPROXPERCENTILEREDUCE cannot be used | | | | as a row function. | | |-------------------------------------|---------------------------------------|------| | Time Series - TimeSeriesOrders | An error is encountered when executing| ANLY-| | | the TimeSeriesOrders Function using | 8400 | | | either the plugin or the Teradata | | | | studio. The same error is encountered | | | | for both tools.“PARTITION BY 1” is not| | | | supported by the Metadata – error 9134| | | | returned. | | |-------------------------------------|---------------------------------------|------| | Time Series - | Column (required arguments) refers to | ANLY-| | ShapeletSupervisedResponse | a table that is an Optional Argument. | 8649 | | | It is quite misleading to the user. | | | | Based on the Vantage documentation, | | | | the Reponse Column should refer to the| | | | Inputtable as well. This is a Metadata| | | | BUG. | | |-------------------------------------|---------------------------------------|------| | Text Analysis - | These functions are not merged. We may| ANLY-| | NamedEntityFinderEvaluatorMap/Reduce| need to confirm if this is expected. | 8650 | | | We will proceed with the unmerged | | | | function for now. We have implemented | | | | merged functions when partner_function| | | | is set in the metadata. However, for | | | | the affected functions, they are not | | | | set as partner_function. | | |-------------------------------------|---------------------------------------|------| | Statistical Analysis - | Examples show that CoxHazardRatio's | ANLY-| | CoxHazardRatio | input table PredictorValues should | 8400 | | | have partitionByOne and perhaps | | | | partitionByOneInclusive in the new | | | | JSON metadata. The JSON for | | | | CoxHazardRatio might need to be | | | | updated to set partitionByOne to TRUE | | | | and partitionByOneInclusive to TRUE. | | |-------------------------------------|---------------------------------------|------| | Statistical Analysis - | Unable to match example SQL due to UI | DOC | | CrossValidation | not supporting such an action. The | | | | argument "LinkFunction" for | | | | CrossValidation's interface does not | | | | support accepting multiple similar | | | | values. This may also be an issue for| | | | other functions which have | | | | "permittedValues" and "allowsList" | | | | in the argument's properties. | | |-------------------------------------|---------------------------------------|------| | Statistical Analysis - | Unable to Replicate Query, function | ANLY-| | DistributionMatchReduce | requires partitionByOne and perhaps | 8685 | | | partitionByOneInclusive to be true. | | |-------------------------------------|---------------------------------------|------| | Time Series - ARIMA | Input table and orders table does not | ? | | | have PARTITION BY Clause in the UI. | | |-------------------------------------|---------------------------------------|------| | Ensemble - AdaBoostPredict | ORDER BY clause for the Model table is| ? | | | set to Required Arguments even though | | | | they are Optional Arguments. | | |-------------------------------------|---------------------------------------|------| Therefore, usage of certain functions are currently restricted. Those functions include: o Statistical Analysis • Approximate Percentile Map/Reduce • Correlation Map/Reduce • Cox Hazard Ratio • Cross Validation • Distribution Match Reduce o Text Analysis • Text Tokenizer • Named Entity Finder Evaluator Map/Reduce o Time Series • Time Series Orders • Shapelet Supervised • ARIMA • VARMAX 5 and 6 (due to dependencies on Time Series Orders) o Ensemble • AdaBoost Predict IV. References -------------- For additional information on the Teradata Vantage ML Engine analytic functions, search for the following on docs.teradata.com: 1. "Teradata Vantage Machine Learning Engine Analytic Function Reference". 2. "Teradata Vantage User Guide". V. Changelog ------------ What’s new: - Bug fix: The functions visual interface was distorted in DSS v.8.0.x. Release Date Notes Version 1.1-2 April 2021 Current; bug fix. Version 1.1-1 March 2020 Initial release.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.