When I attempt to' join' tables or even use 'group by', I get the following error:
Hortonworks Hive DSN -- [Hortonworks][Hardy] (35) Error from server: error code: '1' error message: 'Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask'.(HY000,35)
Yet, I am able to do a simple 'select-from-where' query with no problem.
I am using the IDE Rapid SQL.
Any idea of what is going on?