4 Replies Latest reply on Nov 18, 2014 10:19 PM by Jay Rosenthal

    Error while using Impala to connect to Cloudera Hadoop

    Sudhakar GS

      I am working on using Tableau to connect to Cloudera Hadoop. I provide the server and port details and connect using "Impala". I am able to succesfully connect, select default Schema and choose the required table (s).

       

      After this, when I drag and drop either a dimension or a measure to Rows/Columns on the 'grid', i get the below error:

       

      [Cloudera][Hardy] (22) Error from ThriftHiveClient: Query returned non-zero code: 10025, cause: FAILED: SemanticException [Error 10025]: Line 1:7 Expression not in GROUP BY key '`<column name>`'.

       

      However, if i try the same using the connection type as 'HiveServer' (not 'Impala'), it works fine. We are not sure where we are going wrong.

       

      Any help on this is very much appreciated?

       

      Thanks.

       

      Regards,

      Sudhakar