From dev-return-49103-archive-asf-public=cust-asf.ponee.io@phoenix.apache.org Sat Feb 3 05:45:25 2018 Return-Path: X-Original-To: archive-asf-public@eu.ponee.io Delivered-To: archive-asf-public@eu.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by mx-eu-01.ponee.io (Postfix) with ESMTP id 0ED81180608 for ; Sat, 3 Feb 2018 05:45:25 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id F1FB8160C57; Sat, 3 Feb 2018 04:45:24 +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 47009160C49 for ; Sat, 3 Feb 2018 05:45:24 +0100 (CET) Received: (qmail 81899 invoked by uid 500); 3 Feb 2018 04:45:23 -0000 Mailing-List: contact dev-help@phoenix.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@phoenix.apache.org Delivered-To: mailing list dev@phoenix.apache.org Received: (qmail 81887 invoked by uid 99); 3 Feb 2018 04:45:22 -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; Sat, 03 Feb 2018 04:45:22 +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 225D3199702 for ; Sat, 3 Feb 2018 04:45:22 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.63 X-Spam-Level: ** X-Spam-Status: No, score=2.63 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, KAM_NUMSUBJECT=0.5, KAM_SHORT=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, 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 z8WNVL2vEuHW for ; Sat, 3 Feb 2018 04:45:20 +0000 (UTC) Received: from mail-oi0-f54.google.com (mail-oi0-f54.google.com [209.85.218.54]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id C8DA75F19B for ; Sat, 3 Feb 2018 04:45:19 +0000 (UTC) Received: by mail-oi0-f54.google.com with SMTP id 24so14561915oij.3 for ; Fri, 02 Feb 2018 20:45:19 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:sender:in-reply-to:references:from:date:message-id :subject:to; bh=PZ0h/JZMJzqBnqCK/zoVZzg8ss5CLZrqj6Vil4TfyLs=; b=d3QfAi5yRZvLn0NJsWRb1jLxHWFSNubpsvPIK2FvymX8RJnU8CPQWcASOFws0TTGgV 0m67+X8oWVQiq1Bhbqovm3J7sqQvI7spPFZuYdN4KK08MqE1dbjINna3GozcNSDP0B0Y KstjJEhviJxGu6PT7U1O0F70PC0BmxrrMkVOn7JU3v0a4JlgmD2SioWieKa+aUXKo1Lg L4gim9+qN6oNshkD22i5ZAdtX47brxa71h+FmELRttuKnPsltm7dbDwUidiurrXP8n/b O8HfFBRZKwGrWJ5oBjkoor7L8d9ot4FQ6FrcQHSdSZzEGsNli2FHGtRkExFI3R3Lbt9O dOGg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:sender:in-reply-to:references:from :date:message-id:subject:to; bh=PZ0h/JZMJzqBnqCK/zoVZzg8ss5CLZrqj6Vil4TfyLs=; b=Y9VrUGM/WgRB1iZVomhCePUtRYpoeuHnY+SyUbRyF3AvIU/SgZ8ZYlQbetjq/TKSQ6 sM4hiBtFwWuY+OtQd7x4yzBLmLYNiwDhkjhVlt+7NDAq+NufDQgdJDFJywvT5yEg+WbR 017gCPtICXM7KKwV0W9wayOFrbpYV34dMfGSlwEcKJQX55A3vAV/ZNO+cBNnooZR1tH1 BwHGhnLdvGDMVReZHjXhvkb4FXvKwPOzDqm8dfQRUw0QXajAA/P9Vpi4dQOmg8ACdSKk CZ3RZQIBXaEe58tCgT8CB4nOTaUs+Ku4Q0V2T2SfJ9HITcysUxVbzVDZkeZYUmBIwOoo GJew== X-Gm-Message-State: APf1xPDhGL2aVjSZA5/MFdw5cRZH+Xb2e1RNzWqi1yQTkEc8jZ7Nkf1R p+7aEmI6DQ9pxj0Sh+/AXR1mTg8w/f9D3CPzIhoZqzUb X-Google-Smtp-Source: AH8x22752CGZ+MZDCzeiKx72L+o+/uVMo6NLQ160YVved6caRw9tpjmAM1O1S3AvI5BLIc2LJuUFfMZcDHIVvvs0FoE= X-Received: by 10.202.183.139 with SMTP id h133mr544360oif.103.1517633118016; Fri, 02 Feb 2018 20:45:18 -0800 (PST) MIME-Version: 1.0 Sender: dbist13@gmail.com Received: by 10.157.3.199 with HTTP; Fri, 2 Feb 2018 20:45:17 -0800 (PST) In-Reply-To: <5af7a10a-b2db-e9f1-edb7-bdfb312960fc@apache.org> References: <5af7a10a-b2db-e9f1-edb7-bdfb312960fc@apache.org> From: Artem Ervits Date: Fri, 2 Feb 2018 23:45:17 -0500 X-Google-Sender-Auth: R1wwBFK3JmcIQnVBtZOgB7685vg Message-ID: Subject: Re: [VOTE] Apache Phoenix 5.0.0-alpha for HBase 2.0 rc0 To: dev@phoenix.apache.org Content-Type: multipart/alternative; boundary="001a113cd22ae61ae50564477e1b" --001a113cd22ae61ae50564477e1b Content-Type: text/plain; charset="UTF-8" -1 (nonbinding) md5 binary: OK Centos 7.4 jdk: 1.8.0_161 hadoop 2.7.5 hbase 2.0 ran example $PHOENIX_HOME/bin/psql.py localhost:2181:/hbase-unsecure $PHOENIX_HOME/examples/WEB_STAT.sql $PHOENIX_HOME/examples/WEB_STAT.csv $PHOENIX_HOME/examples/WEB_STAT_QUERIES.sql OK ran example in https://phoenix.apache.org/Phoenix-in-15-minutes-or-less.html OK tried to run performance.py script getting the same results as in https://issues.apache.org/jira/browse/PHOENIX-4510 [vagrant@hadoop ~]$ $PHOENIX_HOME/bin/performance.py localhost:2181:/hbase-unsecure 1000 Phoenix Performance Evaluation Script 1.0 ----------------------------------------- Creating performance table... 18/02/03 04:23:48 WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable no rows upserted Time: 4.59 sec(s) Query # 1 - Count - SELECT COUNT(1) FROM PERFORMANCE_1000; Query # 2 - Group By First PK - SELECT HOST FROM PERFORMANCE_1000 GROUP BY HOST; Query # 3 - Group By Second PK - SELECT DOMAIN FROM PERFORMANCE_1000 GROUP BY DOMAIN; Query # 4 - Truncate + Group By - SELECT TRUNC(DATE,'DAY') DAY FROM PERFORMANCE_1000 GROUP BY TRUNC(DATE,'DAY'); Query # 5 - Filter + Count - SELECT COUNT(1) FROM PERFORMANCE_1000 WHERE CORE<10; Generating and upserting data... Error: Invalid or corrupt jarfile /tmp/data_akuell.csv NOT OK sqlline still shows version 4.13 Connected to: Phoenix (version 4.13) Driver: PhoenixEmbeddedDriver (version 4.13) NOT OK On Fri, Feb 2, 2018 at 10:58 AM, Josh Elser wrote: > Hello Everyone, > > This is a call for a vote on Apache Phoenix 5.0.0-alpha rc0. This release > is only targeting Apache HBase 2.0 and is known to have lacking > functionality as compared to previous releases (e.g. transactional tables, > Hive integration, full local indexing support). It is presented as-is in an > attempt to encourage the community at large to get involved. > > The RC is available at the standard location: > > https://dist.apache.org/repos/dist/dev/phoenix/apache-phoeni > x-5.0.0-alpha-HBase-2.0-rc0 > > RC0 is based on the following commit: a2053c1d3b64a9cc2f35b1f83faa54 > e421bb20f1 > > Signed with my key: 9E62822F4668F17B0972ADD9B7D5CD454677D66C, > http://pgp.mit.edu/pks/lookup?op=get&search=0xB7D5CD454677D66C > > Vote will be open for at least 72 hours (2018/02/05 1600GMT). Please vote: > > [ ] +1 approve > [ ] +0 no opinion > [ ] -1 disapprove (and reason why) > > Thanks, > The Apache Phoenix Team > --001a113cd22ae61ae50564477e1b--