h**j
发帖数: 2033 | 1 cqlsh:testks> show version
[cqlsh 4.1.1 | Cassandra 2.0.6 | CQL spec 3.1.1 | Thrift protocol 19.39.0]
用了helenus和astyanax都一样，row key都是null，都指定了target version 1.2 和
CQL3.
[ ,
]
key作为一个column返回，by design? |
p*****2
发帖数: 21240 | 2
和
schema是什么？
感觉是by design吧。
【在 h**j 的大作中提到】
: cqlsh:testks> show version
: [cqlsh 4.1.1 | Cassandra 2.0.6 | CQL spec 3.1.1 | Thrift protocol 19.39.0]
: 用了helenus和astyanax都一样，row key都是null，都指定了target version 1.2 和
: CQL3.
: [ ,
: ]
: key作为一个column返回，by design?
|
w**z
发帖数: 8232 | 3 what was your query? describe table/cf?
和
【在 h**j 的大作中提到】
: cqlsh:testks> show version
: [cqlsh 4.1.1 | Cassandra 2.0.6 | CQL spec 3.1.1 | Thrift protocol 19.39.0]
: 用了helenus和astyanax都一样，row key都是null，都指定了target version 1.2 和
: CQL3.
: [ ,
: ]
: key作为一个column返回，by design?
|
h**j
发帖数: 2033 | 4 OperationResult> result = keyspace
.prepareQuery(cf).withCql(String.format("SELECT * FROM users
"))
.execute();
cqlsh:testks> DESCRIBE COLUMNFAMILY users;
CREATE TABLE users (
user_id int,
fname text,
lname text,
PRIMARY KEY (user_id)
) WITH
bloom_filter_fp_chance=0.010000 AND
caching='KEYS_ONLY' AND
comment='' AND
dclocal_read_repair_chance=0.000000 AND
gc_grace_seconds=864000 AND
index_interval=128 AND
read_repair_chance=0.100000 AND
replicate_on_write='true' AND
populate_io_cache_on_flush='false' AND
default_time_to_live=0 AND
speculative_retry='99.0PERCENTILE' AND
memtable_flush_period_in_ms=0 AND
compaction={'class': 'SizeTieredCompactionStrategy'} AND
compression={'sstable_compression': 'LZ4Compressor'};
【在 w**z 的大作中提到】
: what was your query? describe table/cf?
:
: 和
|
w**z
发帖数: 8232 | 5 rowkey is a hashed value, cql is misleading and I avoid using that. try cli
and see what that gives you.
users
【在 h**j 的大作中提到】
: OperationResult> result = keyspace
: .prepareQuery(cf).withCql(String.format("SELECT * FROM users
: "))
: .execute();
: cqlsh:testks> DESCRIBE COLUMNFAMILY users;
: CREATE TABLE users (
: user_id int,
: fname text,
: lname text,
: PRIMARY KEY (user_id)
|
g*****g
发帖数: 34805 | 6 Row key shouldn't be null. It's possible to get a row with all columns null
due to tombstone.
和
【在 h**j 的大作中提到】
: cqlsh:testks> show version
: [cqlsh 4.1.1 | Cassandra 2.0.6 | CQL spec 3.1.1 | Thrift protocol 19.39.0]
: 用了helenus和astyanax都一样，row key都是null，都指定了target version 1.2 和
: CQL3.
: [ ,
: ]
: key作为一个column返回，by design?
|
h**j
发帖数: 2033 | 7 明白大牛的意思了，这么看确实是by design。
cli
【在 w**z 的大作中提到】
: rowkey is a hashed value, cql is misleading and I avoid using that. try cli
: and see what that gives you.
:
: users
|
