无法创建带有注释的表 [英] Unable to create a table with comment
本文介绍了无法创建带有注释的表的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我试图创建一个表并想在架构中添加注释,但语法不正确。
I am trying to create a table and want to add a comment in the schema but I am not able to get the syntax correct.
CREATE TABLE codingjedi.practice_questions_javascript_tag(
year bigint,
month bigint,
creation_time_hour bigInt,
creation_time_minute bigInt,
id uuid,
PRIMARY KEY ((year, month), creation_time_hour, creation_time_minute)
) WITH comment = 'some comment' CLUSTERING ORDER BY (creation_time_hour DESC, creation_time_minute ASC)
推荐答案
我不得不使用 AND
来组合两条指令
I had to use AND
to combine the two instruction
CREATE TABLE codingjedi.practice_questions_javascript_tag(
year bigint,
month bigint,
creation_time_hour bigInt,
creation_time_minute bigInt,
id uuid,
PRIMARY KEY ((year,month), creation_time_hour, creation_time_minute, id )
) WITH comment = 'some comment' AND CLUSTERING ORDER BY (creation_time_hour DESC, creation_time_minute ASC, question_id ASC);
这篇关于无法创建带有注释的表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文