From dev-return-14033-apmail-drill-dev-archive=drill.apache.org@drill.apache.org Wed Jun 3 01:01:50 2015 Return-Path: X-Original-To: apmail-drill-dev-archive@www.apache.org Delivered-To: apmail-drill-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id E2A9617F7F for ; Wed, 3 Jun 2015 01:01:49 +0000 (UTC) Received: (qmail 52151 invoked by uid 500); 3 Jun 2015 01:01:49 -0000 Delivered-To: apmail-drill-dev-archive@drill.apache.org Received: (qmail 52091 invoked by uid 500); 3 Jun 2015 01:01:49 -0000 Mailing-List: contact dev-help@drill.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@drill.apache.org Delivered-To: mailing list dev@drill.apache.org Received: (qmail 52064 invoked by uid 99); 3 Jun 2015 01:01:49 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 03 Jun 2015 01:01:49 +0000 Date: Wed, 3 Jun 2015 01:01:49 +0000 (UTC) From: "Jinfeng Ni (JIRA)" To: dev@drill.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Created] (DRILL-3248) Explain CTAS statement support MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 Jinfeng Ni created DRILL-3248: --------------------------------- Summary: Explain CTAS statement support Key: DRILL-3248 URL: https://issues.apache.org/jira/browse/DRILL-3248 Project: Apache Drill Issue Type: New Feature Components: Query Planning & Optimization Reporter: Jinfeng Ni Assignee: Jinfeng Ni Currently, only SELECT query could be put in EXPLAIN statement, and Drill does not support EXPLAIN CTAS statement. One option would be to EXPLAIN the select_query in CTAS directly. However, with the partition by clause added in CTAS, it's not possible to do so any more, since there is no corresponding "PARTITION BY" clause in the SELECT query. Therefore, it is important to extend EXPLAIN to accept CTAS directly. -- This message was sent by Atlassian JIRA (v6.3.4#6332)