3 Replies Latest reply on Mar 29, 2013 6:48 PM by rareddy

    Hive/Hadoop

    pinkstondevin

      I'm trying to connect to a HIVE/Hadoop and I am having trouble getting through.  I am going to combine it with a MySQL datasource that I have successfully connected and integrated into my VDB.  Generally I keep receiving this error:

      "JBAS010440: failed to invoke operation: JBAS010442: failed to match pool. Check JndiName: java:/hive"

       

      I have tried using the driver as mentioned online through the JBOSS docs but haven't had any luck.

       

      Any insight?

       

      Thanks

        • 1. Re: Hive/Hadoop
          pinkstondevin

          Update,

           

          I got the driver sorted out, and a datasorce enabled to connect.

           

          However now i am just having trouble establishing connection to the hive server.  Has anyone had any experience with this?  I am running Teiid locally and trying to connect to a remote Hive.

           

          Thanks

          • 2. Re: Hive/Hadoop
            pinkstondevin

            I beleive I am on the right track now, but for some reason I am having trouble connecting to a running remote Hive.

             

            I have the same setup as the Teiid documents, just instead of the URL being local host I have the correct IP address used.

             

            The error I'm receiving:

             

            "failure-description" => "JBAS010440: failed to invoke operation: JBAS010447: Connection is not valid"

             

            Does this sound like an error on my end?  Or has someone had experience with this?

            • 3. Re: Hive/Hadoop
              rareddy

              Anything in logs? Try the same in JDBC client like SquirreL and see if you can connect correctly with same url, user and passwd.