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.
For more information, see Configure Publishing to Cloudera Navigator.
Changes to System Behavior
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: Beginning in this release, the Wrangler Enterprise desktop application requires a 64-bit version of Microsoft Windows. For more information, see Install for Wrangler Enterprise Application.
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.
- 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.
Language:
Track file-based lineage using
$filepathand$sourcerownumberreferences. See Source Metadata References.- In addition to directly imported files, the
$sourcerownumberreference 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 Admin 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.
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 Admin page. For more information, see Workspace Admin Page.
NOTE: Over subsequent releases, more settings will be migrated to the Workspace Admin 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.Java 7:
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.
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. |
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. |
| 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.