2 Replies Latest reply on Nov 24, 2016 5:00 AM by nisha saini

    Cannot connect to DB using hive connector

    nisha saini

      hi

      I need to connect my Tableau desktop with a Hadoop DB using hive connector. Though I am able to telnet the DB port but while using MapR hive connector getting the below error:

       

      Unable to connect to the ODBC Data Source. Check that the necessary drivers are installed and that the connection properties are valid.

      [MapR][HiveODBC] (68) Error returned trying to set default as the initial database: No more data to read.; Also tried quoting the database name `default` but the query failed with the following error: No more data to read.

      Unable to connect to the server "<DB_url>". Check that the server is running and that you have access privileges to the requested database.

       

      Also tried using other 2 hive connectors: Cloudera and hortonworks. But none worked. Please suggest how this can be done.