Return-Path: X-Original-To: apmail-phoenix-dev-archive@minotaur.apache.org Delivered-To: apmail-phoenix-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 584E6179CC for ; Mon, 12 Jan 2015 04:44:55 +0000 (UTC) Received: (qmail 72474 invoked by uid 500); 12 Jan 2015 04:44:56 -0000 Delivered-To: apmail-phoenix-dev-archive@phoenix.apache.org Received: (qmail 72417 invoked by uid 500); 12 Jan 2015 04:44:56 -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 72406 invoked by uid 99); 12 Jan 2015 04:44:56 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 12 Jan 2015 04:44:56 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED,T_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; Mon, 12 Jan 2015 04:44:55 +0000 Received: (qmail 71567 invoked by uid 99); 12 Jan 2015 04:44:35 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 12 Jan 2015 04:44:35 +0000 Date: Mon, 12 Jan 2015 04:44:35 +0000 (UTC) From: "xwxingyi (JIRA)" To: dev@phoenix.incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (PHOENIX-1570) Data missing when using local index 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/PHOENIX-1570?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14273210#comment-14273210 ] xwxingyi commented on PHOENIX-1570: ----------------------------------- Hi James, Xue: We see four patches: v3 v4 v5 v6 now. As we used to only use patch v2, for these new patches, how should we use them? Patch them all? Or recover from v2, patch v6 only? Or directly patch v6 based on v2? Please give out an instruction, thank you very much~ > Data missing when using local index > ----------------------------------- > > Key: PHOENIX-1570 > URL: https://issues.apache.org/jira/browse/PHOENIX-1570 > Project: Phoenix > Issue Type: Bug > Affects Versions: 4.2.1, 4.2.2 > Environment: ubuntu > HBase 0.98.7 > Hadoop 2.5.1 > OS: ubuntu > Reporter: wuchengzhi > Priority: Critical > Attachments: 1570.patch, FetchDataByLocalIndexIT.java, PHOENIX-1570.patch, PHOENIX-1570_v2.patch, PHOENIX-1570_v3.patch, PHOENIX-1570_v4.patch, PHOENIX-1570_v5.patch, PHOENIX-1570_v6.patch > > > 1. crate a table by the schema as below: > CREATE TABLE IF NOT EXISTS Miss_data_table( > a BIGINT NOT NULL, > b VARCHAR, > c INTEGER, > d INTEGER, > e INTEGER, > f INTEGER, > g VARCHAR, > h VARCHAR, > i INTEGER, > j VARCHAR, > k INTEGER, > l VARCHAR, > m VARCHAR, > n INTEGER, > o INTEGER, > p VARCHAR, > q VARCHAR, > r INTEGER, > s BIGINT, > t VARCHAR CONSTRAINT pk PRIMARY KEY(a)) > 2.create local index for the table with column: q > create local index idx_q on Miss_data_table (q); > 3.upsert data into table. > upsert into Miss_data_table values(96660688,'hello/TEST-0',156,-1,-1,0,'2013-02-14 18:34:05.0','TEST-1',0,'495839182',0,'50','',0,0,'1818378','102218',0,26,'20141201') > 4. execute querys... > select a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t from Miss_data_table where q = '102218'; > +----------+--------------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+--------+------+------+----------+ > | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | > +----------+--------------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+--------+------+------+----------+ > | 96660688 | hello/TEST-0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 102218 | NULL | 26 | 20141201 | > +----------+--------------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+--------+------+------+----------+ > select a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t from Miss_data_table where a=96660688; > +----------+--------------+------+------+------+------+-----------------------+--------+------+-----------+------+------+------+------+------+---------+--------+------+------+----------+ > | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | > +----------+--------------+------+------+------+------+-----------------------+--------+------+-----------+------+------+------+------+------+---------+--------+------+------+----------+ > | 96660688 | hello/TEST-0 | 156 | -1 | -1 | 0 | 2013-02-14 18:34:05.0 | TEST-1 | 0 | 495839182 | 0 | 50 | NULL | 0 | 0 | 1818378 | 102218 | 0 | 26 | 20141201 | > +----------+--------------+------+------+------+------+-----------------------+--------+------+-----------+------+------+------+------+------+---------+--------+------+------+----------+ > // execute the query plain ,it shows we fetch data by local index. > explain select a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t from Miss_data_table where q = '102218'; > +------------------------------------------+ > | PLAN | > +------------------------------------------+ > | CLIENT 1-CHUNK PARALLEL 1-WAY RANGE SCAN OVER _LOCAL_IDX_TEST.MISS_DATA_TABLE [-32768,'102218'] | > | CLIENT MERGE SORT | > +------------------------------------------+ -- This message was sent by Atlassian JIRA (v6.3.4#6332)