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.
Step 1: Create the database
Run the following SQL statements to create a new trades
database with two tables: trade
and company
.company
table is a rowstore table that stores details about each company.
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));
Last modified: November 20, 2024