DataStax Studio 6.8 release notes

Release notes for DataStax Studio 6.8.x.

Release notes for DataStax Studio 6.8.x.

For DSE release notes, see DataStax Enterprise 6.8 release notes.

For upgrade information, see Upgrading DataStax Studio.

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:

      https://github.com/DataStax-Academy/cassandra-workshop-series/blob/master/week2-DataModel/notebooks/DataModel.tar

    • Spaces in the URL:

      https://github.com/DataStax-Academy/cassandra-workshop-series/blob/master/week1%20-%20Getting%20Started%20with%20Cassandra/notebooks/2_-_Datastax_Studio.tar

6.8.2 Resolved issues

  • Fixed issues displaying the results of a Graph elementMap query when the graph schema contains id or label properties. (STUDIO-3152)
    Specifically, with this change:
    • Objects of type T in Studio are now displayed with a T. prefix. For example: T.id or T.label.
    • Edge objects in Studio now display id, inVLabel, and outVLabel columns in addition to label. Example: see the results of g.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 property nodesync
  • 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 listed above.

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 and system_schema keyspaces and on specific tables. Related settings are needed via GRANT EXECUTE and other commands, depending on the components used. (STUDIO-3046)

    See Controlling access to DataStax Studio.

  • 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:

    Edit Connection form with message indicating Database authorization problem and details link

    To learn about the specific issues, click the details link. Example:

    Studio database access permission error dialog 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:

    Studio error message displayed in SparkSQL notebook cell because Always On SQL Server (AOSS) does not have permission to access data

  • Added Studio support for CQL BACKUP commands. See Backup and Restore Service CQL Command Reference (beta). (STUDIO-3076)
  • Added Studio support for the following cqlsh commands:
  • 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 certain WITH 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 and timeAllowed 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)
  • 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's 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, and LOCAL.QUORUM.TRACE.
    • The default execution configuration is LOCAL.ONE.
    • Upgrading existing Studio installations automatically replaces old execution configurations with new ones:
      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)