Known issues and limitations for SPSS Modeler
The following known issues and limitations apply to SPSS Modeler.
For more information about troubleshooting other issues in SPSS Modeler, see Troubleshooting SPSS Modeler.
Known Issues
upgradeStatusgets stuck inInProgressstatus after upgrading IBM® Software Hub- Rows with no documents don't display correctly in Categories tab
- Data assets from Teradata connection
Limitations
- Downtime for SPSS Modeler during upgrade to IBM Software Hub Version 5.4
- Languages supported by Text Analytics
-
SPSS Modeler Text Analytics supports the following languages:
- Chinese (Simplified and Traditional)
- Dutch
- English
- French
- German
- Italian
- Japanese
- Portuguese
- Spanish
The Text Mining node can extract text data written in both Simplified Chinese and Traditional Chinese. However, SPSS Modeler currently provides templates and text analysis packages only for Simplified Chinese.
- No
SQLlabel for Data Asset Export node when you use watsonx.data™ Presto -
When you use data from the watsonx.data Presto connection and SQL pushback is enabled, the Data Asset Export node does use the SQL pushback feature. As a result, Data Asset Export nodes do not have the SQL label in the user interface.
- Data streaming for Google BigQuery with SQL pushback
-
If SQL pushback is enabled, data streaming is not used to insert data when you select the Streaming Insert option for Write mode in a Data Asset Export node. A standard insert occurs instead. If you want to use data streaming with Google BigQuery, you must disable SQL pushback.
- Special characters for Google BigQuery with SQL pushback
- Google BigQuery does not support some special characters (like $ and *) in column
names, and SQL validation fails for queries that contain these characters.
To avoid errors, SPSS Modeler automatically disables SQL pushback for any node where a special character appears in a column name. SQL pushback is also disabled for all downstream nodes in the flow.
Workaround
To use SQL pushback with your data, you can add a Filter node to your flow to filter out columns or change their names. You must rename or filter the model output fields that contain $.
- To change the name of a column, edit it in the Output field column.
- To filter out a column from your data, click the arrow in the Filter column.
For a list of supported special characters, see Specifying a schema in the Google BigQuery documentation.
- Timestamp data measured in microseconds
-
If you have timestamp data that is measured in microseconds, you can use the more precise data in your flow. However, you can import data that is measured in microseconds only from connectors that support SQL pushback. For more information about which connectors support SQL pushback, see the documentation:
- Merge node and Unicode characters
-
The Merge node treats the following similar Japanese characters as the same character.
Figure 2. Japanese characters 
