Step 1: Create the database

Warning

SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.

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?