Tableau desktop Hortnworks Hive Connection

to create new topics or reply. | New User Registration

This topic contains 0 replies, has 1 voice, and was last updated by  Anupam Gupta 1 year, 9 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 to reply to this topic. | Create Account

Hortonworks Data Platform
The Hortonworks Data Platform is a 100% open source distribution of Apache Hadoop that is truly enterprise grade having been built, tested and hardened with enterprise rigor.
Get started with Sandbox
Hortonworks Sandbox is a self-contained virtual machine with Apache Hadoop pre-configured alongside a set of hands-on, step-by-step Hadoop tutorials.
Modern Data Architecture
Tackle the challenges of big data. Hadoop integrates with existing EDW, RDBMS and MPP systems to deliver lower cost, higher capacity infrastructure.