Important

The SingleStore 9.1 release candidate (RC) is available now. It will be promoted to general availability (GA) soon and at that time it will be renamed to SingleStore 10.

In the interim, SingleStore 9.1 RC can be used to preview, evaluate, and provide feedback on the new and upcoming features in SingleStore 10, while SingleStore 9.0 is recommended for production workloads.

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?