I'm having some issues in querying Hive Tables (HDP 2.5, w/ Hive 22.214.171.124.5) from Teradata Studio 16.10:
These SELECT queries works fine:
select * from databasename.tablename limit 1
select * from databasename.tablename
select column_a from databasename.tablename
These SELECT COUNT queries fail:
select count(*) from databasename.tablename
select count(column_a) from databasename.tablename
select count(1) from databasename.tablename
Executed as Single statement. Failed [1 : 08S01] Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask
Elapsed time = 00:00:00.094
STATEMENT 1: SELECT Statement failed.
Default Teradata Studio/JDBC settings & plugins were used:
Has anyone encountered this type of behaviour before?
We have not seeen this error before. We are able to run queries successfully on HDP 2.5 machine. Looking into this issue
and will update you with our findings.