[
https://issues.apache.org/jira/browse/PHOENIX-1570?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14273425#comment-14273425
]
xwxingyi commented on PHOENIX-1570:
-----------------------------------
Hi James:
select /*+ NO_INDEX */ count(b) FROM MISS_DATA_TABLE where q = '102218';
is ok
As the table has only 1 region on region server, we checked the log of
hbase:
2015-01-12 17:18:00,355 WARN org.apache.hadoop.ipc.RpcServer:
RpcServer.respondercallId: 238 service: ClientService methodName: Scan size:
398 connection: 10.96.29.77:39317: output error
2015-01-12 17:18:00,356 WARN org.apache.hadoop.ipc.RpcServer:
B.defaultRpcServer.handler=7,queue=1,port=60020: caught a
ClosedChannelException, this means that the server was processing a request but
the client went away. The error message was: null
2015-01-12 17:18:05,128 INFO
org.apache.hadoop.hbase.regionserver.HRegionServer: Scanner 1661 lease expired
on region MISS_DATA_TABLE,,1420708987749.a692ddf514f5aa00f38272c298b22244.
2015-01-12 17:18:12,131 INFO
org.apache.hadoop.hbase.regionserver.HRegionServer: Scanner 1662 lease expired
on region MISS_DATA_TABLE,,1420708987749.a692ddf514f5aa00f38272c298b22244.
2015-01-12 17:18:19,130 INFO
org.apache.hadoop.hbase.regionserver.HRegionServer: Scanner 1663 lease expired
on region MISS_DATA_TABLE,,1420708987749.a692ddf514f5aa00f38272c298b22244.
2015-01-12 17:18:26,128 INFO
org.apache.hadoop.hbase.regionserver.HRegionServer: Scanner 1664 lease expired
on region MISS_DATA_TABLE,,1420708987749.a692ddf514f5aa00f38272c298b22244.
2015-01-12 17:18:33,127 INFO
org.apache.hadoop.hbase.regionserver.HRegionServer: Scanner 1665 lease expired
on region MISS_DATA_TABLE,,1420708987749.a692ddf514f5aa00f38272c298b22244.
2015-01-12 17:18:40,136 INFO
org.apache.hadoop.hbase.regionserver.HRegionServer: Scanner 1666 lease expired
on region MISS_DATA_TABLE,,1420708987749.a692ddf514f5aa00f38272c298b22244.
2015-01-12 17:18:47,130 INFO
org.apache.hadoop.hbase.regionserver.HRegionServer: Scanner 1667 lease expired
on region MISS_DATA_TABLE,,1420708987749.a692ddf514f5aa00f38272c298b22244.
2015-01-12 17:18:54,130 INFO
org.apache.hadoop.hbase.regionserver.HRegionServer: Scanner 1668 lease expired
on region MISS_DATA_TABLE,,1420708987749.a692ddf514f5aa00f38272c298b22244.
2015-01-12 17:19:00,685 WARN org.apache.hadoop.ipc.RpcServer:
RpcServer.respondercallId: 240 service: ClientService methodName: Scan size:
398 connection: 10.96.29.77:39385: output error
2015-01-12 17:19:00,686 WARN org.apache.hadoop.ipc.RpcServer:
B.defaultRpcServer.handler=13,queue=1,port=60020: caught a
ClosedChannelException, this means that the server was processing a request but
the client went away. The error message was: null
Hope these will be helpful.
> 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)
