Hive / HCatalog Forum

Tableau desktop Hortnworks Hive Connection

  • #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

to create new topics or reply. | New User Registration

You must be to reply to this topic. | Create Account

Support from the Experts

A HDP Support Subscription connects you experts with deep experience running Apache Hadoop in production, at-scale on the most demanding workloads.

Enterprise Support »

Become HDP Certified

Real world training designed by the core architects of Hadoop. Scenario-based training courses are available in-classroom or online from anywhere in the world

Training »

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.