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 59FF2200C5B for ; Thu, 27 Apr 2017 13:17:08 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 58A0A160BB2; Thu, 27 Apr 2017 11:17:08 +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 9D4F0160B98 for ; Thu, 27 Apr 2017 13:17:07 +0200 (CEST) Received: (qmail 52025 invoked by uid 500); 27 Apr 2017 11:17:06 -0000 Mailing-List: contact dev-help@accumulo.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@accumulo.apache.org Delivered-To: mailing list dev@accumulo.apache.org Received: (qmail 52012 invoked by uid 500); 27 Apr 2017 11:17:05 -0000 Delivered-To: apmail-incubator-accumulo-dev@incubator.apache.org Received: (qmail 52009 invoked by uid 99); 27 Apr 2017 11:17:05 -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; Thu, 27 Apr 2017 11:17:05 +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 36EC8188C35 for ; Thu, 27 Apr 2017 11:17:05 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.629 X-Spam-Level: ** X-Spam-Status: No, score=2.629 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, FREEMAIL_ENVFROM_END_DIGIT=0.25, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, RCVD_IN_SORBS_SPAM=0.5, 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 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 i3mXZNB5-I4U for ; Thu, 27 Apr 2017 11:17:04 +0000 (UTC) Received: from mail-ua0-f181.google.com (mail-ua0-f181.google.com [209.85.217.181]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 900E95F485 for ; Thu, 27 Apr 2017 11:17:03 +0000 (UTC) Received: by mail-ua0-f181.google.com with SMTP id 110so17217904uas.3 for ; Thu, 27 Apr 2017 04:17:03 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=3MrEm6qGdXD2Qz37LD9cMY5i5cU6XRTGtoipYS4FnUc=; b=Ubk0FvggkVzz52v50b+qLnf8rYS1/GNWHxuqzheaIL7cT4759vwIUu5awvGWhIfnVr X6DvPO8kNjiTM5YS8JO0RO4keVzuwU7kNIHJRMCncsfNLOolESrpQeanTnF/TeACfbZm SXagU1IwPKYfXnMFDymYte65a0xIMsBCJjqPmmw0cD6Mhy56SxMXhC/YNouvME5//Qjn sTb0fFs4rGwzfgVGT6hQcG/7+CZqUtSVFTUFf2fXKHX1LarrQ7LPaGFibeXH6LQ6jduz gyRksIwSycjNPA2FkpZrg9KCY1FEqNcwHQ4XhDC9Q0zsIOehM/p3crHeox5/+MVJ7NPL eENQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to; bh=3MrEm6qGdXD2Qz37LD9cMY5i5cU6XRTGtoipYS4FnUc=; b=WY4ZzBagzvZMiopaUl4gHmergo+laQG1ee2n+Id+MmDe9lyX35IKo5mVTa2ISWAn+N zvD/MKYTTLGC3t5cl+OgA9BN9XNtL0djXY+FSWUyqsLN7cmIuLiWULp2jA45PvbYbFbq bcFA4MOHTPEZ4vaalZiQIDd8GDE7cpeS1TJF+TG6vJgnoezpBt1FFAbXzLrQ5a6CMzYH s6eACi3E+ac4MHXpwxgMKrFFTdPFEzsnlj3frMiN2evSmddj8HApw6GpzJna715D95tJ 0nwT1hdwTCW+canqud1mi1rP2kMpiDRRPjdOg+isRHJ+PnR4GZSs+a0hGG6zozPQxpUC Mp1Q== X-Gm-Message-State: AN3rC/6Ey+rKExbSX/YBmOxRdbTK09Pn2v+GuuRYElf9YJHgBptfLIVf lFFRegCFEP/UDS92M726jpTO+Fgd9XWe X-Received: by 10.159.38.194 with SMTP id 60mr2160412uay.70.1493291822438; Thu, 27 Apr 2017 04:17:02 -0700 (PDT) MIME-Version: 1.0 Received: by 10.31.151.75 with HTTP; Thu, 27 Apr 2017 04:17:01 -0700 (PDT) In-Reply-To: References: From: Suresh Prajapati Date: Thu, 27 Apr 2017 16:47:01 +0530 Message-ID: Subject: Fwd: Accumulo Table Sacanning Taking Time!!! To: accumulo-dev@incubator.apache.org Content-Type: multipart/alternative; boundary=94eb2c047dca9f6a8d054e241884 archived-at: Thu, 27 Apr 2017 11:17:08 -0000 --94eb2c047dca9f6a8d054e241884 Content-Type: text/plain; charset=UTF-8 ---------- Forwarded message ---------- From: Suresh Prajapati Date: Thu, Apr 27, 2017 at 4:39 PM Subject: Accumulo Table Sacanning Taking Time!!! To: dev@accumulo.apache.org Hello Team I am developing a client in accumulo to store geo-spatial information and using geomesa for indexing on top of it. However i found that scanning *~1 million* records taking *2-3 sec*. I looked at indexes and query plan of geomesa but not able to find cause of the problem. I am running accumulo as single tablet-server(including master). I want to know - what are the factors can affect accumulo scanning operation? how can I optimise this time? Thank You Suresh Prajapati --94eb2c047dca9f6a8d054e241884--