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 successfully 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 ''.
I saw several similar problems on the forum, but none of them got the solution Any help on this is very much appreciated?