Home Forums Hive / HCatalog Tableau desktop Hortnworks Hive Connection

This topic contains 0 replies, has 1 voice, and was last updated by  Anupam Gupta 10 months ago.

  • Creator
    Topic
  • #38905

    Anupam Gupta
    Participant

    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

You must be logged in to reply to this topic.