Eric Owhadi created TRAFODION-1446:
--------------------------------------
Summary: End Key missing for simple scan scenario
Key: TRAFODION-1446
URL: https://issues.apache.org/jira/browse/TRAFODION-1446
Project: Apache Trafodion
Issue Type: Bug
Components: sql-exe
Affects Versions: 2.0-incubating
Environment: see on developer build
Reporter: Eric Owhadi
Priority: Critical
Using a table a created with something like:
Create table t131helper (a int not null, primary key(a));
Insert into t131helper values(1);
Create table t1311oneblock
(uniq int not null,
C100 int,
Str1 varchar(4000),
Primary key (uniq))
Insert into t131oneblock
Select (100*x100)+(10*x10)+x1,
(100*x100)+(10*x10)+x1,
‘xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx’
>From t131helper
Transpose 0,1,2,3,4,5,6,7,8,9 as x100
Transpose 0,1,2,3,4,5,6,7,8,9 as x10
Transpose 0,1,2,3,4,5,6,7,8,9 as x1
so basically creating a table with key 0,1,2,3,4 etc until 999.
Then doing a
Select * from t131oneblock where uniq >2 and uniq < 5
you will see that end key is not populated on the scan operator (use explain to
notice the empty end key). I stepped in the code, and the error is not just a
wrong display on the explain, the end key is not populated down to the java
hbase scan invoke.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
