AnsweredAssumed Answered

Problem in connecting from Tableau to MapR on Amazon EMR

Question asked by eranb on Aug 17, 2014
Latest reply on Jan 17, 2017 by kburri
Hi,
I have Amazon EMR with MapR M5. I created an external table from file on S3. When I try to connect the table from Tableau, I get the table metadata, but when I try to fetch the data I get this error:

> [MapR][HiveODBC] (22) Error from
> ThriftHiveClient: Query returned
> non-zero code: 1, cause: FAILED:
> Execution Error, return code 1 from
> org.apache.hadoop.hive.ql.exec.MapRedTask

When I use the ODBC Query Tool 1.38, I can fetch the data, but when I run `SELECT COUNT(*) FROM t1` I get the same error.
Does anyone know why MapR ODBC cannot do count(*), and is that related to my Tableau problem?

Thanks, Eran.

Outcomes