Release Notes Version 3.4

Release Notes Version 3.4

Release 3.4

Release Date: September 2016

Release notes for ThoughtSpot 3.4, which includes significant chart changes, including the addition of pivot and funnel charts. More granular and better looking maps, along with fuzzy text search are also included.

Revamped UI design

Reorganizing the buttons and icons found throughout the application for a more intuitive

experience. For example, several hidden icons have been moved to dropdown menus, such as Actions. Also, the pin answer button has been moved out into the open to help make pinning an answer become second nature.

Figure 2: Add to pinboard button while viewing an answer

Enforcing uniform alignments, spacings, and typography for a cleaner look.

Redesigning list pages for answers, pinboards, data, and users/groups. These pages also benefit from pagination, so you don’t have to scroll all the way down to find the item you’re looking for.

Pinboard filter changes

Pinboard filters can now be used for ad hoc filtering. In addition, the pinboard filter layout itself has been cleaned up.

Ad hoc pinboard filters

Creating a pinboard filter no longer automatically saves the filter to the pinboard. This allows users with read-only access to the pinboard to create ad hoc filters. However, you still need to have access to the underlying data used to create the pinboard to apply filters. Users with edit access can still save pinboard filters by clicking Save under Actions.

Filter values box improvements

The filter values box has been redesigned to improve your pinboard filtering experience. Selected values now appear at the top of the items list. This way, you won’t have to scroll through the entire list to deselect a value. This setting only applies to values that have already been selected at the time the filter box is opened. So selecting or deselecting values will not move the items around until the box is closed.

There are also Clear all and Select all options that sit at the top of the panel. The Select all option is disabled when there is a high cardinality of values. In such cases, please use the Add values in bulk option.

Figure 3: New filter values box layout

These filter values box improvements apply to all filtering experiences found in ThoughtSpot, such as when editing users and groups.

Chart enhancements

Some chart types now follow a new color palette. And a number of enhancements have been made to pie, stacked column, stacked area, treemap, heatmap, and geo charts. There are also several new chart types.

Absolute numbers on pie charts

Pie charts now display the exact values of each slice, in addition to the percentage values. Toggle on Show Data Labels to see these values.

Figure 4: Absolute and percentage values on pie charts

Aggregated numbers on stacked column charts

Stacked column charts also benefit from additions to the Show Data Labels option. Turning it on will show the sum of the stacks at the top of each stack.

Figure 5: Aggregated numbers on stacked column charts

Toggle “Show Y-Axis as %” for stacked charts

Currently, stacked area charts plot the y-axis as a percentage by default. You can now choose to toggle Show Y-Axis as % on/off in the Configuration Options to create your own mountain-style charts. This feature is also available for stacked column charts.

Figure 6: Show Y-Axis as % toggled on

Figure 7: Show Y-Axis as % toggled off

New Treemap chart shape

The treemap now displays its data in a more equilateral fashion.

Figure 8: New treemap look

Heatmap chart makeover

The heatmap colors have been adjusted to make the chart easier to read.

Figure 9: New heatmap look

Geo charts improvements

Many minor improvements listed below in bullets have been made to geo charts, in addition to a few major ones found in the following subtopics.

Geo charts are more responsive.

Geo area maps now support zip code level granularity.

Boundaries are only drawn for zip codes and counties with data. This makes the maps more efficient and look cleaner.

Feature boundaries are not drawn at all for geo bubble and heat maps. It looks more beautiful without political boundaries obscuring the bubbles.

The animation when a map loads has been removed.

Geo charts prevent you from zooming too much. You will be able to zoom in enough to see all the context you need.

New color combination for geo heatmap chart

The geo heatmap colors now do a better job at displaying the graphical representation of your geodata.

Figure 10: New geo heatmap color combination

Higher resolution maps

Geomaps have more detailed geographic boundaries, such as appropriate water boundaries. You can see these more detailed geo charts when you choose geo area, geo bubble, or geo heatmap charts. These higher resolution maps only apply to the US.

Figure 11: Say goodbye to the jumbo shaped Michigan

County level geo charts

You can now create charts that geo map at the county level in the US by modeling the appropriate geo type data. In the Manage Data columns settings of your table, select County as your Geo Type. County columns need to contain text (VARCHAR) data. You can also select Zip_Code to take advantage of the increased mapping functionality of ZIP Code data.

Figure 12: Geo Type - County

Note, ThoughtSpot will by default only plot counties with unique names. You can work around this by appending the state name to the end of the county name with a comma delimiter, forming one string. For example, pike county, ohio or pike county, OH. This string should be included in the county column.

Figure 13: County level geo chart example

New chart types

New line stacked column chart

There is a new chart type that combines stacked column and line charts, which is called a line stacked column chart. This chart is similar to the line column chart, except that it divides its columns with an attribute in the legend. In order to be able to select this chart, your search must have at least two attributes and two measures.

Figure 14: Example line stacked column chart

New funnel chart

A funnel chart has also been added. It shows a process with progressively decreasing proportions that amount to 100 percent. This chart is similar to a stacked percent column chart, and is often used to represent stages in a marketing or sales process. In order to be able to select this chart, your search must have at least one attribute and one measure. The attribute must contain 50 or less values.

Figure 15: Example funnel chart

New pivot table

Pivot tables have been remodeled after the conventional drag-and-drop structure. Previously, ThoughtSpot used a pivot keyword to select which fields can be columns and which can be rows, thus moving columns to be rows and vice versa. Now, the pivot table is a chart type.

Choose Pivot Table under Select Chart Type to view your search as a pivot table. Add rows, measures, and columns to the search bar and restructure your table by moving these values under Configure Chart or by dragging and dropping them on the UI. Your pivot table will show the grand totals for columns and rows.

Figure 16: Example pivot chart

Several pivot table limitations no longer exist:

Pivot tables now work when the underlying schema is a chasm trap.

Pivot tables now work on top of chasm trap worksheets.

Columns in the pivot table now automatically update in a pinboard when new data values are loaded.

You can now sort on a pivot column.

However, new limitations include:

The pivot table chart type is not available if the dataset contains more than 100,000 rows.

Columns with cardinality beyond 100 are grouped into {Other}.

Show underlying data menu is unavailable.

Conditional formatting is not functional.

Recent searches

Search suggestions now include complete recent searches that are similar to the search you are constructing. This makes it easier to learn what you can do with ThoughtSpot. In addition to displaying your own recent searches, the search bar also learns from queries made by other users. This should provide you with interesting queries that you may not have been aware of.

Figure 17: Recent search suggestion

New formulas

This release includes several new formulas. These are available in the Formula Builder, and you can see syntax and usage examples in the Formula Assistant:

Text formulas

The following fuzzy match text formulas are new in this release:

Formula name

Description

Examples

edit_distance

Accepts two text strings. Returns the edit distance (minimum number of operations required to transform one string into the other) as an integer. Works with strings under 1023 characters.

edit_distance
(“attorney”, “atty”) = 4

edit_distance (color, “red”)

edit_distance_with_cap

Accepts two text strings and an integer to specify the upper limit cap for the edit distance (minimum number of operations required to transform one string into the other). If the edit distance is less than or equal to the specified cap, returns the edit distance. If it is higher than the cap, returns the cap plus 1. Works with strings under 1023 characters.

edit_distance_with_cap (“pokemon go”, “minecraft pixelmon”, 3) = 4

edit_distance_with_cap ( event, “burning man”, 3)

spells_like

Accepts two text strings. Returns true if they are spelled similarly and false if they are not. Works with strings under 1023 characters.

spells_like (“thouhgtspot”, “thoughtspot”) = true

spells_like (studio, distributor)

sounds_like

Accepts two text strings. Returns true if they sound similar when spoken, and false if they do not.

sounds_like (“read”, “red”) = true

sounds_like (owner, promoter)

similarity

Accepts a document text string and a search text string. Returns the relevance score (0-100) of the search string with respect to the document. Relevance is based on edit distance, number of words in the query, and length of words in the query which are present in the document. If the two strings are an exact match, returns 100.

similarity (“where is the burning man concert”, “burning man”) = 46

similarity (tweet1, tweet2)

similar_to

Accepts a document text string and a search text string. Returns true if relevance score (0-100) of the search string with respect to the document is greater than or equal to 20. Relevance is based on edit distance, number of words in the query, and length of words in the query which are present in the document.

similar_to (“hello world”,”hello swirl”) = true

similar_to (current team, drafted by)

Number formula

The following number formula is new in this release:

safe_divide

Returns the result of dividing the first number by the second. If the second number is 0, returns 0 ​instead of NaN (not a number).

safe_divide (12 , 0) = 0

safe_divide (total_cost ,units)

New keywords

There are new keywords that help you search for similar text strings.

Fuzzy text search

The new keywords similar to and not similar to allow you to search for matching text that is similar, but not necessarily an exact match. In the past, you could use the contains keyword to search for an exact text string match, but there was no way to do a fuzzy match for similar strings. These new keywords allow you find similar text strings.

For example, a search that includes:

course name similar to ‘hand’

Might return results like:

Hands On with ThoughtSpot

Handing off to the Customer

Andy Smith’s Intro to ThoughtSpot

A search that includes:

course name not similar to ‘hand’ Would return all the other course names.

Incremental metadata indexing

This performance improvement decreases the time required before the search bar can provide suggestions for new data loads. When you load new data, only the metadata that has changed gets indexed. So you can start searching much more quickly after a new data load or table import has been completed.

In addition to the new data load case previously mentioned, this improvement is also applicable to other actions which modify metadata. For example when:

Renaming a column, table, or worksheet.

Changing permissions of user.

Adding a user to a group or removing a user from a group since these actions can change table and worksheet permissions a user has access to.

Adding or removing relationships.

Creating worksheets.

Append load to system tables through UI

You now have the ability to append data to your existing system tables through the UI. While viewing a table, click Load data to be taken to an upload page where you can choose to append to or overwrite the existing data.

Figure 18: Load data button

Dependency analysis in TQL

Just as we warn you about object dependencies in the UI, we now warn you about dependencies when you modify or delete objects using TQL. This should make you feel safe performing TQL actions. For every TQL statement, you will be warned of possible dependency consequences with a prompt asking if you’d like to proceed. If TQL is run in --allow_unsafe mode, your statements will always execute without warning. See theThoughtSpot Administrator Guide for more information.

Capacity chart in admin UI

Admins can see a capacity chart in the Overview tab of System Health. This line chart displays the total used capacity, which consists of raw uncompressed data, including replication.

Figure 19: Space Utilization chart

The x-axis is by time. It allows you to zoom in and see daily or hourly data. The y-axis measures the size in GB. So in the Space Utilization chart above, the green line shows the amount of capacity in use in the system, while the red line shows the total capacity. The increase in the red line at the end of the period indicates the addition of extra hardware, resulting in increased capacity.

Get configured features

There is a new tscli command to get the configured features in a cluster, tscli feature get-all-config. The command will return a list of features, such as custom branding, Data Connect, and call home, and tell you whether they are enabled or disabled.

Figure 20: Configured features status example

Silence/unsilence/show alerts

There are new tscli commands to silence, unsilence, and show alerts.

tscli alert silence-name

This command silences the alert with alert_name. For example, DISK_ERROR. Silenced alerts are still recorded in postgres, however emails are not sent out.

tscli alert unsilence-name

This command unsilences the alert with alert_name.

tscli alert info-silence

This command lists all silenced alerts.

tscli alert info-active

This command lists all active alerts.

Once an alert is silenced, it will persist across cluster updates and alertmanager restarts. It can only be unsilenced using the above tscli alert unsilence command.

LDAP config wizard - search base for user properties

A prompt for the ldapSearchBase setting, which was previously part of java overrides, has been added to the LDAP configuration wizard, tscli ldap config. When configuring LDAP for active directory, you will now be prompted with LDAP search base (Example: cn=Users).

New ODBC drivers

The ThoughtSpot ODBC drivers have been updated for this release. If you are using them, you must update the drivers after updating ThoughtSpot. The installation for these new drivers has changed slightly. Please see the ThoughtSpot Data Integration Guide for details.

ODBC driver for solaris

There is now an ODBC driver for Solaris Sparc. The new Solaris ODBC driver is certified on Solaris Sparc 10.

New JDBC driver

There is a new JDBC driver for this release. If you are using JDBC, you must update the driver to use it with this release. There are a few other changes to JDBC:

The JDBC driver name in prior releases was:

com.simba.client.core.<wbr/>JDBCDriver

The new JDBC driver name is: com.simba.client.core.jdbc4.<wbr/>SCJDBC4Driver

There is a new format for the JDBC connect string. If you have existing code that uses JDBC, you’ll need to update it to use the new syntax:

ThoughtSpot Data Connect improvements

There are a number of UX improvements around the self-serve data integration UI offered through ThoughtSpot.

Display data source name when multiple data source loads are present

The source column displays the data source name when the same table is loaded from multiple data source loads. This should help differentiate your loaded tables.

Object search

A search bar is now available for you to use to find table names when browsing the source tables list.

Figure 21: Data Connect object search bar

Validate an expression

Before, you had to start the data source creation process over when an expression transformation failed. This should no longer be a problem now that you have the ability to validate an expression you’ve just added.

Send email notification when a data load has completed

There is now an option to send an email notification when a data load has successfully (or unsuccessfully) completed.

Disable a schedule

You can now disable a schedule after a scheduled job is created so that the load will not trigger.

Edit a connection

You can now edit a connection in a data source. This was only possible before from the Informatica Cloud UI.

Option to retain tables

When deleting data sources, you have the option to either delete or retain the underlying tables. This allows you to get rid of old data source tasks when you modify tables, but keep the table to be used for the "load to existing table" option.

Other UX improvements

Other UX improvements include chart, pinboard, users and groups, schema viewer, and help center improvements.

More chart enhancements

More detailed chart enhancements include changes to the title behavior, improved visual functions, and a simplified tooltip.

Auto created titles

Answers are automatically given titles based on their search columns. For example, a search for Fruits and Total sale will be named Total sale by Fruits. Any applied filters are added to the description. When you change your search, your answer title will also change. This should help you understand what you are seeing in your results.

Also, answers no longer have two titles.

Maximize view for visualizations

The ability to maximize an answer has been moved from the answer view to the pinboard view. You must use the Present option found under the visualization dropdown.

Simplified tooltip

The tooltip’s aesthetics and information has been simplified to make it easier to read and use. It now displays the cursor’s information in order by most beneficial values to least: first by the y-axis value, then the x-axis value, and lastly by the legend.

Figure 22: New simplified tooltip

Sparse date labels on the x-axis

In the case of time series charts, we want to display the fewest number of labels possible, while still maintaining readability. This reduces the clutter and makes charts look less cramped. Charts automatically choose the appropriate date bucketing to use depending on how much space the chart has and the time range displayed. And now, they adjust this choice when the size of the chart changes due to the browser size.

Figure 23: Old date labels

Figure 24: New date labels

All of the intermediate data points are still present no matter which date bucketing is used.

Pinboard improvements

There are several pinboard layout and UX improvements.

Save changes to one visualization

Previously, editing and saving one visualization in a pinboard would reload the entire pinboard, putting stress on both the front and backends of the system. Now, editing a single visualization only reloads that particular visualization.

Preserve custom column widths

You can now resize and save the column widths of a table in your pinboard. In addition, any adjustments you make to the column widths of an answer will be preserved when you pin it to a pinboard.

Unsaved changes prompt behavior

You are no longer prompted to save a pinboard after making ad hoc changes, such as adding filters or viewing underlying data.

Consolidated icons and visualization sizes

The hidden visualization icons have been moved under a dropdown found on the top right of the visualization.

Figure 25: Consolidated icons dropdown

There is a new option at the bottom of this dropdown where you can toggle between predetermined sizes for your visualization. Charts and graphs can be toggled between a small, medium, or full width size, while headlines can be only one size (small). One row of the pinboard can hold up to four small visualizations, two medium visualizations, or one large visualization.

Visualizations snap into place and reset layout

Visualizations within a pinboard are now easier to move around and snap into place on a relative flow layout. Your pinboard layout is also responsive to your browser resolution. This should help you keep the layout of your pinboard neat and organized. Any pinboards that you have edited the layouts of will be converted to fit our grid in the best possible manner: the order or the visualizations will be kept, and each visualization will be assigned an appropriate size.

You can also click Reset layout under Actions if you would like ThoughtSpot to optimize your layout space for you. This action will keep the sizes of your visualizations, but not the order.

Figure 26: Reset your pinboard layout

Users and groups changes

Add multiple users to a group

You can add multiple users to a group by selecting them from the User Management list page and clicking the Add Users to Groups button.

Figure 27: Add users to groups button

Search for a user from groups editing

In the Edit Group dialog box, you can search for a user to manage their settings.

Figure 28: Search for a user from the Edit Group box

Schema viewer improvements

The schema viewer allows you to see a graphical representation of your database schema in the web browser.

Adjustable tables

Within the schema viewer, you can now move and resize your tables and worksheets. These objects are also collapsible.

Worksheet view

You can view what is inside a worksheet within the schema viewer. This worksheet view shows the following information:

All tables in the worksheet, and the relationships between these tables.

Source columns for all columns of a worksheet.

Keys and definitions for each relationship, as well as join paths and types.

Columns that are derived from formulas.

Figure 29: The worksheet view

The worksheet view does not work for aggregated worksheets, but does work for worksheets built on top of aggregated worksheets.

Filtering

You can filter the tables and worksheets in the schema viewer by owner, type, and stickers.

Figure 30: Filter bar for the schema viewer

Help center changes

Clicking Help opens a quick and simple dialog box with links to How Search Works, Keywords, Release notes, Documentation, and Downloads. Click one of them to open a new window to easily navigate your selected topic.

Figure 31: The new help center home page

All of ThoughtSpot's documentation is available in the help center for you to search through by topic. Use the search bar to jump to a relevant concept, task, reference, or video page. You will be shown results that apply to the ThoughtSpot release you are using.

What’s changed in 3.4?

ODBC/JDBC changes

This release introduces new ThoughtSpot ODBC and JDBC clients. You must update to the new versions of these clients upon upgrading ThoughtSpot. Note that some of the parameters have changed, so you will need to review the ThoughtSpot Data Integration Guide, and change any scripts or code that uses the drivers to use the new parameters.

Currency formatting embedded use case

The currency formatting feature introduced in 3.3.2 is semi-limited to an embedded use case. When you specify the currency type of your data on the Manage Data page, your currency data will only display the correct format and currency code in the embedded use case. Currency specific symbols are available in the non-embedded use case as well, but they are not localized. All users are treated as if they are in en-US locale unless they are in embed mode and their browser configuration tells ThoughtSpot that they are in some other locale.

For example, 100 Polish Zloty appears as 100zł to a user in Poland, but without localization enabled, it appears as PLN 100. This subtle difference can be seen when you use the REST API. See the ThoughtSpot Application Integration Guide for more information on the API.

Documentation changes

There are new books available in the ThoughtSpot documentation library:

ThoughtSpot Data Connect Guide: The information on ThoughtSpot Data Connect has moved out of the ThoughtSpot Administrator Guide and into its own guide.

ThoughtSpot User Guide: This new book covers all aspects of the ThoughtSpot UI that end users face on a daily basis, with a focus on search, charts, and pinboards.

Information about these topics have been removed from the ThoughtSpot Administrator Guide and placed in the appropriate new guide.

Style Customization: This topic has been moved to the ThoughtSpot Application Integration Guide.

Complex Searches: This topic has been moved to the ThoughtSpot User Guide.

What’s fixed in 3.4.7?

Increase batch size for geomap charts

ISSUE ID: SCAL-16803

Description: Previously, geomap charts in ThoughtSpot supported 1000 data points. However, since there are over 3000 counties in the United States, it was not possible to generate complete geomap charts with all counties represented. Therefore, ThoughtSpot has increased the limit to 5000 data points for geomap charts.

FIXED: Red bar error timeout messages

ISSUE ID: SCAL-17276

Description: Queries that joined tables with over 128 regions would produce a red bar error. This bug, introduced in 3.4.6, caused slow queries and timeouts.

What’s fixed in 3.4.6?

FIXED: Missing horizontal scroll bar

ISSUE ID: SCAL-17201

Description: Search answers with many columns didn’t include a horizontal scroll bar.

FIXED: Pinboard not loading

ISSUE ID: SCAL-17198

Description: Some pinboards were not loading correctly after upgrading.

FIXED: Search suggestions not showing “last month” when “last” is a field in the data

ISSUE ID: SCAL-17040

Description: In the case where “last” appeared in the data, “last month” was not being prioritized and recognized as a keyword.

What’s fixed in 3.4.5?

Data Connect - Filter for selecting a connection

ISSUE ID: SCAL-16736

Description: As the number of your connections grow, it becomes harder for you to find and select the connection you want from the dropdown list. Therefore, there is a new filter capability that allows you to easily navigate your connections.

FIXED: Improved slideshow view of headlines

ISSUE ID: SCAL-16720

Description: The view of a presented headline visualization in a pinboard has been redesigned to make better use of the display screen.

FIXED: Blank pinboards on the home page

ISSUE ID: SCAL-16922

Description: Switching from and back to a pinboard on the homepage presented the pinboard with a blank data area. This bug has been fixed.

FIXED: Data Connect - No feedback when edit to connection fails

ISSUE ID: SCAL-16724

Description: When attempting to edit a connection password, if the newly edited connection failed to connect then there was no error message that explained that it had failed. This would leave you wondering if the changes to the connection were successfully made or not. Now, in the case of a typo, an invalid password error message displays when you click Test & Edit.

Description: When creating a data filter on the Date_Time field, you weren't able to specify the filter value. This prevented you from performing incremental loads. The known workaround had you run your data load in full-mode instead of incremental mode. This has been fixed.

What’s fixed in 3.4?

FIXED: Specify the max size allowed for front end data uploads

ISSUE ID: SCAL-8554

Description: Previously, there was no information or alert on the max file size allowed for front end uploads. This caused confusion and unknown errors with large uploads. There is now a UI message that states that the maximum upload file size is 50MB.

FIXED: Blank zero values in heatmaps

ISSUE ID: SCAL-13241

Description: The heatmap’s default behavior was to display “{Blank}” in cells whose numeric value was zero. These cells now display “0”.

FIXED: Help center release info is not always correct

ISSUE ID: SCAL-13357

Description: The release version information found on the bottom right hand corner of the help center was not always correct due to browser caching. The old workaround was to perform a hard refresh of the browser window.

FIXED: Custom fiscal calendars not working correctly

ISSUE ID: SCAL-13521

Description: Custom fiscal calendars were not working as expected, as certain months were being grouped into the wrong fiscal quarter.

FIXED: Bubble chart loses configuration

ISSUE ID: SCAL-13636

Description: Bubble charts now preserve their configuration when switching between Data and Chart Views.

FIXED: Preserve table widths in saved answers

ISSUE ID: SCAL-13704

Description: Before, any adjustments made to table widths in answers would not save. Now, changes to table widths persist, and are even preserved when pinning the table to a pinboard.

FIXED: API embedded pinboard micro scroll error

ISSUE ID: SCAL-13944

Description: When embedding a pinboard in an iframe, the pinboard did not resize correctly based on the width of the iframe. This created a horizontal micro scroll bar with a very small range. This has been fixed by correctly resizing the embedded pinboard.

FIXED: Stacked column chart does not sort by order of total

ISSUE ID: SCAL-14651

Description: Sorting a stacked column chart by order of total did not work. Instead, it sorted by total legend item. Stacked columns now sort correctly by order of total.

FIXED: Date fields not retaining date format when exported to excel

ISSUE ID: SCAL-14657

Description: When downloading an answer with date field columns, the column type in excel was shown as “General” instead of “Date”. This has been fixed.

FIXED: Worksheet in inconsistent state after 3.3.x upgrade

ISSUE ID: SCAL-14816

Description: Some worksheets may have been in an inconsistent state due to the data type returned by a date formula. This made it difficult to make changes to the affected worksheets. A known workaround had you open the problematic data formula and resave it.

FIXED: Custom fiscal calendar displays incorrect quarters in EDT

FIXED: Non-admin user getting logged out

ISSUE ID: SCAL-15332

Description: Some non-admin users would see a not authorized error on the home page, and be immediately logged out. This happened when there was a mix of permissions for the non-admin user in regards to the landing page’s pinboard. For example, the user may have access to some of the visualizations but not others, due to aggregated worksheets.

FIXED: User without permissions to view all pinboards on the home page receives error

ISSUE ID: SCAL-15562

Description: Users that did not have permissions to view all pinboards on the home page were greeted with a “not authorized to perform this action” error. This made some pinboards unshareable. This experience has been fixed.

FIXED: Windowing function doesn’t work with date column with no bucket

ISSUE ID: SCAL-15574, 15623

Description: Windowing functions did not work when windowing over a date column that uses no detailed bucketing. This is no longer the case.

FIXED: Cluster restore fails due to buggy hadoop_tool

ISSUE ID: SCAL-15785

Description: The hadoop_tool could not find the mounted disk during cluster restore due to a bug. This would break the disaster recovery process. This has been fixed in the 3.4 branch.

Description: In the Select Tables section of the Data Connect procedure, only a limited number of objects show up in the Available Tables list. The Metadata fetch is only happening for the first 200 objects. This has been fixed by the Data Connect object search feature.

Description: Updating a scheduled data load to repeat monthly returned an error. This is no longer the case.

FIXED: Data Connect - Load status is inconsistent/incorrect

ISSUE ID: SCAL-15005, 15158

Description: The load statuses displayed on the Data Source list page and slider did not match. Refreshing the data source and returning to the list page would fix the issue. Now, the load status is displayed correctly in both places.

Description: Loading to an existing schema where the tgt schema was altered via TQL would return an error. This issue has been fixed. Note, the ordering of columns in the Schema Editor needs to match the order in the target schema.

Known issues

Day of the week filter sorts incorrectly

ISSUE ID: SCAL-7284

Description: Filtering by the day of the week does not sort the days based on calendar day order.

Applying filter on {blank} value results in no data

ISSUE ID: SCAL-7731

Description: Applying a filter on {blank} values results in an answer with no data.

Data filter for time is not supported

ISSUE ID: SCAL-8579

Description: Data filtering in a table column does not allow you to properly filter time values.

View of underlying data is not protected based on privilege

ISSUE ID: SCAL-9863

Description: It is not yet possible to prevent user access to detailed underlying data while providing access to aggregated data.

Aggregation on top of an aggregated formula error

ISSUE ID: SCAL-12193

Description: An error message is returned when you perform an aggregation, such as group_sum, on top of an aggregated formula.

Proper error message for tsload errors

ISSUE ID: SCAL-13149

Description: Error messages when loading data using tsload are not accurate.