Here is my SQL statement:
my_table has more than 10 columns (for example, day, ip_address, user, request, etc.), including strings and numbers. I want to GROUP by & HAVE based on the column & # 39; ip_address & # 39;, if more than 20 records.
SELECT day, ip_address, user, request FROM my_table WHERE DAY = current_date() GROUP BY ip_address HAVING count(client_ip)>20
I have this error message
Error while compiling statement: FAILED: SemanticException (Error 10025): Expression not in GROUP BY key xxx
But I have to keep all the columns.