From user-return-7978-apmail-drill-user-archive=drill.apache.org@drill.apache.org Fri Jun 9 07:18:56 2017 Return-Path: X-Original-To: apmail-drill-user-archive@www.apache.org Delivered-To: apmail-drill-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 8C54418417 for ; Fri, 9 Jun 2017 07:18:56 +0000 (UTC) Received: (qmail 2150 invoked by uid 500); 9 Jun 2017 07:18:51 -0000 Delivered-To: apmail-drill-user-archive@drill.apache.org Received: (qmail 2089 invoked by uid 500); 9 Jun 2017 07:18:51 -0000 Mailing-List: contact user-help@drill.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@drill.apache.org Delivered-To: mailing list user@drill.apache.org Received: (qmail 2077 invoked by uid 99); 9 Jun 2017 07:18:50 -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; Fri, 09 Jun 2017 07:18:50 +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 59B7E18041B for ; Fri, 9 Jun 2017 07:18:50 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -0.397 X-Spam-Level: X-Spam-Status: No, score=-0.397 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_NONE=-0.0001, RCVD_IN_MSPIKE_H2=-2.796, RCVD_IN_SORBS_SPAM=0.5, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (1024-bit key) header.d=manthan.com 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 CZRJFX91Jn6s for ; Fri, 9 Jun 2017 07:18:49 +0000 (UTC) Received: from mail-ua0-f175.google.com (mail-ua0-f175.google.com [209.85.217.175]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 154C760EEB for ; Fri, 9 Jun 2017 07:18:48 +0000 (UTC) Received: by mail-ua0-f175.google.com with SMTP id h39so29619715uaa.3 for ; Fri, 09 Jun 2017 00:18:48 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=manthan.com; s=google; h=mime-version:from:date:message-id:subject:to; bh=Smhi6lo2/huJXMdOJlgMk0SSL4p7/BCX6Nu8JC2pnjg=; b=eYbafzPHnc5coQXjbmXv0jjosh/6Eee5tsDr6Xmyf5JpHXH9xKoxvVN91pF4MPDIvu xoo8QFm3sxDFuKvYjWdYEylK+WGMUs2FKY3oOCLajG9Hbq3CENR3Ig/zAN+DaKKlbZFH JjDE9GwoVV7qCJxb/66sc6XeLP+VtAd1nsFm8= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=Smhi6lo2/huJXMdOJlgMk0SSL4p7/BCX6Nu8JC2pnjg=; b=Jcn8+vA3KYO1VthcGZSHYshZ6xee1mSWynb2sJF3d+GuELGpkWUnxWtMHQgKxsrUoG VM2JDg28GyZG+F94aNnUJDuXJSRTssHSizbGNw9na2uwtPg3ZYW4u5GqDsw1lOzQztP2 sMe/GfRBPmarqLqkyd4AUo9CxYJE2+uRF38A8TQ76eTIzxNtDUDPFgnoNYLIoHkKP2ig T1UjWc+9D52Xr3Spd9/IRlSLIRxu2rEl77F0kqciCoxi6TGsPSdg3X7usnQtNQQ3cduM hFfTrJ4ViFhJ00MR/gv0SEuoTFkJs9AJd87z6DRLd2mpzMVYEI6BFox70EupeXPvYomj U4xg== X-Gm-Message-State: AODbwcC4yEFytTcIDWljrfmxLP6ZuVtPIb92c9BjNTHnQg+4G+z93ELs aG+0yMWnQ0WujTM6qzUOokj5GU9TIyJo6PI= X-Received: by 10.176.83.16 with SMTP id x16mr24842221uax.11.1496992722200; Fri, 09 Jun 2017 00:18:42 -0700 (PDT) MIME-Version: 1.0 Received: by 10.176.25.98 with HTTP; Fri, 9 Jun 2017 00:18:41 -0700 (PDT) From: Shuporno Choudhury Date: Fri, 9 Jun 2017 12:48:41 +0530 Message-ID: Subject: Increasing store.parquet.block-size To: user@drill.apache.org Content-Type: multipart/alternative; boundary="94eb2c18f1ac7075e1055181c752" --94eb2c18f1ac7075e1055181c752 Content-Type: text/plain; charset="UTF-8" The max value that can be assigned to *store.parquet.block-size *is *2147483647*, as the value kind of this configuration parameter is LONG. This basically translates to 2GB of block size. How do I increase it to 3/4/5 GB ? Trying to set this parameter to a higher value using the following command actually succeeds : ALTER SYSTEM SET `store.parquet.block-size` = 4294967296; But when I try to run a query that uses this config, it throws the following error: Error: SYSTEM ERROR: NumberFormatException: For input string: "4294967296" So, is it possible to assign a higher value to this parameter? -- Regards, Shuporno Choudhury --94eb2c18f1ac7075e1055181c752--