Hi,
I have some trouble to request my data. I use SSTableSimpleUnsortedWriter to
write SSTable. Writing and Importing works fine.
I think, I'm misusing CompositeType.Builder with SSTableSimpleUnsortedWriter.
Do you have any idea ?
Thanks
Here is my case :
/**
* CREATE STATEMENT
*/
CREATE TABLE raw_data (
id text,
date text,
request text,
data1 text,
data2 text,
PRIMARY KEY (id, date, request)
) 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
read_repair_chance=0.100000 AND
replicate_on_write='true' AND
compaction={'class': 'SizeTieredCompactionStrategy'} AND
compression={'sstable_compression': 'SnappyCompressor'};
/**
* JAVA CODE
*/
List<AbstractType<?>> compositeList = new ArrayList<AbstractType<?>>();
compositeList.add(UTF8Type.instance);
compositeList.add(UTF8Type.instance);
IPartitioner<?> partitioner = StorageService.getPartitioner();
dir = Directories.create(keyspace.getKeyspaceName(),
columnFamily.getName()).getDirectoryForNewSSTables(0);
simpleUnsortedWriter = new SSTableSimpleUnsortedWriter(dir,
partitioner,
keyspace.getKeyspaceName(),
columnFamily.getName(), UTF8Type.instance, null,
32);
CompositeType.Builder builderRequestDate = new CompositeType.Builder(
CompositeType.getInstance (compositeList) );
CompositeType.Builder builderUrl = new CompositeType.Builder(
CompositeType.getInstance(compositeList) );
simpleUnsortedWriter.newRow(bytes(id));
builderRequestDate.add(bytes("date"));
builderRequestDate.add(bytes("request"));
long timestamp = System.currentTimeMillis() * 1000;
simpleUnsortedWriter.addColumn(builderRequestDate.build(),
bytes(date), timestamp);
simpleUnsortedWriter.addColumn(builderUrl.build(),
bytes(request), timestamp);
simpleUnsortedWriter.addColumn(bytes("data1"),
bytes(data1), timestamp);
simpleUnsortedWriter.addColumn(bytes("data2"),
bytes(data2), timestamp);
simpleUnsortedWriter.close();
________________________________
Laurent Pouget
Ingénieur étude et développement
Tel : 01.84.95.11.20
Car & Boat Media
22 Rue Joubert 75009 Paris