You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2021/04/05 03:38:51 UTC

[GitHub] [incubator-doris] rtttech opened a new issue #5598: can not create a table with primary key

rtttech opened a new issue #5598:
URL: https://github.com/apache/incubator-doris/issues/5598


   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));


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


[GitHub] [incubator-doris] HappenLee commented on issue #5598: can not create a table with primary key

Posted by GitBox <gi...@apache.org>.
HappenLee commented on issue #5598:
URL: https://github.com/apache/incubator-doris/issues/5598#issuecomment-814941917


   > > 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.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


[GitHub] [incubator-doris] rtttech commented on issue #5598: can not create a table with primary key

Posted by GitBox <gi...@apache.org>.
rtttech commented on issue #5598:
URL: https://github.com/apache/incubator-doris/issues/5598#issuecomment-813875141


   > PRIMARY KEY is not key word in doris
   
   How  can I accomplish that?


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


[GitHub] [incubator-doris] yangzhg commented on issue #5598: can not create a table with primary key

Posted by GitBox <gi...@apache.org>.
yangzhg commented on issue #5598:
URL: https://github.com/apache/incubator-doris/issues/5598#issuecomment-813764976


    PRIMARY KEY is not key word in doris


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org