Key Feature Additions and Changes | Teradata Package for R 17.00 - Key Feature Additions and Changes - Teradata Package for R

Teradata® Package for R User Guide

Product
Teradata Package for R
Release Number
17.00
Published
July 2021
Language
English (United States)
Last Update
2023-08-08
dita:mapPath
yih1585763700215.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
B700-4005
Product Category
Teradata Vantage

The following table lists the key feature additions and changes in the Teradata Package for R, tdplyr.

Date Release Description
July 2023 17.00.00.04
  • tdplyr is now compatible with R 4.3.0;
  • Minimum required version for teradatasql for R is 17.20.0.26;
  • VAL functions raise appropriate error in case of failures;

    For example, if there is no room in database or insufficient permissions.

  • Changed the VAL function default database from SYSLIB to VAL;
  • cumsum and row_number functions work with tdplyr 17.00.00.04 with no limitation.
May 2023 17.00.00.03
  • tdplyr is now compatible with latest version of dbplyr 2.3.2 (minimum required version).

    See new limitations due to dbplyr 2.3.2 updates.

  • New attach_attributes() function to attach the following attributes to the 'tbl' object:
    • databaseName
    • sourceDefinition
    • sourceType
    • object
    • baseQuery
    • columnDataType
    • columnNames
May 2022 17.00.00.02
  • Added support to export data to a CSV file with new function td_to_csv();
  • Added option to provide flexibility to point to the database where byom is installed;
  • Updated td_fastexport() function with option to export data to a CSV file.
July 2021 17.00.00.01
  • Added dbplyr 2.x compatibility:
    • sql_select of dplyr is renamed to sql_query_select of dbplyr. tdplyr overwrites sql_query_select;
    • sql_translate_env of dbplyr is changed to sql_translation. tdplyr overwrites sql_translation.
  • Added support to models in PMML format for the Bring Your Own Model (BYOM) feature;
  • Added support for FastExport;
  • New STO Sandbox Container Utility Functions;
  • Added support for Vantage Analytic Library (VAL) Functions:
    • Association Rules
    • Decision Tree
    • Descriptive Statistics
    • Factor Analysis
    • Fast KMeans Clustering
    • Linear Regression
    • Logistic Regression
    • Matrix Building
    • Statistical Tests
    • Reports
    • Variable Transformation
  • New S3 Generic function print() allows user to print the output of any of the VAL function;
  • New ways to view underlying SQL:
    • Function show_query() allows user to print the underlying SQL used for function execution using the output object;
    • Option 'print.val.query' allows user to print the SQL while the VAL function is running. This can be used for debugging purpose.
  • New configuration options provide flexibility for user to control which database must be used to create tables and views, generated by the tdplyr APIs, which are garbage collected at the end of the session. These options allow user to set the output database without re-creating context:
    • 'temp.table.database.name' specifies the database to create tables into;
    • 'temp.view.database.name' specifies the database to create views into.
  • Updated td_test_script() function:
    • Function now also allows testing on local client (outside of sandbox environment), in addition to existing node of sandbox testing;
    • Function td_setup_test_env() is deprecated now. Use newly added sandbox container utility function td_setup_sandbox_env() instead.
September 2020 17.00.00.00
  • New Model Cataloging feature providing functionality to catalog model metadata and related information in the Model Catalog;
  • Script providing an interface to run scripts in Analytics Database using Script Table Operator (STO), in two modes:
    • Test/Debug mode: test user scripts locally in a containerized environment;
    • In-Database Script Execution: execute user scripts in database.
  • Added Vantage file management functions to install, replace, remove files in Vantage;
  • New Time Series aggregate functions (ts.percentile, ts.delta_t, ts.kurtosis, ts.skew, ts.sum, ts.sd, ts.sdp, ts.var, ts.varp, ts.min, ts.max, ts.mean, ts.n, ts.describe);
  • New regular aggregate functions (kurtosis, skew);
  • Added support of JWT logon mechanism and Stored Password Protection feature in Context management, and using DBI::dbConnect(tdplyr::NativeDriver(), ...) to create context;
  • Added support for Vantage Native Object Store (NOS) feature to explore data sets located on external object stores like AWS-S3 and Azure Blob Storage;
  • Updated print() function to print only the output objects of class "tbl_teradata" of the analytic function run;
  • Updated data type of returned column or value:
    • td_nrow() used to return integer type, now returns bit64::integer64;
    • Regular aggregate functions n() and n_distinct() used to return the count columns of integer type, now return columns of type bit64::integer64.
    • Window function n() used to return the count column of integer type, now returns column of type bit64::integer64.
  • Updated arguments in analytic functions. See the "Analytic Function Updates" section in Teradata Package for R Function Reference for details.