Page tree

Release 5.0.1




Release 4.0.2

This release contains key bug fixes from Release 4.0.1.

What's New

No new features have been introduced.

Changes to System Behavior


Key Bug Fixes



Update NodeJS to 6.11.1


Spark job gets stuck for flow with header filter and multiple map transform expressions


Spark job OOM error when failing over frequently on a Resource Manager High Availability cluster


Dictionary URL is incorrect in CDF for Spark jobs


Spark jobs with timestamp source columns yield empty columns


Job fails with "Unary operator LexiconCheck not supported" in Spark


Corrupted DotZlib.chm file in 4.0.1 RPM


Nginx Request URI length default is too low.


'Python Error' when opening recipe with large number of columns and a nest


ArrayIndexOutOfBoundsException when UDF iterator reaches premature end


Nest transform creates a map with duplication keys.


In shared Hadoop cluster on Edge environment, valid relational connections do not appear in the GUI.


Support for equals sign (=) in output path.


Results of Spark job show missing values, even though recipe step replaces them with a value.


Type registry fails to initialize when webapp process is relaunched.


Spark PyMultiStringReplaceUdf UDF code throws NPE when processing nested fields.


Unexpected dates appear in CSV output on Alteryx Server job execution.


umask settings on output directories are not being respected for single-file output.


Adding a specific comment appears to invalidate earlier edit.


Spark unable to read recursive folders


Spark error doing split


No rows in random samples on CSM cluster.


Recipe upgraded from 3.1 to 3.2 becomes corrupted when new lookup is added.



Webapp, batch-job-runner scaling issues


Flow with many dependencies hangs for 6 hours and then fails when executed in Spark on AWS


Generating large CLI script blocks client access


Long latency when loading complex flow views


Recipe showing MISSING for some Lookups after upgrade


View Results button is missing on Job Cards even with profiling enabled


Spark yarn-app log dump feature requires Alteryx account to have read/execute permissions to log aggregation folder.


Extremely slow UI performance for some actions


Java UDFs must support initSchema method to initArgs.


Use Node.js cluster module for easy scaling of webapp and VFS services


Columns created from UDFs do not work with column browser, column menus, or both, and they cannot be shown or hidden.

New Known Issues


Release 4.0.1

This release adds a few new features and addresses some known issues with the platform. 

What's New

Admin, Install, & Config:

NOTE: Integration with MapR is not supported for this release.


  • Apply optional quoteEscapeChar to identify escaped quote characters when splitting rows. 
  • See Changes to the Language.

Changes to System Behavior

Application timeout behavior more consistent

In Release 4.0, the web application session timeout was set to 60 minutes by default, which caused inconsistent behaviors. See TD-22675 below. 

In Release 4.0.1 and later, this session timeout was set to one month by default. This change returns the web application to the same setting as Release 3.2.1 and earlier.

NOTE: Beginning in Release 4.0, this setting is configurable. For more information on changing the session timeout, see Configure Application Limits.

Key Bug Fixes

TD-22675Session timeout behavior is inconsistent. Application seems to have some functionality after timeout.
TD-22570After upgrade, some pre-upgrade jobs appear to point to deleted datasets.
TD-22388S3 authorization mechanism does not support Signature Version 2 in Asia-Pacific and EU.
TD-22220Dataset suddenly fails to load after upgrade from Release 3.2 because of type checking on an invalid recipe line.
TD-19830Editing a Join or Union transform that includes a reference dataset (not in the same flow) may result in the unintentional removal of that reference dataset from the flow.

splitrows transform does not work after a backslash.

This issue is fixed with the new quoteEscapeChar parameter for the splitrows transform. See Changes to the Language.

TD-5783Prevent two-finger scroll in data grid from stepping back in the browser's history on Mac OS.

New Known Issues


Connection for Redshift publishing uses its own AWS access key and secret, which may be different from the per-user or system credentials. If the Redshift connection does not have read access to the data, publication fails.

Workaround: Verify that the access key and secret for the Redshift connection has access to any source data that you wish to publish to Redshift.


Release 4.0

This release features a single page for managing your flows, a faster Spark-based running environment on the Alteryx node, and a number of new  Wrangle functions and capabilities. Details are below. 

NOTE: Integration with MapR is not supported for this release.

What's New


  • The new flow detail page includes a visual representation of your flow and detailed information about its datasets and recipes. From the Flow View page, users can swap datasets and run jobs, too. See Flow View Page.
  • Send a copy of a flow to another user. See Send a Copy of a Flow. 

Transformer Page:

  • Column width settings now persist across transform steps, other actions, and user sessions. See Transformer Page
  • Users can now perform join and unions directly against imported datasets that contain schema information, such as Hive, JDBC, and Avro. 
  • Wrangle steps can now be displayed in natural language. See Data Grid Panel.
  • New column menu shortcuts allow you to quickly assemble recipe steps from menu selections, based on a column's data type. See Column Menus.
  • New column browser streamlines interactions involving multiple columns. See Column Browser Panel.
  • Default quick scan samples are now collected over more of the data source, the first 1 GB. Administrators can now modify this size. See Configure Application Limits.
  • For the Spark running environment, you can enable generation of random samples across the entire dataset. See Configure for Spark.



  • New Custom SQL query options for Hive and relational sources enables pre-filtering of rows and columns by executing the SQL logic within the database to reduce data transfer time for faster overall performance. See Enable Custom SQL Query.  
  • Users can now import Hive views to be used as a source.  See Hive Browser.
  • Expand the list of file extensions that are permitted for upload. See Miscellaneous Configuration


  • New Spark v2.1.0-based running environment leverages in-memory speed to deliver overall faster execution times on jobs. See Configure Spark Running Environment.

    NOTE: As of Release 4.0, for new installs and upgrades, Spark is the default running environment for execution on the Hadoop cluster. Support for Hadoop Pig running environment is deprecated and in future releases will reach end-of-life. For more information, see Running Environment Options.

    NOTE: Python UDFs are not supported in the Spark running environment. Support for Python UDFs is deprecated and in a future release will reach end-of-life. For more information on migrating to using Java UDFs, see Changes to the User-Defined Functions.

  • You can disable the ability to run jobs on the Alteryx Server. See Running Environment Options.
  • User-specific properties can be passed to Pig or Spark for use during job execution. See Configure user-specific props for cluster jobs.
  • Default file publishing setting for CSV output is multiple output files when using a Hadoop running environment, resulting in better performance over large data volumes.


  • Window transform now supports use of aggregation functions. See Window Transform.
  • New NOW and TODAY functions.
  • New ROLLINGSUM function computes the rolling sum over a specified number of rows before and after the current row. See ROLLINGSUM Function.
  • New ROLLINGAVERAGE function computes rolling average over a specified window. See ROLLINGAVERAGE Function.
  • New ROWNUMBER function computes the row number for each row, based on order and optional grouping parameters. See ROWNUMBER Function.
  • New COUNTA function can be used to count the number of non-null values in a column based on order and grouping parameters. See COUNTA Function.
  • New COUNTDISTINCT function counts distinct number of values in a specified column. See COUNTDISTINCT Function.
  • Four new functions for testing conditional data validation: IFNULLIFMISMATCHED, IFMISSING, and IFVALID. See Type Functions.
  • New *IF functions for each available aggregation function. See Aggregate Functions.
  • For more information, see Changes to the Language.


  • First release of publicly available APIs, which enable end-to-end operationalization of processing your datasets. See API Reference


Admin, Install, & Config:

Changes in System Behavior

Changes to the Language:

  • set and settype transforms now work on multiple columns.
  • Recipe steps are now displayed in natural language format by default in the recipe panel and suggestion cards. 
  • Some functions have been renamed to conform to common function names. 
  • For more information, see Changes to the Language

Changes to the CLI:

  • The Jobs command line interface now supports job execution on the Spark running environment. See CLI for Jobs.

End of Life Features:

Key Bug Fixes

TD-21006Photon fails to compress output file and is forced to restart on download.
TD-20736Publish to Redshift fails for single-file outputs.
TD-20524Join tool hangs due to mismatched data types.
TD-20344When Photon is enabled, no sample data is displayed when joins yield a data mismatch. 
TD-20176After Release 3.2.1 upgrade, data grid in the Transformer Page no longer displays any data in the sample, even though data is present in the pre-upgrade environment.
TD-20173NUMFORMAT string #.#0 fails to be converted to supported string format on upgrade, and recipe step fails validation. For more information, see Changes to the Language.
TD-19899Failed first job of jobgroup prevents datasets from showing up in flow.
TD-19852User can accept compressed formats for append publish action. 
TD-19678Column browser does not recognize when you place a checkmark next to the last column in the list.
TD-18836find function accepts negative values for the start index. These values are consumed but produce unexpected results.
TD-18746When Photon is enabled, previews in the data grid may take up to 30 seconds to dismiss.

Platform fails to start if Alteryx user for S3 access does not have the ListAllMyBuckets permission.

TD-18340When writing CSV outputs, the Spark running environment fails to recognize the defined escape character.
TD-17677Remove references to Zookeeper in the platform.
TD-16419Comparison functions added through Builder are changed to operators in recipe
TD-12283Platform cannot execute jobs on Pig that are sourced from S3, if OpenJDK is installed. 

New Known Issues


Cannot read multi-file Avro stream if data is greater than 500 KB.

Workaround: Load files as independent datasets and union them together, or concatenate the files outside of the platform.

TD-21737Transformer Page

Cannot transform downstream datasets if an upstream dataset fails to contain a splitrows transform.

Workaround: Add a splitrows transform to the upstream dataset. See Splitrows Transform.

TD-20796Job Results Page

For date column, Spark profiling shows incorrect set of dates when source data has a single date in it.


Merge function does not work with double-escaped values, and job fails in Pig. Example:

set col: column4 value: merge(['ms\\',column4])

Workaround: Add a dummy character to the original transform and then remove it. Example:

set col: column4 value: merge(['ms\\℗',column4])
replace col: column4 on: '℗' with: ''

As another alternative, you can execute the job in the Spark running environment.

This page has no comments.