topic Re: Field not found while executing script in QlikView

Field not found while executing script

Thu, 03 Dec 2015 13:46:37 GMT

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.

Re: Field not found while executing script

pokassov — Thu, 03 Dec 2015 14:52:46 GMT

Hello!

Try it:

LOAD *;

SQL SELECT * FROM Cassandra.analytics.sample;

Re: Field not found while executing script

Thu, 03 Dec 2015 14:52:59 GMT

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

Re: Field not found while executing script

Thu, 03 Dec 2015 14:59:41 GMT

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

Re: Field not found while executing script

Fri, 04 Dec 2015 09:58:22 GMT

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 Now | DataStax

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