Cassandra数据存储大小写问题

深藏阁楼爱情的钟 2022-06-14 23:56 214阅读 0赞

cassandra是大小写不敏感（存储或显示），默认是把数据按小写存储或显示（包括keyspace name, table name, 字段名）

![20170518110315782][]

<table style="border-spacing:0px; border-collapse:collapse; margin-bottom:20px; table-layout:fixed; width:750px; max-width:100%; color:rgb(55,76,81); font-family:HelveticaNeueLTStd-Roman,&quot;Helvetica Neue&quot;,helvetica,arial,clean,sans-serif; font-size:16px; margin-top:12px!important"> 
 <thead style="background:none rgb(249,248,247)"> 
  <tr style=""> 
   <th style="padding:8px; text-align:left; border-top-width:0px; border-right-width:1px; border-bottom-width:2px; border-left-width:initial; border-top-style:initial; border-right-style:solid; border-bottom-style:solid; border-left-style:none; border-color:inherit; word-wrap:break-word; line-height:1.42857; vertical-align:top"> Queries that Work</th> 
   <th style="padding:8px; text-align:left; border-top-width:0px; border-right-width:1px; border-bottom-width:2px; border-left-width:initial; border-top-style:initial; border-right-style:solid; border-bottom-style:solid; border-left-style:none; border-color:inherit; word-wrap:break-word; line-height:1.42857; vertical-align:top"> Queries that Don't Work</th> 
  </tr> 
 </thead> 
 <tbody style=""> 
  <tr style=""> 
   <td style="padding:8px; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-left-width:initial; border-style:solid solid solid none; border-color:inherit; word-wrap:break-word; line-height:1.42857; vertical-align:top"> SELECT foo FROM . . .</td> 
   <td style="padding:8px; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-left-width:initial; border-style:solid solid solid none; border-color:inherit; word-wrap:break-word; line-height:1.42857; vertical-align:top"> SELECT "Foo" FROM . . .</td> 
  </tr> 
  <tr style=""> 
   <td style="padding:8px; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-left-width:initial; border-style:solid solid solid none; border-color:inherit; word-wrap:break-word; line-height:1.42857; vertical-align:top"> SELECT Foo FROM . . .</td> 
   <td style="padding:8px; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-left-width:initial; border-style:solid solid solid none; border-color:inherit; word-wrap:break-word; line-height:1.42857; vertical-align:top"> SELECT "BAR" FROM . . .</td> 
  </tr> 
  <tr style=""> 
   <td style="padding:8px; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-left-width:initial; border-style:solid solid solid none; border-color:inherit; word-wrap:break-word; line-height:1.42857; vertical-align:top"> SELECT FOO FROM . . .</td> 
   <td style="padding:8px; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-left-width:initial; border-style:solid solid solid none; border-color:inherit; word-wrap:break-word; line-height:1.42857; vertical-align:top"> SELECT bar FROM . . .</td> 
  </tr> 
  <tr style=""> 
   <td style="padding:8px; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-left-width:initial; border-style:solid solid solid none; border-color:inherit; word-wrap:break-word; line-height:1.42857; vertical-align:top"> SELECT "Bar" FROM . . .</td> 
   <td style="padding:8px; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-left-width:initial; border-style:solid solid solid none; border-color:inherit; word-wrap:break-word; line-height:1.42857; vertical-align:top"> SELECT Bar FROM . . .</td> 
  </tr> 
  <tr style=""> 
   <td style="padding:8px; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-left-width:initial; border-style:solid solid solid none; border-color:inherit; word-wrap:break-word; line-height:1.42857; vertical-align:top"> SELECT "foo" FROM . . .</td> 
   <td style="padding:8px; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-left-width:initial; border-style:solid solid solid none; border-color:inherit; word-wrap:break-word; line-height:1.42857; vertical-align:top"> SELECT "bar" FROM . . .</td> 
  </tr> 
 </tbody> 
</table>

官方说如果想用大写，加双引号转义，试了一把：

![20170518110924745][]

感觉其实就是把双引号一块存储了（不知道我有没有理解错）

另：

CQL的关键词是不区分大小写。

更详细请见：http://docs.datastax.com/en/cql/3.3/cql/cql\_reference/ucase-lcase\_r.html

[20170518110315782]: /images/20220615/d0ab7342622d42fb85c12e91b738fa4a.png
[20170518110924745]: /images/20220615/146daef16ddb4d10a2d344678c06ac8c.png