Smart DIH

Smart Cache

SpaceDeck – Data Query

This part of the system allows you to execute a SQL query against the data in the Space.

Although the Space is a NoSQL data store, it exposes an SQL interface which is used for Data Queries.

Define the Query

Fill in the data query parameters, as shown below.

Data Query Parameters

  1. (Source drop-down list) – Select which GigaSpaces Space object the query should be executed against.

  2. (Load Query drop-down) - If there have been previous queries saved, they can be accessed from here.

  3. (Body of the query) – Enter a SQL-99 compliant query. What is displayed initially is sample syntax.

  4. Retrieve first – Limit the query response to the desired number of rows. A maximum of 10,000 rows can be retrieved.

  5. Run Query - Run the query

  6. Save Query - Save the query to be used in the Load Query drop-down

Data Query Parameters

  1. (Source drop-down list) – Select which GigaSpaces Space object the service should be executed against. If there is more than one Space, then the specific source will have to be defined. If there is just one Space, this is defined automatically.

  2. (Body of the query) – Create a SQL-99 compliant query. Initially there is an example query service displayed in gray, As soon as you click on that area, it is replaced by a blank screen ready for you to create your query.

    3. For Smart Cache, first create a table and then insert data.  

    An sample SQL used for creating a table:

    Create table in Smart Cache SpaceDeck via Data Query:CREATE TABLE Person(Id INTEGER PRIMARY KEY,FirstName VARCHAR(20),LastName VARCHAR(30),Age INTEGER)

    An sample SQL used for inserting data:

    INSERT INTO Person VALUES(20,'test1',1, 'test1')

  3. Retrieve first – limit the query response to the desired number of rows. A maximum of 10,000 rows can be retrieved.

  4. Saved Queries - A list of previously saved queries. If one is selected, then the option of Run Query.will be displayed.
  5. Run Query -Click to test the query. The query results will be displayed. If there is a problem with the query a Query validation failed error will be displayed at the bottom of the screen, like this:

  6. Save Query - Save the query which will then be accessible via the Saved Queries drop-down.

Run the Query

Click Run Query to execute the query. The query results will appear as shown below.

When viewing the query results, additional options is available:

  1. Export – Export the query result locally to a csv-format file

  2. Deploy – Allows a service to be created and deployed from a data query as an API endpoint, that will then appear in the list of Services in the Service menu.

    For Smart Cache the Deploy option is not relevant.

    When clicking Deploy the following screen is displayed:

    Fill in all the details and click Create Service. You will then be redirected to the Service & Microservices main menu where you will see your new service listed with the Status of Created.

    For details about the next steps of service deployment, refer to SpaceDeck – Services