[jira] [Resolved] (PHOENIX-2686) org.apache.hadoop.hbase.DoNotRetryIOException on distinct selections of columns of datatype - timestamp

["Sergey Soldatov (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/PHOENIX-2686?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sergey Soldatov resolved PHOENIX-2686.
--------------------------------------
    Resolution: Duplicate

> 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.4.0, 4.5.0, 4.6.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)