以下似乎有效。你的WHERE
你的状况SELECT
语句可能试图访问不正确的十六进制0x0b5db8b91bfdeb0a304b372dd8dda123b3fd1ab6
.
DROP KEYSPACE example;
CREATE KEYSPACE example WITH replication = {'class':'SimpleStrategy', 'replication_factor':1};
USE example;
CREATE TABLE IF NOT EXISTS test_by_score (
commit blob, -- blob representing the commit hash
delta int, -- how much the scores have changed
score int, -- the test score, which is determined by the client
test blob, -- blob for the test
PRIMARY KEY(commit, delta, test)
);
INSERT INTO test_by_score (commit, delta, test, score) VALUES
(textAsBlob('bdb14fbe076f6b94444c660e36a400151f26fc6f'), 0, textAsBlob('{"prefix": "enwiki", "title": "\"Aghnadarragh\""}'), 100
);
INSERT INTO test_by_score (commit, delta, test, score) VALUES (
textAsBlob('cdb14fbe076f6b94444c660e36a400151f26fc6f'), 0, textAsBlob('{"prefix": "enwiki", "title": "\"Aghnadarragh\""}'), 100
);
INSERT INTO test_by_score (commit, delta, test, score) VALUES (
textAsBlob('adb14fbe076f6b94444c660e36a400151f26fc6f'), 0, textAsBlob('{"prefix": "enwiki", "title": "\"Aghnadarragh\""}'), 100
);
抓取所有行
SELECT * FROM example.test_by_score
选择特定行。
SELECT * FROM example.test_by_score
WHERE commit = 0x62646231346662653037366636623934343434633636306533366134303031353166323666633666;