![]() connection-dialectgoogle-bql This has to be done in every tableau workbook. Method 1: Edit the tableau file in a text editor and change the SQL connection dialect from google-sql to google-bql. You will embark on this exciting journey by getting to. Changing the tableau datasource settings to use google-bql (legacy sql) resolved the issue. This book will empower you to become a master in Tableau by exploiting the many new features introduced in Tableau 10.0. Seems like ODBC driver was not able to compose the right CQL query. Tableau has emerged as one of the most popular Business Intelligence solutions in recent times, thanks to its powerful and interactive data visualization capabilities. Oct 14 14:39:56.491 ERROR 6112 Statement::SQLPrepareW: (10) Error while executing a query in Cassandra: : line 1:7 no viable alternative at input '1' (SELECT 1) Oct 14 14:25:04.869 ERROR 5376 Statement::SQLPrepareW: (10) Error while executing a query in Cassandra: : line 1:7 no viable alternative at input '1' (SELECT 1) In the Connect Using section, select the DSN that connects to the Hive table. In the On a server section, click Other Databases (ODBC).The Generic ODBC Connection dialog appears. ![]() In Tableau, click Data > Connect to Data. Here are the error logs from Datastax ODBC driver: Step 2: Connect to Hive Tables in Tableau. I tried both 10.0 and 8.3 version of Tableau, neither work. For a complete list of Tableau supported data source, click here. In Tableau Prep Builder you can connect to many of the same data sources available in Tableau Desktop, Server and Online. hyper) and CSV files that can be used in Tableau 10.0 and later versions of Tableau. I was able to connect to Cassandra from Datastax DevCenter, so I think the problem is either on Tableau end or the driver itself. It can create Tableau Extracts (.tde and. The connection to Cassandra was successful when I tested from ODBC Data Source Administrator.īut when I tried to connect from Tableau, I got this error: New Ivanti Security Controls Content Available. For Tableau 9.0 Desktop, Drill Version 0.9 or higher is recommended. Posted on Jby shavlikdatateam, Patch and Bulletin Information. For the best experience use the latest release of Apache Drill. Drill uses standard ODBC connectivity to provide easy data-exploration capabilities on complex, schema-less data sets. I installed Datastax ODBC driver 2.4 (64 bit), and configured DSN(Data Source Name). Step 1: Install and Configure the MapR Drill ODBC Driver ¶. ![]() I was trying to connect Tableau with Cassandra.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |