Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id EDBF4200D33 for ; Wed, 8 Nov 2017 20:14:04 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id EC2D2160BDA; Wed, 8 Nov 2017 19:14:04 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 3E9D41609E0 for ; Wed, 8 Nov 2017 20:14:04 +0100 (CET) Received: (qmail 35726 invoked by uid 500); 8 Nov 2017 19:14:03 -0000 Mailing-List: contact reviews-help@impala.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Delivered-To: mailing list reviews@impala.incubator.apache.org Received: (qmail 35715 invoked by uid 99); 8 Nov 2017 19:14:03 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 08 Nov 2017 19:14:03 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 5FD9B18077C for ; Wed, 8 Nov 2017 19:14:02 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.362 X-Spam-Level: ** X-Spam-Status: No, score=2.362 tagged_above=-999 required=6.31 tests=[HTML_MESSAGE=2, RDNS_DYNAMIC=0.363, SPF_PASS=-0.001] autolearn=disabled Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id n8xUG1XTKaUN for ; Wed, 8 Nov 2017 19:14:01 +0000 (UTC) Received: from ip-10-146-233-104.ec2.internal (ec2-75-101-130-251.compute-1.amazonaws.com [75.101.130.251]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 61A1E5FCC4 for ; Wed, 8 Nov 2017 19:14:00 +0000 (UTC) Received: from localhost (localhost [127.0.0.1]) by ip-10-146-233-104.ec2.internal (8.14.4/8.14.4) with ESMTP id vA8JDw3n015100; Wed, 8 Nov 2017 19:13:58 GMT Message-Id: <201711081913.vA8JDw3n015100@ip-10-146-233-104.ec2.internal> X-Gerrit-PatchSet: 2 Date: Wed, 8 Nov 2017 19:13:57 +0000 From: "Csaba Ringhofer (Code Review)" To: impala-cr@cloudera.com, reviews@impala.incubator.apache.org X-Gerrit-MessageType: newpatchset Subject: =?UTF-8?Q?=5BImpala-ASF-CR=5D_IMPALA-4167=3A_Support_insert_plan_hints_for_CREATE_TABLE_AS_SELECT=0A?= X-Gerrit-Change-Id: I8d74bca999da8ae1bb89427c70841f33e3c56ab0 X-Gerrit-Change-Number: 8400 X-Gerrit-ChangeURL: X-Gerrit-Commit: c7450829bb60a50132acb2bd57de02b57f86c414 In-Reply-To: References: Reply-To: csringhofer@cloudera.com, impala-cr@cloudera.com, marcelk@gmail.com, reviews@impala.incubator.apache.org MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Content-Disposition: inline User-Agent: Gerrit/2.14.2 Content-Type: multipart/alternative; boundary="jkxPljtHSfY="; charset=UTF-8 archived-at: Wed, 08 Nov 2017 19:14:05 -0000 --jkxPljtHSfY= Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Csaba Ringhofer has uploaded a new patch set (#2)=2E ( http://gerrit=2Eclou= dera=2Eorg:8080/8400 ) Change subject: IMPALA-4167: Support insert plan hi= nts for CREATE TABLE AS SELECT =2E=2E=2E=2E=2E=2E=2E=2E=2E=2E=2E=2E=2E=2E= =2E=2E=2E=2E=2E=2E=2E=2E=2E=2E=2E=2E=2E=2E=2E=2E=2E=2E=2E=2E=2E=2E=2E=2E=2E= =2E=2E=2E=2E=2E=2E=2E=2E=2E=2E=2E=2E=2E=2E=2E=2E=2E=2E=2E=2E=2E=2E=2E=2E=2E= =2E=2E=2E=2E=2E=2E IMPALA-4167: Support insert plan hints for CREATE TABLE= AS SELECT Adding support for "clustered", "noclustered", "shuffle" and "n= oshuffle" hints in CTAS statement=2E example: create /*+ clustered,noshuff= le */ table t partitioned by (year, month) as select * from functional=2Eal= ltypes The effect of these hints are the same as in insert statements: cl= ustered: sort by partition columns before insert to make the insert more ef= ficient noclustered: currently no effect, as this is the default behaivour= shuffle: add exchenge node before insert even in case of unpartitioned ta= bles noshuffle: do not add exchange node before insert to partitioned tabl= es Change-Id: I8d74bca999da8ae1bb89427c70841f33e3c56ab0 --- M fe/src/main/= cup/sql-parser=2Ecup M fe/src/main/java/org/apache/impala/analysis/CreateTa= bleAsSelectStmt=2Ejava M fe/src/main/java/org/apache/impala/analysis/TableD= ef=2Ejava M testdata/workloads/functional-planner/queries/PlannerTest/ddl= =2Etest 4 files changed, 96 insertions(+), 8 deletions(-) git pull ssh:= //gerrit=2Ecloudera=2Eorg:29418/Impala-ASF refs/changes/00/8400/2 -- To vi= ew, visit http://gerrit=2Ecloudera=2Eorg:8080/8400 To unsubscribe, visit ht= tp://gerrit=2Ecloudera=2Eorg:8080/settings Gerrit-Project: Impala-ASF Gerr= it-Branch: master Gerrit-MessageType: newpatchset Gerrit-Change-Id: I8d74bc= a999da8ae1bb89427c70841f33e3c56ab0 Gerrit-Change-Number: 8400 Gerrit-PatchS= et: 2 Gerrit-Owner: Csaba Ringhofer --jkxPljtHSfY=--