Contents:
Release 6.0.2
This release addresses several bug fixes.
What's New
- Support for Cloudera 6.2. For more information, see System Requirements.
Changes to System Behavior
NOTE: As of Release 6.0, all new and existing customers must license, download, and install the latest version of the Tableau SDK onto the Alteryx node. For more information, see Create Tableau Server Connections.
Upload:
- In previous releases, files that were uploaded to the Designer Cloud Powered by Trifacta platform that had an unsupported filename extension received a warning before upload.
- Beginning in this release, files with unsupported extensions are blocked from upload.
- You can change the list of supported file extensions. For more information, see Miscellaneous Configuration.
Documentation:
- In Release 6.0.x documentation, documentation for the API JobGroups Get Status v4 endpoint was mistakenly published. This endpoint does not exist. For more information on the v4 equivalent, see Changes to the APIs.
Key Bug Fixes
Ticket | Description |
---|---|
TD-40471 | SAM auth: Logout functionality not working |
TD-39318 | Spark job fails with parameterized datasets sourced from Parquet files |
TD-39213 | Publishing to Hive table fails |
New Known Issues
None.
Release 6.0.1
This release features support for several new Hadoop distributions and numerous bug fixes.
What's New
Connectivity:
Support for integration with CDH 5.16.
Support for integration with CDH 6.1. Version-specific configuration is required.
NOTE: If you have upgraded to Cloudera 6.0.0 or later and are using EC2 role-based authentication to access AWS resources, you must change two platform configuration properties. For more information, see Configure for EC2 Role-Based Authentication.
- Support for integration with HDP 3.1. Version-specific configuration is required. See Supported Deployment Scenarios for Hortonworks.
- Support for Hive 3.0 on HDP 3.0 or HDP 3.1. Version-specific configuration is required. See Configure for Hive.
Support for Spark 2.4.0.
NOTE: There are some restrictions around which running environment distributions support and do not support Spark 2.4.0.
For more information, see Configure for Spark.
Support for integration with high availability for Hive.
NOTE: High availability for Hive is supported on HDP 2.6 and HDP 3.0 with Hive 2.x enabled. Other configurations are not currently supported.
For more information, see Create Hive Connections.
Publishing:
Support for automatic publishing of job metadata to Cloudera Navigator.
NOTE: For this release, Cloudera 5.16 only is supported.
API:
- Create, edit, and assign AWS configurations for individual users through APIs. See API Workflow - Manage AWS Configurations.
Changes to System Behavior
Photon
In the application and documentation, the following changes have been applied.
Reference | Description | old Run Job Page term | new Run Job Page term | Doc |
---|---|---|---|---|
Hadoop | Supported running environment on the Hadoop cluster | Run on Hadoop | Spark | Configure for Spark |
Photon running environment | Supported running environment on the Alteryx node | Trifacta Server | Photon | Configure Photon Running Environment |
Photon in-browser client | In-browser web client | n/a | n/a | Configure Photon Client |
Key Bug Fixes
Ticket | Description |
---|---|
TD-39779 | MySQL JARs must be downloaded by user. NOTE: If you are installing the databases in MySQL, you must download a set of JARs and install them on the Alteryx node. For more information, see Install Databases for MySQL. |
TD-39694 | Tricheck returns status code 200, but there is no response. It does not work through Admin Settings page. |
TD-39455 | HDI 3.6 is not compatible with Guava 26. |
TD-39086 | Hive ingest job fails on Microsoft Azure. |
New Known Issues
Ticket | Description |
---|---|
TD-40299 | Cloudera Navigator integration cannot locate the database name for JDBC sources on Hive. |
TD-40348 | When loading a recipe in imported flow that references an imported Excel dataset, Transformer page displays Input validation failed: (Cannot read property 'filter' of undefined) error, and the screen is blank. Workaround: In Flow View, select an output object, and run a job. Then, load the recipe in the Transformer page and generate a new sample. For more information, see Import Flow. |
TD-39969 | On import, some Parquet files cannot be previewed and result in a blank screen in the Transformer page. Workaround: Parquet format supports row groups, which define the size of data chunks that can be ingested. If row group size is greater than 10 MB in a Parquet source, preview and initial sampling does not work. To workaround this issue, import the dataset and create a recipe for it. In the Transformer page, generate a new sample for it. For more information, see Parquet Data Type Conversions. |
Release 6.0
This release of Designer Cloud Enterprise Edition introduces key features around column management, including multi-select and copy and paste of columns and column values. A new Job Details page captures more detailed information about job execution and enables more detailed monitoring of in-progress jobs. Some relational connections now support publishing to connected databases. This is our largest release yet. Enjoy!
NOTE: This release also announces the deprecation of several features, versions, and supported extensions. Please be sure to review Changes to System Behavior below.
What's New
NOTE: The PNaCl client for Google Chrome has been replaced by the WebAssembly client. This new client is now the default in use by the platform and is deployed to all clients through the browser. Please verify that all users in your environment are on Google Chrome 68+. For more information, see Desktop Requirements.
NOTE: Beginning in this release, the Wrangler Enterprise desktop application requires a 64-bit version of Microsoft Windows.
Wrangling:
- In data grid, you can select multiple columns before receiving suggestions and performing transformations on them. For more information, see Data Grid Panel.
- New Selection Details panel enables selection of values and groups of values within a selected column. See Selection Details Panel.
- Copy and paste columns and column values through the column menus. see Copy and Paste Columns.
- Support for importing files in Parquet format. See Supported File Formats.
- Specify ranges of key values in your joins. See Configure Range Join.
Jobs:
- Review details and monitor the status of in-progress jobs through the new Job Details page. See Job Details Page.
- Filter list of jobs by source of job execution or by date range. See Jobs Page.
Connectivity:
- Publishing (writeback) is now supported for relational connections.
This feature is enabled by default
NOTE: After a connection has been enabled for publishing, you cannot disable publishing for that connection. Before you enable, please verify that all user accounts accessing databases of these types have appropriate permissions.
- The following connection types are natively supported for publishing to relational systems.
- Import folders of Microsoft Excel workbooks. See Import Excel Data.
Support for integration with CDH 6.0. Version-specific configuration is required.
See Supported Deployment Scenarios for Cloudera.NOTE: If you have upgraded to Cloudera 6.0.0 or later and are using EC2 role-based authentication to access AWS resources, you must change two platform configuration properties. For more information, see Configure for EC2 Role-Based Authentication.
- Support for integration with HDP 3.0. Version-specific configuration is required. See Supported Deployment Scenarios for Hortonworks.
- Support for Hive 3.0 on HDP 3.0 only. Version-specific configuration is required. See Configure for Hive.
- Hive integration is now available when the backend datastore is S3. See Configure for Hive.
- Read Hive tables from AWS Glue Data Catalog. NOTE: This feature is in Beta release.
See Enable AWS Glue Access.
- New functions. See Changes to the Language.
Track file-based lineage using
$filepath
and$sourcerownumber
references. See Source Metadata References.- In addition to directly imported files, the
$sourcerownumber
reference now works for converted files (such as Microsoft Excel workbooks) and for datasets with parameters. See Source Metadata References.
Workspace:
- Organize your flows into folders. See Flows Page.
Publishing:
Users can be permitted to append to Hive tables when they do not have CREATE or DROP permissions on the schema.
NOTE: This feature must be enabled. See Configure for Hive.
Administration:
New Workspace Settings page centralizes many of the most common admin settings. See Changes to System Behavior below.
- Download system logs through the Designer Cloud application. See Admin Settings Page.
Supportability:
- High availability for the Alteryx node is now generally available. See Install for High Availability.
Authentication:
Integrate SSO authentication with enterprise LDAP-AD using platform-native LDAP support.
NOTE: This feature is in Beta release.NOTE: In previous releases, LDAP-AD SSO utilizes an Apache reverse proxy. While this method is still supported, it is likely to be deprecated in a future release. Please migrate to using the above SSO method. See Configure SSO for AD-LDAP.
- Support for SAML SSO authentication. See Configure SSO for SAML.
- Support for per-user authentication for AWS resources. See Configure for AWS.
Support for Azure Databricks SSO/OAuth.
NOTE: If you integrate the platform with an Azure Databricks cluster and enable SSO for Azure, Azure Databricks is managed through SSO seamlessly. For more information, see Configure SSO for Azure AD.
API:
- Manage user access to APIs using renewable access tokens. For more information, see Changes to the APIs.
Changes to System Behavior
NOTE: The Alteryx node requires NodeJS 10.13.0. See System Requirements.
Configuration:
To simplify configuration of the most common feature enablement settings, some settings have been migrated to the new Workspace Settings page. For more information, see Workspace Settings Page.
NOTE: Over subsequent releases, more settings will be migrated to the Workspace Settings page from the Admin Settings page and from trifacta-conf.json
. For more information, see Changes to Configuration.
See Platform Configuration Methods.
See Admin Settings Page.
API:
NOTE: In the next release of Designer Cloud Enterprise Edition, the v3 version of the APIs will be removed from the product. These End of Life endpoints will no longer be available for interaction with the Designer Cloud Powered by Trifacta platform. You must migrate your usage to the v4 APIs. For more information, see Changes to the APIs.
CLI:
NOTE: The Alteryx command line interface uses the v3 endpoints. In the next release of Designer Cloud Enterprise Edition, the Alteryx CLI will reach its End of Life. These tools will no longer be provided with the software distribution at all. You must migrate your use of the CLI to use the v4 APIs.
NOTE: In the next release of Designer Cloud Enterprise Edition, support for Java 7 will be end of life. The product will no longer be able to use Java 7 at all. Please upgrade to Java 8 on the Alteryx node and your Hadoop cluster.
Changes to release numbering system:
In Release 5.0 and earlier, each release of Designer Cloud Enterprise Edition was given a separate release number, each release incrementing that number. For example, the Release 4.x product line was numbered Release 4.0, Release 4.1, and Release 4.2.
In Release 5.1, Alteryx Inc moved to a monthly milestone release process. Monthly milestones were given separate release numbers in the following format: Release 5.1m1, Release 5.1m2, Release 5.1m3, and Release 5.1m4. The fifth milestone was the generally available release for Release 5.1.
Beginning in this release, each monthly milestone receives a separate release number. For this release, milestones are: Release 5.6, Release 5.7, and Release 5.8. Release 5.9 is the generally available release for Designer Cloud Enterprise Edition.
This change in numbering scheme does not affect the scope and frequency of Designer Cloud Enterprise Edition releases.
Errata:
In prior releases, the product and documentation stated that the platform implemented a version of regular expressions based on Javascript syntax. This is incorrect.
The Designer Cloud Powered by Trifacta platform implements a version of regular expressions based off of RE2 and PCRE regular expressions.
NOTE: This is not a change in behavior. Only the documentation has been changed.
Key Bug Fixes
Ticket | Description |
---|---|
TD-36332 | Data grid can display wrong results if a sample is collected and dataset is unioned. |
TD-36192 | Canceling a step in recipe panel can result in column menus disappearing in the data grid. |
TD-35916 | Cannot logout via SSO |
TD-35899 | A deployment user can see all deployments in the instance. |
TD-35780 | Upgrade: Duplicate metadata in separate publications causes DB migration failure. |
TD-35644 | Extractpatterns with "HTTP Query strings" option doesn't work. |
TD-35504 | Cancel job throws 405 status code error. Clicking Yes repeatedly pops up Cancel Job dialog. |
TD-35486 | Spark jobs fail on LCM function that uses negative numbers as inputs. |
TD-35483 | Differences in how WEEKNUM function is calculated in the Trifacta Photon and Spark running environments, due to the underlying frameworks on which the environments are created. NOTE: Trifacta Photon and Spark jobs now behave consistently. Week 1 of the year is the week that contains January 1. For more information, see Changes to the Language. |
TD-35481 | Upgrade Script is malformed due to SplitRows not having a Load parent transform. |
TD-35177 | Login screen pops up repeatedly when access permission is denied for a connection. |
TD-27933 | For multi-file imports lacking a newline in the final record of a file, this final record may be merged with the first one in the next file and then dropped in the Trifacta Photon running environment. |
New Known Issues
Ticket | Description |
---|---|
TD-39513 | Import of folder of Excel files as parameterized dataset only imports the first file, and sampling may fail. Workaround: Import as separate datasets and union together. |
TD-39455 | HDI 3.6 is not compatible with Guava 26. Workaround: HDI 3.6 supports Guava 14. The solution is to remove the Guava 26 file from the Data Service class path. For more information, see Troubleshooting in Configure for HDInsight. |
TD-39092 |
Workaround: Upload your Parquet files. Create an empty recipe and run a job to generate an output in a different file format, such as CSV or JSON. Use that output as a new dataset. See Build Sequence of Datasets. For more information on these references, see Source Metadata References. |
TD-39086 | Hive ingest job fails on Microsoft Azure. |
TD-39053 | Cannot read datasets from Parquet files generated by Spark containing nested values. Workaround: In the source for the job, change the data types of the affected columns to String and re-run the job on Spark. |
TD-39052 | Signout using reverse proxy method of SSO is not working after upgrade. |
TD-38869 | Upload of Parquet files does not support nested values, which appear as null values in the Transformer page. Workaround: Unnest the values before importing into the platform. |
TD-37683 | Send a copy does not create independent sets of recipes and datasets in new flow. If imported datasets are removed in the source flow, they disappear from the sent version. Workaround: Create new versions of the imported datasets in the sent flow. |
TD-36145 | Spark running environment recognizes numeric values preceded by |
TD-35867 | v3 publishing API fails when publishing to alternate S3 buckets Workaround: You can use the corresponding v4 API to perform these publication tasks. For more information on a workflow, see API Workflow - Manage Outputs. |
This page has no comments.