DataStax Studio 6.8.x release notes
This page provides release notes for DataStax Studio.
6.8.4 and later
DataStax Studio 6.8.x release notes are available in the DataStax release notes repository: Studio 6.8.4 and later release notes.
For upgrade information, see Upgrading DataStax Studio.
Earlier releases
DataStax Studio 6.8.2 release notes
31 July 2020
6.8.2 Changes and enhancements
-
Added support for
gzip
files on Notebook imports. (STUDIO-2299) -
Notebooks can be imported into Studio using GitHub URLs. (STUDIO-2299)
The feature now works with URLs such as the following examples:
-
"blob" URLs:
-
Spaces in the URL:
-
6.8.2 Resolved issues
-
Fixed issues displaying the results of a Graph
elementMap
query when the graph schema containsid
orlabel
properties. (STUDIO-3152)Specifically, with this change:
-
Objects of type T in Studio are now displayed with a
T.
prefix. For example:T.id
orT.label
. -
Edge objects in Studio now display
id
,inVLabel
, andoutVLabel
columns in addition tolabel
. Example: see the results ofg.E()
. -
The maximum length of a value displayed in a Studio cell result has increased from 100 to 150 characters.
-
-
Fixed a issue in CQL cells where certain table properties were not recognized and reported as a validation error. (STUDIO-3139)
The following table properties are now recognized as valid:
-
table property
additional_write_policy
-
table property
read_repair
-
property option
incremental
of table propertynodesync
-
-
Fixed an issue when the provided import URL contained spaces or other characters that needed to be URL encoded. (STUDIO-3155)
See the related Notebooks enhancement.
DataStax Studio 6.8.1 release notes
19 June 2020
6.8.1 Changes and enhancements
-
Added the last updated date/time to the status line of cell results in Studio. (STUDIO-2298)
-
To use Studio when authentication and authorization are enabled, you must set database permissions on
system
andsystem_schema
keyspaces and on specific tables. Related settings are needed viaGRANT EXECUTE
and other commands, depending on the components used. (STUDIO-3046) -
The Test Connection feature now checks user permissions for the specific keyspaces and tables that Studio queries. (STUDIO-3048)
When there are problems, the Edit Connection form displays a "Database authorization problem" error message with a details link.
Example:
To learn about the specific issues, click the details link. Example:
If Studio is unable to connect to Spark SQL, the Spark SQL cells now display a more detailed message to indicate why the problem occurred. Example:
-
Added Studio support for CQL
BACKUP
commands. See Backup and Restore Service CQL Command Reference. (STUDIO-3076) -
Added Studio support for the following
cqlsh
commands:-
DESCRIBE SEARCH INDEX
. See DESCRIBE SEARCH INDEX command. (STUDIO-3093) -
EXECUTE AS <user>
. See EXECUTE AS command. (STUDIO-3124)
-
-
Improved CQL cell validation of maximum length of keyspace and table identifiers to be version specific.
-
Max length is 48 characters in DSE 5.1.x and DSE 6.0.x
-
Max length is 222 characters in DSE 6.7.x and higher
-
-
Improved the execution time of the first CQL or Spark SQL cell execution. (STUDIO-3126)
-
A Gremlin cell can be executed in Studio when there is no Graph selected for the Notebook. This support enables the execution of Gremlin code that does not require a Graph. (STUDIO-3128)
Example:
system.graph("my_graph_keyspace"). fromExistingKeyspace(). create();
6.8.1 Resolved issues
-
Duration
data type syntax highlighting in CQL cells. (STUDIO-1277) -
ConcurrentModificationException
periodically appeared in standard out. (STUDIO-2216) -
DateRangeTypes
now display properly in Studio results. (STUDIO-2945) -
In Studio, CQL cells using
ALTER TABLE
commands containing certainWITH
clauses previously did not run properly. (STUDIO-3115) -
Null Pointer Exception encountered in Studio when trying to execute a CQL cell that only contained comments. (STUDIO-3117)
-
In Studio 6.8.0, attempts to use an unreserved DSE keyword as the User Defined Type (UDT) name caused an
org.apache.cassandra.exceptions.SyntaxException
. (STUDIO-3120) -
In CQL cells, Search query parameters
useFieldCache
andtimeAllowed
are now recognized. (STUDIO-3123) -
Fixed an issue in CQL cells when the selected keyspace value in the Keyspace dropdown was an identifier that must be quoted. (STUDIO-3132)
Examples of identifiers that must be quoted:
-
starts with a number
-
starts with an underscore
-
CQL reserved keyword
-
-
Addressed issues with the server startup script on Windows OS when
java_home
was not defined in the environment. (STUDIO-3136) -
In CQL cells, the following
Datetime
functions are now recognized. (STUDIO-3137)-
currentTimestamp
-
currentDate
-
currentTime
-
currentTimeUUID
-
DataStax Studio 6.8.0 release notes
March 2020
6.8.0 Changes and enhancements
-
Create and share links to direct cells with the new Copy Cell Link option in the Other Cell Action (
…
) menu. (STUDIO-645, STUDIO-2817) -
You can now import a notebook using a URL. (STUDIO-1814)
-
You can now click the connection name in notebook header to open the connection dialog and make changes. (STUDIO-1762)
-
DataStax Graph (core) provides more versatility in application development. See About DataStax Graph. To learn about the redesign of DataStax Graph, take a tour with the DataStax Graph QuickStart v6.8.0 notebook from the Studio home page. (STUDIO-2263, STUDIO-2403, STUDIO-2499)
-
New execution options and connection management options in
configuration.yaml
. Options from earlier versions that are not present in the file are ignored and can safely be removed. (STUDIO-1696) -
Select Edit Connection in the notebook header to edit the current connection, add a new connection, or select a different connection directly from within the notebook.
-
Clustering Key columns are no longer sorted by name. (STUDIO-1792)
-
Improved user experience when you create or edit a Connection. After you click the Save button, a spinner now displays to indicate progress and prevent other changes to the Connection. (STUDIO-2322)
-
Improved usability inside notebooks. The cursor pointer is now consistent in dropdowns. (STUDIO-2487)
-
Changes to the Create Graph dialog include the addition of a cluster node count. (STUDIO-2574)
-
Studio now supports the export of query results to CSV and JSON formats. (STUDIO-316, STUDIO-2628)
-
Built-in Studio notebook versions are updated for v6.8.0. (STUDIO-2676)
-
CQL duration data type is now supported in CQL cells. (STUDIO-2814)
-
Changes in the New Graph dialog. (STUDIO-2499, STUDIO-2574, STUDIO-2678)
-
Choose DataStax Graph (Core) or Classic. The graphic type is displayed in the upper left corner of the notebook. The Core notebook is recommended.
-
The replication options are set to match the number of discovered cluster nodes and are configurable.
-
-
Neighborhood expansion query is optimized to reduce expensive server side operations for super nodes. (STUDIO-2663)
-
You can now execute only the highlighted statement or statements in a cell. (STUDIO-2892)
-
For CQL and Spark SQL cells, partial statement highlights and execution are supported. It is handy to select any part of the statement to execute the entire statement.
-
For Gremlin cells, you must select the entire statement. Error messages returned indicate the line number within the group of highlighted statements, not the line number of the cell.
-
-
In the Create Notebook dialog, the connection now auto-fills if there is only a single connection. (STUDIO-2973)
-
Execution configuration changes. (STUDIO-2946)
-
Execution configurations on a new installation are
LOCAL.ONE
,LOCAL.QUORUM
, andLOCAL.QUORUM.TRACE
. -
The default execution configuration is
LOCAL.ONE
. -
Upgrading existing Studio installations automatically replaces old execution configurations with new ones:
Configuration Files 6.8 6.7 and earlier LOCAL.ONE
CL.ONE
LOCAL.QUORUM
CL.QUORUM
LOCAL.ONE
CL.ALL
LOCAL.QUORUM.TRACE
CL.ONE.TRACE
-
You can now create an Astra connection. (STUDIO-3095)
-
6.8.0 Resolved issues
-
Graph dropdown must be updated when connection is changed. (STUDIO-2775)
-
Error message when trying to connect to an unsupported cluster type, for a cluster other than DSE, is not clear. (STUDIO-2836)
-
Table using non-frozen UDTs can throw
Codec not found
error. (STUDIO-3004) -
The
server.bat
file did not handle Windows user directories that contained spaces and caused Studio startup to fail. (STUDIO-3023) -
Cell execution results causing OOM. Use new cell execution settings in
configuration.yaml
. (STUDIO-3068)