Important

Helios features are now enabled during weekly update windows and are no longer directly tied to SingleStore engine releases. Refer to the release notes to view the latest features available in your Helios cluster.

Step 1: Create the database

Run the following SQL statements to create a new trades database with two tables: trade and company. The trade table is a columnstore table that contains analytical trading related data for each company and the company table is a rowstore table that stores details about each company.

SQL

CREATE DATABASE trades;

USE trades;

DROP TABLE IF EXISTS trade;
CREATE TABLE trade(
 id BIGINT NOT NULL,
 stock_symbol CHAR(5) NOT NULL,
 shares DECIMAL(18,4) NOT NULL,
 share_price DECIMAL(18,4) NOT NULL,
 trade_time DATETIME(6) NOT NULL,
 SORT KEY(stock_symbol),
 SHARD KEY(stock_symbol)
);


DROP TABLE IF EXISTS company;
CREATE ROWSTORE TABLE company(
  `Symbol` VARCHAR(50) NOT NULL,
  `Name` VARCHAR(255),
  `LastSale` VARCHAR(10),
  `MarketCap` VARCHAR(15),
  `IPOyear` VARCHAR(10),
  `Sector` VARCHAR(80),
  `industry` VARCHAR(80),
  `Summary Quote` VARCHAR(50),
  `extra` VARCHAR(50)
);

Step 1: Create the database

Was this article helpful?

Was this article helpful?