3 Replies Latest reply on Aug 2, 2017 8:01 AM by lenaic.ridinger

how to access materialized views of cassandra table in tableau

SUMIT Goyal Jul 19, 2017 11:30 PM

I have created a materialized view of cassandra table able to access that in cassandra but when i try to access that in tableau with same login credentials . I am unable to find the same in tableau .

for eg: name of my Materialized view is my_view

now if i write a custom sql in tableau as select * from my_view

it gives no result instead throws an error.

1. Re: how to access materialized views of cassandra table in tableau

lenaic.ridinger Jul 27, 2017 5:34 AM (in response to SUMIT Goyal)

Hi SUMIT Goyal,

Could you please tell me the exact error message that you're receiving?
It would really help me investigating about your problem.

----------
Lénaïc RIÉDINGER, Global Community Engineer Tableau
Tableau Community Forums | Knowledge Base
If you see a Helpful or Correct response, please mark it thanks to the buttons below the targeted post!
Like Show 1 Likes(1)

Actions
2. Re: how to access materialized views of cassandra table in tableau

SUMIT Goyal Jul 27, 2017 11:01 PM (in response to lenaic.ridinger)

Hi Lenaic Riedinger ,
Thanks for quick response Below is the screenshot of the error i receive .Hope this gives more clarity to resolve my issue.
Error :-[DataStax][CassandraODBC] (10) Error while executing a query in Cassandra: [33562624] : line 1:11 no viable alternative at input '1' (SELECT [TOP] 1...)
Unable to connect using the DSN named "Datastax Cassandra ODBC DSN". Check that the DSN exists and is a valid connection.
Like Show 0 Likes(0)

Actions
3. Re: how to access materialized views of cassandra table in tableau

lenaic.ridinger Aug 2, 2017 8:01 AM (in response to SUMIT Goyal)

That might be a compatibility issue.
Have you tried another connector like Simba ODBC, for the DSN connection?
I have two customers with the same issue these last 3 years reporting they succeeded with Simba.

Let me know how it goes
1 of 1 people found this helpful
Like Show 1 Likes(1)

Actions

Go to original post