SQL query error accessing Hive Tables from Teradata Studio

Teradata Studio
Teradata Employee

SQL query error accessing Hive Tables from Teradata Studio

Hi All,

 

I'm having some issues in querying Hive Tables (HDP 2.5, w/ Hive 1.2.1.2.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:tests.png

Has anyone encountered this type of behaviour before? 

 

Thanks.

 

-Ian

1 REPLY
Teradata Employee

Re: SQL query error accessing Hive Tables from Teradata Studio

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.