Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I am trying to connect to cassandra from Qlikview personal edition.
Qlikview personal edition : 11.20.12904.0 SR12 64-bit
Cassandra version : 2.1.8
Cassandra table :
CREATE TABLE analytics.sample (
a int PRIMARY KEY,
b int,
c int
) WITH bloom_filter_fp_chance = 0.01
AND caching = '{"keys":"ALL", "rows_per_partition":"NONE"}'
AND comment = ''
AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCom
pactionStrategy'}
AND compression = {'sstable_compression': 'org.apache.cassandra.io.compress.
LZ4Compressor'}
AND dclocal_read_repair_chance = 0.1
AND default_time_to_live = 0
AND gc_grace_seconds = 864000
AND max_index_interval = 2048
AND memtable_flush_period_in_ms = 0
AND min_index_interval = 128
AND read_repair_chance = 0.0
AND speculative_retry = '99.0PERCENTILE';
Qlikview script :
ODBC CONNECT TO [DataStax Cassandra ODBC DSN64];
LOAD a, b, c;
SQL SELECT * FROM Cassandra.analytics.sample;
Error :
Field not found - <a>
SQL SELECT * FROM Cassandra.analytics.sample
Please help.
Hello!
Try it:
LOAD *;
SQL SELECT * FROM Cassandra.analytics.sample;
something you can try is to do a Select * ..... and then build a table box and move the dimensions over - this will tell you if you are even retrieving the fields youa re expecting
Hi Sergey, thanks for quick response.
Tried the way you said, error is :
SQL##f - SqlState: S1010, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] Function sequence error
SQL SELECT * FROM Cassandra.analytics.sample
Hi,
thanks for responses.
I am able to retrieve the data using ODBC driver from Simba. (but it is paid version )
http://www.simba.com/connectors/apache-cassandra-odbc
Previously I had used ODBC driver from DataStax (using which I was not able to retrieve data from cassandra)
Did any body succeed in data retrieval from cassandra using DataStax ODBC driver?