Field not found while executing script

[#1]

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.

[pokassov]

Hello!

Try it:

LOAD *;

SQL SELECT * FROM Cassandra.analytics.sample;

[#3]

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

[#4]

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

[#5]

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)

The DataStax ODBC driver with CQL connector for Apache Cassandra and DataStax Enterprise Available N...

Did any body succeed in data retrieval from cassandra using DataStax ODBC driver?