search

apache / doris

Apache Doris is an easy-to-use, high performance and unified analytics database.
https://doris.apache.org
Apache License 2.0
12.7k stars 3.28k forks source link

can not create a table with primary key #5598

Open rtttech opened 3 years ago

rtttech commented 3 years ago

The following sql cant not be executed, it works in MySQL/sqlite.

CREATE TABLE chinese_stock_history2016 (stockid VARCHAR(6), date VARCHAR(10), open REAL, high REAL, low REAL, close REAL, volume BIGINT, adjclose REAL, PRIMARY KEY (date,stockid));

yangzhg commented 3 years ago

PRIMARY KEY is not key word in doris

rtttech commented 3 years ago

PRIMARY KEY is not key word in doris

How can I accomplish that?

HappenLee commented 3 years ago

PRIMARY KEY is not key word in doris

How can I accomplish that?

Maybe you should try the UNIQUE KEY table to simulate the PRIMARY KEY.