Install DataStax and deploy the following schema:
USE "PortfolioDemo";
CREATE TABLE "HistLoss" (
key text,
column1 text,
value text,
PRIMARY KEY (key, column1)
) WITH COMPACT STORAGE AND
bloom_filter_fp_chance=0.010000 AND
caching='KEYS_ONLY' AND
comment='' AND
dclocal_read_repair_chance=0.000000 AND
gc_grace_seconds=60 AND
read_repair_chance=1.000000 AND
replicate_on_write='true' AND
populate_io_cache_on_flush='false' AND
compaction=
{'class': 'SizeTieredCompactionStrategy'}
AND
compression=
{'sstable_compression': 'SnappyCompressor'}
;
CREATE TABLE "Portfolios" (
key bigint,
column1 text,
value double,
PRIMARY KEY (key, column1)
) WITH COMPACT STORAGE AND
bloom_filter_fp_chance=0.010000 AND
caching='KEYS_ONLY' AND
comment='' AND
dclocal_read_repair_chance=0.000000 AND
gc_grace_seconds=60 AND
read_repair_chance=1.000000 AND
replicate_on_write='true' AND
populate_io_cache_on_flush='false' AND
compaction=
{'class': 'SizeTieredCompactionStrategy'}
AND
compression=
{'sstable_compression': 'SnappyCompressor'}
;
CREATE TABLE "StockHist" (
key text,
column1 text,
value double,
PRIMARY KEY (key, column1)
) WITH COMPACT STORAGE AND
bloom_filter_fp_chance=0.010000 AND
caching='KEYS_ONLY' AND
comment='' AND
dclocal_read_repair_chance=0.000000 AND
gc_grace_seconds=60 AND
read_repair_chance=1.000000 AND
replicate_on_write='true' AND
populate_io_cache_on_flush='false' AND
compaction=
{'class': 'SizeTieredCompactionStrategy'}
AND
compression=
{'sstable_compression': 'SnappyCompressor'}
;
CREATE TABLE "Stocks" (
key text,
column1 text,
value double,
PRIMARY KEY (key, column1)
) WITH COMPACT STORAGE AND
bloom_filter_fp_chance=0.010000 AND
caching='KEYS_ONLY' AND
comment='' AND
dclocal_read_repair_chance=0.000000 AND
gc_grace_seconds=60 AND
read_repair_chance=1.000000 AND
replicate_on_write='true' AND
populate_io_cache_on_flush='false' AND
compaction=
{'class': 'SizeTieredCompactionStrategy'}
AND
compression=
{'sstable_compression': 'SnappyCompressor'}
;
Tried to access through teiid and got the following exception:
It still doesn't work in 8.7 CR2. It got different exception now:
java.lang.NullPointerException
at org.teiid.metadata.MetadataFactory.addColumn(MetadataFactory.java:204)
at org.teiid.translator.cassandra.CassandraMetadataProcessor.addColumnsToTable(CassandraMetadataProcessor.java:101)
at org.teiid.translator.cassandra.CassandraMetadataProcessor.addTable(CassandraMetadataProcessor.java:63)
at org.teiid.translator.cassandra.CassandraMetadataProcessor.process(CassandraMetadataProcessor.java:50)
at org.teiid.translator.cassandra.CassandraMetadataProcessor.process(CassandraMetadataProcessor.java:42)
at org.teiid.translator.ExecutionFactory.getMetadata(ExecutionFactory.java:915)
at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:73)
at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55)
at org.teiid.runtime.EmbeddedServer.loadMetadata(EmbeddedServer.java:685)
at org.teiid.runtime.AbstractVDBDeployer.loadMetadata(AbstractVDBDeployer.java:161)
at org.teiid.runtime.EmbeddedServer.deployVDB(EmbeddedServer.java:635)
at org.teiid.runtime.EmbeddedServer.deployVDB(EmbeddedServer.java:547)