Cassandra:无法将 '2016-04-06 13:06:11.534000' 强制转换为格式化日期(长)

Question

我正在尝试使用 cqlsh 更新 cassandra DB 中的现有项目:

$ > UPDATE allEvents SET "isLastEvent" = True WHERE "websiteId" = 'sd-8231'
AND "purchaser" = False
AND "currentTime" = '2016-04-06 13:06:11.534000';

我得到了这个:

InvalidRequest: code=2200 [Invalid query] message="Unable to coerce '2016-04-06 13:06:11.534000' to a formatted date (long)"

如果它可以帮助:

$ > show version
[cqlsh 5.0.1 | Cassandra 3.0.2 | CQL spec 3.3.1 | Native protocol v4]

Answer 1

这是因为 Cassandra 时间戳类型仅支持毫秒。您的 currentTime 精度太高。去掉最后三个零，这样就可以了:

UPDATE allEvents SET "isLastEvent" = True 
WHERE "websiteId" = 'sd-8231'
      AND "purchaser" = False 
      AND "currentTime" = '2016-04-06 13:06:11.534';