DataStax Support Forums » Topic: integers inserted with cqlsh are not the same as integers inserted with hector

DataStax Support Forums » Topic: integers inserted with cqlsh are not the same as integers inserted with hector http://www.datastax.com/support-forums/topic/integers-inserted-with-cqlsh-are-not-the-same-as-integers-inserted-with-hector Software, Support, and Training for Apache Cassandra en-US Sat, 18 May 2013 16:09:50 +0000 http://bbpress.org/?v=1.0.3 <![CDATA[Search]]> q http://www.datastax.com/support-forums/search.php purblind on "integers inserted with cqlsh are not the same as integers inserted with hector" http://www.datastax.com/support-forums/topic/integers-inserted-with-cqlsh-are-not-the-same-as-integers-inserted-with-hector#post-1079 Wed, 01 Feb 2012 16:07:53 +0000 purblind 1079@http://www.datastax.com/support-forums/ description: setting integer column values with cqlsh does not return the same values when read back with Hector; cassandra version 1.0.7 hector version 1.0-2 mycf: 1-row, multi-column CF with integer values: ColumnFamily: mycf Key Validation Class: org.apache.cassandra.db.marshal.AsciiType Default column value validator: org.apache.cassandra.db.marshal.IntegerType Columns sorted by: org.apache.cassandra.db.marshal.UTF8Type Row cache size / save period in seconds / keys to save : 0.0/0/all Row Cache Provider: org.apache.cassandra.cache.SerializingCacheProvider Key cache size / save period in seconds: 200000.0/14400 GC grace seconds: 864000 Compaction min/max thresholds: 4/32 Read repair chance: 1.0 Replicate on write: true Bloom Filter FP chance: default Built indexes: [] cqlsh: update mycf set alt = 81001 where KEY = 'alt'; java: public void write(final String alt, final int hash) { final Mutator<String> mut = HFactory.createMutator( HFactory.createKeyspace("test", cluster), StringSerializer.get()); mut.addInsertion("alt", "mycf", HFactory.createColumn(alt, hash, StringSerializer.get(), IntegerSerializer.get())); mut.execute(); } public int read(final String alt) { final RangeSlicesQuery<String, String, Integer> query = HFactory .createRangeSlicesQuery( HFactory.createKeyspace("test", cluster), StringSerializer.get(), StringSerializer.get(), IntegerSerializer.get()).setColumnFamily("mycf") .setRange(null, null, false, 13).setColumnNames(alt); final ArrayList<Byte> arrayList = new ArrayList<Byte>(); Integer result = null; for (final Row<String, String, Integer> item : query.setRowCount(10) .execute().get().getList()) { final HColumn<String, Integer> i = item.getColumnSlice() .getColumnByName(alt); log.debug(Arrays.toString(i.getValueBytes().array())); result = i.getValue(); } return result; } writing an integer with hector, and reading with hector: [-128, 1, 0, 2, 0, 0, 0, 16, 103, 101, 116, 95, 114, 97, 110, 103, 101, 95, 115, 108, 105, 99, 101, 115, 0, 0, 0, 5, 15, 0, 0, 12, 0, 0, 0, 1, 11, 0, 1, 0, 0, 0, 3, 97, 108, 116, 15, 0, 2, 12, 0, 0, 0, 1, 12, 0, 1, 11, 0, 1, 0, 0, 0, 6, 68, 69, 78, 73, 83, 50, 11, 0, 2, 0, 0, 0, 4, 0, 1, 60, 105, 10, 0, 3, 0, 4, -73, -24, -127, -39, 107, -128, 0, 0, 0, 0] writing an integer with cqlsh, reading with hector: [-128, 1, 0, 2, 0, 0, 0, 16, 103, 101, 116, 95, 114, 97, 110, 103, 101, 95, 115, 108, 105, 99, 101, 115, 0, 0, 0, 3, 15, 0, 0, 12, 0, 0, 0, 1, 11, 0, 1, 0, 0, 0, 3, 97, 108, 116, 15, 0, 2, 12, 0, 0, 0, 1, 12, 0, 1, 11, 0, 1, 0, 0, 0, 6, 68, 69, 78, 73, 83, 50, 11, 0, 2, 0, 0, 0, 3, 1, 60, 105, 10, 0, 3, 0, 4, -73, -24, -111, 104, 96, 56, 0, 0, 0, 0]