From commits-return-2189-archive-asf-public=cust-asf.ponee.io@druid.apache.org Mon Sep 3 22:20:18 2018 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id 260AC180663 for ; Mon, 3 Sep 2018 22:20:17 +0200 (CEST) Received: (qmail 19603 invoked by uid 500); 3 Sep 2018 20:20:17 -0000 Mailing-List: contact commits-help@druid.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@druid.apache.org Delivered-To: mailing list commits@druid.apache.org Received: (qmail 19594 invoked by uid 99); 3 Sep 2018 20:20:17 -0000 Received: from ec2-52-202-80-70.compute-1.amazonaws.com (HELO gitbox.apache.org) (52.202.80.70) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 Sep 2018 20:20:17 +0000 From: GitBox To: commits@druid.apache.org Subject: [GitHub] egor-ryashin opened a new issue #6293: Cannot select columns from group by subquery Message-ID: <153600601671.908.11057794945204654669.gitbox@gitbox.apache.org> Date: Mon, 03 Sep 2018 20:20:16 -0000 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit egor-ryashin opened a new issue #6293: Cannot select columns from group by subquery URL: https://github.com/apache/incubator-druid/issues/6293 Query like this fails: ```sql select cn from (select cn, count(*) cnt from dt WHERE __time > TIMESTAMP '2018-09-01 13:00:00' group by cn limit 10) ``` ``` {"error":"Unknown exception","errorMessage":"Cannot build plan for query: select cn from (select cn, count(*) cnt from dt WHERE __time > TIMESTAMP '2018-09-01 13:00:00' group by cn limit 10) ``` While `*` works: ```sql select * from (select cn, count(*) cnt from dt WHERE __time > TIMESTAMP '2018-09-01 13:00:00' group by cn limit 10) ``` Removal of `count(*)` also works: ```sql select cn from (select cn from dt WHERE __time > TIMESTAMP '2018-09-01 13:00:00' group by cn limit 10) ``` ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: users@infra.apache.org With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org For additional commands, e-mail: commits-help@druid.apache.org