Tableau desktop Hortnworks Hive Connection
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….