Vivek K T created PHOENIX-2686:
----------------------------------
Summary: org.apache.hadoop.hbase.DoNotRetryIOException on distinct
selections of columns of datatype - timestamp
Key: PHOENIX-2686
URL: https://issues.apache.org/jira/browse/PHOENIX-2686
Project: Phoenix
Issue Type: Bug
Affects Versions: 4.6.0, 4.5.0, 4.4.0
Environment: CentOS(Server), Windows(client)
Reporter: Vivek K T
Priority: Critical
Follow below steps to reproduce the issue :
1) Create a dummy table :
create table PO_Test1
(
date1 timestamp,
date2 timestamp,
amount1 decimal,
currency1 varchar (50),
id varchar (50) primary key
)
2) Insert some tuples into it :
upsert into po_test1 (date1,date2,amount1,currency1,id) values
(current_date(),current_date(),20,'ABC','1');
upsert into po_test1 (date1,date2,amount1,currency1,id) values
(current_date(),current_date(),20,'ABC','2');
upsert into po_test1 (date1,amount1,currency1,id) values
(current_date(),20,'ABC','3');
upsert into po_test1 (date1,amount1,currency1,id) values
(current_date(),20,'ABC','4');
upsert into po_test1 (date2,amount1,currency1,id) values
(current_date(),20,'ABC','5');
upsert into po_test1 (date2,amount1,currency1,id) values
(current_date(),20,'ABC','6');
upsert into po_test1 (amount1,currency1,id) values (20,'ABC','7');
upsert into po_test1 (amount1,currency1,id) values (20,'ABC','8');
3) Execute the following Query :
select date1 d1, date2 d2, amount1 a1
from (
select distinct date1, date2, amount1 from po_test1
)
group by
d1, d2, a1;
The following exception is thrown :
java.sql.SQLException: org.apache.hadoop.hbase.DoNotRetryIOException: Non
terminating null value found for fixed width expression (DATE2) in row:
org.apache.phoenix.execute.TupleProjector$ProjectedValueTuple@9d5704
NOTES :
1) It is observed that the query executes successfully when the distinct
keyword is not used.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
