Release Date: January 22, 2018
Xcalar 1.3.0 includes the following new features and enhancements:
Improved Workbook Functionality
- Workbook Preview:
Before activating a workbook, users can now preview the workbook’s table and worksheet information in the new Workbook Preview dialog box.
The Workbook Preview dialog box displays all the tables within the workbook, including their name, size, status, and worksheet.
When you click the name of the table or it’s dataflow graph icon the table’s modeling operations (data lineage) is displayed.
- Workbook Annotation:
To help manage your workbooks, users can now add a workbook description in the new Edit Workbook dialog box.
Improved Dataset Functionality
- Improvements to the Dataset function enables users to configure new data targets before importing datasets originating from different storage platforms.
- Changing the name and functionality of the Import Datasets icon to Data Targets icon.
- Creating a new Import Datasets icon.
Note: Data targets are used to import data by all users sharing the cluster. They are configured with secure access credentials and specifications for a secure connection between Xcalar and the user’s data source repository.
Xcalar release 1.3.0 comes with a few predefined data targets. For more information, see Making source data accessible.
- The data source size is no longer required during data import.
Additional Operator Support:
Xcalar now supports the Union and Union All operators, which behave similar to the equivalent operators in SQL.
Xcalar also supports a multi-key sort from the sort submenu. Users can now use the sort submenu for organizing their data using as many sort keys as they require.
New join types include: Semi Joins, Anti Semi Joins, and Cross Joins
Improved Table Functionality:
Tables can now be locked using the table menu drop-down options.
The hidden tab for archived tables has been discontinued. Starting with this release, if users want to hide tables from their worksheet, they must use the table’s drop-down menu to send unwanted tables to a temporary table list.
While creating a batch dataflow, you can now simultaneously open the data browser and pull hidden fields back into your table to add to the batch dataflow.
The data browser's icon list has been modified from three to two selection modes.
Note: The project mode has been moved to the column menu drop-down menu.
A new PROJECT panel is displayed when Project... is triggered from the column drop-down menu. The functionality is the same as the previous Project Mode, which was located in the Data Browser window. To learn more about Project, see Projecting selected columns.
- Filtering of “null”s:
Users can now use the cell menu options to include or exclude “null”s in their tables.
Improved Dataflow Functionality:
Batch dataflow starting from tables:
Users can now select a source table from the Dataflow panel. This lets users select tables from the active workbook as input to a batch dataflow, instead of selecting data from the user’s data source.
Data Lineage display for dropped tables:
Similar to active tables, users can now view the schema of dropped tables, as well as, the lineage of every field.
Support ticket tracking feature:
You can now not only check the status of your support tickets, but also the tickets associated to your organization, by entering the support ticket modal ID.
Live Chat integration with Zendesk:
A new support ticket is generated as soon as a Xcalar Technical Support Engineer responds to you on Live Chat. You also have the ability to send the chat log to your email address at any time.
As of release 1.3.0, Xcalar now supports Python 3.6. This includes Jupyter notebook as well as the user-defined functions.