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 E8CEA200B35 for ; Tue, 5 Jul 2016 21:01:53 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id E77B3160A60; Tue, 5 Jul 2016 19:01:53 +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 3D365160A2C for ; Tue, 5 Jul 2016 21:01:53 +0200 (CEST) Received: (qmail 38613 invoked by uid 500); 5 Jul 2016 19:01:52 -0000 Mailing-List: contact dev-help@hawq.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hawq.incubator.apache.org Delivered-To: mailing list dev@hawq.incubator.apache.org Received: (qmail 38596 invoked by uid 99); 5 Jul 2016 19:01:52 -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; Tue, 05 Jul 2016 19:01:52 +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 8FDC0185838 for ; Tue, 5 Jul 2016 19:01:51 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.198 X-Spam-Level: * X-Spam-Status: No, score=1.198 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H2=-0.001, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx2-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 g48EwYEt9CvC for ; Tue, 5 Jul 2016 19:01:50 +0000 (UTC) Received: from mail-oi0-f43.google.com (mail-oi0-f43.google.com [209.85.218.43]) by mx2-lw-eu.apache.org (ASF Mail Server at mx2-lw-eu.apache.org) with ESMTPS id 15FDD5FADE for ; Tue, 5 Jul 2016 19:01:50 +0000 (UTC) Received: by mail-oi0-f43.google.com with SMTP id r2so242286229oih.2 for ; Tue, 05 Jul 2016 12:01:49 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:from:date:message-id:subject:to; bh=nHp63vZKLuEkqNAW02IBsBcd0QdEIGJfC1ytylqGnzw=; b=KDkdI4+fEVeCt5TQ13QoQiyJt77fqgdb+YTIqn5OjyR/H6Jyok+dWiP1ZyN5+D0pGD yvmxbL/KByZ896RhxReYbaPJxJZLmSMZdP4hIjHyMflpLbtDxdWyA4SYjxi1634rpwjD 4ax3gAxwHhqfS3aqBfqFKzr5FTuw/bG8lYufjk9xJM1Y0P2OVT73SpOVlpV3JgM/llPM 1sQp3gDP2mVCmc62We/NyTC90XNiG1NaUxY7kXIrlt8yAsiaLrnyuUTZkO2vGvXk0axS 3UU1XLKyzzumDvLSEQEQTilXqe6VZO6c5Psx7Upz09Y1x1dXiJC2VERE11VLlE9f93W/ l16w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=nHp63vZKLuEkqNAW02IBsBcd0QdEIGJfC1ytylqGnzw=; b=jkSqq3+jsNiOZciKDH4xfq+6F2tnTmei0A6NZa85NbbkpuZR5aNNhJA3TwC1U+t2rb jGuxJo0TrmtdLH0bP2o5ALZmptPcYWM/Sy+oWNMKZG3cmODexv91iiUly8MH8CI+grPT mC6CwDnn//Fuu5/Mgw2ukemmDLKmOITIFQChzFQmNbExfjYnLbVyo+6sF277ILl5Bkwz gIgA7jpDIJlDbbgv9K+uiAOns8PM1uHBMd2XZZ0KPkaxDBSb9/kYR8cH3QmMC0IigTxg a73czXmVaCg0nfnxKvM/vZr6nDOkVpPZ/1Zi/m2cdA8NF6l1mZFneRMbkaLdmIoohesD VqlQ== X-Gm-Message-State: ALyK8tJUOT75+7vMe4tNOoaSC749OHVp6MujN6yj2GGjnUWp9a47y/vDtUv4FVFN+RMU2IfxkCyONpd+wHikbQ== X-Received: by 10.157.5.194 with SMTP id 60mr10092397otd.161.1467745308495; Tue, 05 Jul 2016 12:01:48 -0700 (PDT) MIME-Version: 1.0 Received: by 10.157.33.56 with HTTP; Tue, 5 Jul 2016 12:01:29 -0700 (PDT) From: Shivram Mani Date: Tue, 5 Jul 2016 12:01:29 -0700 Message-ID: Subject: [Propose] New PXF profile optimized for ORC (predicate pushdown) To: dev@hawq.incubator.apache.org Content-Type: multipart/alternative; boundary=001a113e15fcbbf06a0536e815d3 archived-at: Tue, 05 Jul 2016 19:01:54 -0000 --001a113e15fcbbf06a0536e815d3 Content-Type: text/plain; charset=UTF-8 I've created the following jira HAWQ-866 which is focussed on improving/enhancing the existing PXF profile to read ORC files. The goal is to make use of the underlying ORC reader's capability of supporting predicate push-down among others. Presto has also contributed an alternative ORC reader which provides both predicate push down and Lazy reads https://code.facebook.com/posts/370832626374903/even-faster-data-at-the-speed-of-presto-orc/ . Will be evaluating both the options as part of this effort. -- shivram mani --001a113e15fcbbf06a0536e815d3--