0 Replies Latest reply: Aug 11, 2016 4:56 AM by christophe DELARBRE RSS

    [Qlik Sense - HIVE] - Problem Import Data with HIVE

    christophe DELARBRE

      Hello Experts,     

       

      I am new to QlikSense and trying to connect to a HIVE database with my qilkSense 2.2.4 Server.

       

      Here are the steps followed by me to connect

      On my windows 2012 R2 Server, I've created the ODBC connections (32/64 bits) successfully with ClouderaHiveODBC32.msi and ClouderaHiveODBC654.msi with the latest version 2.05.19 ODBC Drivers.

       

      But when I want to import data on my apps with the hive connection, it don't work , i have this error :

       

      10:48:52
      Connexion à HIVE en cours
      Connecté
      10:49:01
      SQL##f - SqlState: S1000, ErrorCode: 35, ErrorMsg: [Cloudera][Hardy] (35) Error from server: error code: '0' error message: 'ExecuteStatement finished with operation state: ERROR_STATE'.:

       

      The same connections with the same sql request is Ok on my QlikSense Desktop 3.0.

       

      Appreciate the help , Many Thanks!!

       

      Regards