3 Replies Latest reply on Jun 17, 2014 12:23 AM by Ravi Itha

    Tableau desktop Hortnworks Hive Connection

    Nitin Dubey

      Hi All,

       

      I am able to connect Tableau desktop (Installed on my local windows machine) to Hortnworks Hive which is on AWS EC2.

      I am able to connect to my database and able to see list of all tables;

      But in not able to see data of a particular table , getting following error.

       

      [Hortonworks][Hardy] (35) Error from Hive: error code: '40000' error message: 'Error while processing statement: FAILED: RuntimeException MetaException(message:org.apache.hadoop.hive.serde2.SerDeException SerDe com.bizo.hive.serde.csv.CSVSerde does not exist)'.

       

      The table "[default].[resume]" does not exist.

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

       

      I am run following statement in Initial sql

      add jar /usr/local/csv-serde.jar;

      select * from resume;

      getting same error....

      kindly help

       

      Thanks,

      Sandeep