Return-Path: X-Original-To: apmail-tajo-dev-archive@minotaur.apache.org Delivered-To: apmail-tajo-dev-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 674FA100A8 for ; Wed, 4 Sep 2013 15:59:20 +0000 (UTC) Received: (qmail 10361 invoked by uid 500); 4 Sep 2013 15:59:18 -0000 Delivered-To: apmail-tajo-dev-archive@tajo.apache.org Received: (qmail 10188 invoked by uid 500); 4 Sep 2013 15:59:17 -0000 Mailing-List: contact dev-help@tajo.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@tajo.incubator.apache.org Delivered-To: mailing list dev@tajo.incubator.apache.org Received: (qmail 9764 invoked by uid 99); 4 Sep 2013 15:59:17 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 04 Sep 2013 15:59:17 +0000 X-ASF-Spam-Status: No, hits=-2002.4 required=5.0 tests=ALL_TRUSTED,RP_MATCHES_RCVD X-Spam-Check-By: apache.org Received: from [140.211.11.3] (HELO mail.apache.org) (140.211.11.3) by apache.org (qpsmtpd/0.29) with SMTP; Wed, 04 Sep 2013 15:59:13 +0000 Received: (qmail 7245 invoked by uid 99); 4 Sep 2013 15:58:51 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 04 Sep 2013 15:58:51 +0000 Date: Wed, 4 Sep 2013 15:58:51 +0000 (UTC) From: "Hudson (JIRA)" To: dev@tajo.incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (TAJO-144) Implement INSERT OVERWRITE clause MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/TAJO-144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13757897#comment-13757897 ] Hudson commented on TAJO-144: ----------------------------- SUCCESS: Integrated in Tajo-trunk-postcommit #394 (See [https://builds.apache.org/job/Tajo-trunk-postcommit/394/]) TAJO-144: Implement INSERT OVERWRITE clause. (hyunsik) (hyunsik: https://git-wip-us.apache.org/repos/asf?p=incubator-tajo.git&a=commit&h=ffdb1c71cf796adafb635b99e80b8764a7b201ea) * tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/master/querymaster/QueryMasterTask.java * tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/worker/TajoResourceAllocator.java * tajo-core/tajo-core-storage/src/main/java/org/apache/tajo/storage/trevni/TrevniAppender.java * tajo-algebra/src/main/java/org/apache/tajo/algebra/OpType.java * tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/query/QueryUnitRequestImpl.java * tajo-core/tajo-core-backend/src/test/queries/insert_into_select_2.sql * tajo-core/tajo-core-backend/src/test/queries/insert_2.sql * tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/parser/SQLAnalyzer.java * tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/planner/BaseAlgebraVisitor.java * tajo-core/tajo-core-backend/src/test/java/org/apache/tajo/engine/planner/physical/TestHashJoinExec.java * tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/master/GlobalEngine.java * tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/master/querymaster/QueryInProgress.java * tajo-core/tajo-core-storage/src/main/java/org/apache/tajo/storage/rcfile/RCFileWrapper.java * tajo-core/tajo-core-backend/src/test/java/org/apache/tajo/engine/parser/TestSQLAnalyzer.java * tajo-core/tajo-core-backend/src/test/queries/insert_overwrite_into_select_1.sql * tajo-common/src/main/java/org/apache/tajo/datum/DatumFactory.java * tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/QueryConf.java * tajo-core/tajo-core-storage/src/main/java/org/apache/tajo/storage/RowFile.java * tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/master/QueryMeta.java * tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/planner/logical/StoreTableNode.java * tajo-core/tajo-core-storage/src/main/java/org/apache/tajo/storage/CSVFile.java * tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/eval/ConstEval.java * tajo-core/tajo-core-storage/src/main/java/org/apache/tajo/storage/RawFile.java * tajo-core/tajo-core-backend/src/test/queries/insert_1.sql * tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/worker/TajoWorkerManagerService.java * tajo-core/tajo-core-storage/src/main/java/org/apache/tajo/storage/StorageManager.java * tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/worker/TajoWorker.java * tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/planner/PlannerUtil.java * tajo-algebra/src/main/java/org/apache/tajo/algebra/Insert.java * tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/master/TaskSchedulerImpl.java * tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/planner/rewrite/ProjectionPushDownRule.java * tajo-core/tajo-core-backend/src/test/java/org/apache/tajo/engine/planner/TestLogicalPlanner.java * tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/master/event/QueryStartEvent.java * tajo-core/tajo-core-backend/src/main/proto/TajoWorkerProtocol.proto * tajo-core/tajo-core-storage/src/test/java/org/apache/tajo/storage/TestStorages.java * tajo-core/tajo-core-backend/src/test/java/org/apache/tajo/engine/planner/physical/TestExternalSortExec.java * tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/planner/LogicalPlanVisitor.java * tajo-core/tajo-core-backend/src/test/queries/insert_overwrite_into_select_2.sql * tajo-core/tajo-core-backend/src/test/queries/insert_into_select_1.sql * tajo-core/tajo-core-backend/src/test/queries/insert_into_select_3.sql * tajo-core/tajo-core-backend/src/test/java/org/apache/tajo/engine/planner/TestPlannerUtil.java * tajo-core/tajo-core-backend/src/test/java/org/apache/tajo/engine/eval/TestEvalTreeUtil.java * tajo-core/tajo-core-backend/src/main/antlr4/org/apache/tajo/engine/parser/SQLLexer.g4 * tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/master/querymaster/Query.java * tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/planner/LogicalPlanner.java * tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/planner/logical/NodeType.java * CHANGES.txt * tajo-core/tajo-core-backend/src/test/java/org/apache/tajo/engine/planner/TestLogicalOptimizer.java * tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/worker/TaskRunner.java * tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/master/querymaster/QueryJobManager.java * tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/planner/QueryBlockGraph.java * tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/planner/LogicalPlan.java * tajo-catalog/tajo-catalog-server/src/main/java/org/apache/tajo/catalog/store/DBStore.java * tajo-core/tajo-core-backend/src/test/java/org/apache/tajo/engine/planner/physical/TestMergeJoinExec.java * tajo-core/tajo-core-backend/src/test/queries/insert_overwrite_into_select_3.sql * tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/master/querymaster/QueryMaster.java * tajo-core/tajo-core-backend/src/test/java/org/apache/tajo/engine/query/TestSelectQuery.java * tajo-core/tajo-core-backend/src/test/java/org/apache/tajo/worker/TaskRunnerTest.java * tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/worker/Task.java * tajo-core/tajo-core-backend/src/test/java/org/apache/tajo/engine/planner/physical/TestNLJoinExec.java * tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/planner/rewrite/FilterPushDownRule.java * tajo-core/tajo-core-backend/src/test/java/org/apache/tajo/TajoTestingCluster.java * tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/planner/BasicLogicalPlanVisitor.java * tajo-core/tajo-core-backend/src/test/java/org/apache/tajo/engine/eval/TestEvalTree.java * tajo-core/tajo-core-backend/src/main/antlr4/org/apache/tajo/engine/parser/SQLParser.g4 * tajo-common/src/main/proto/DataTypes.proto * tajo-core/tajo-core-backend/src/test/java/org/apache/tajo/engine/planner/physical/TestBNLJoinExec.java * tajo-core/tajo-core-storage/src/main/java/org/apache/tajo/storage/trevni/TrevniScanner.java * tajo-common/src/main/java/org/apache/tajo/datum/NullDatum.java * tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/master/querymaster/SubQuery.java * tajo-core/tajo-core-backend/src/test/java/org/apache/tajo/engine/query/TestInsertQuery.java * .gitignore * tajo-catalog/tajo-catalog-client/src/main/java/org/apache/tajo/catalog/CatalogClient.java * tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/worker/TajoWorkerClientService.java * tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/planner/InsertNode.java * tajo-catalog/tajo-catalog-server/src/main/java/org/apache/tajo/catalog/MiniCatalogServer.java * tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/ipc/protocolrecords/QueryUnitRequest.java * tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/cli/TajoCli.java > Implement INSERT OVERWRITE clause > --------------------------------- > > Key: TAJO-144 > URL: https://issues.apache.org/jira/browse/TAJO-144 > Project: Tajo > Issue Type: New Feature > Components: planner/optimizer > Reporter: Hyunsik Choi > Assignee: Hyunsik Choi > Fix For: 0.2-incubating > > Attachments: TAJO-144_2.patch, TAJO-144.patch > > > 'INSERT INTO' appends data into existing table. In contrast, 'INSERT OVERWRITE' will overwrite existing table data. It is used as an idiom in analytical fields based HDFS. We need it. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira