phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vivek K T (JIRA)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-2687) nested exception is java.sql.SQLException: Error while parsing row for Timestamp columns with null values
Date Wed, 17 Feb 2016 12:03:18 GMT
Vivek K T created PHOENIX-2687:
----------------------------------

             Summary: nested exception is java.sql.SQLException: Error while parsing row for
Timestamp columns with null values
                 Key: PHOENIX-2687
                 URL: https://issues.apache.org/jira/browse/PHOENIX-2687
             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 the below steps to reproduce the issue : 

1) Create a dummy table : 

create table PO_Test
(
date1 timestamp,
amount1 decimal,
currency1 varchar (50),
id varchar (50) primary key
)


2) Insert some tuples : 

upsert into po_test (date1,amount1,currency1,id) values (current_date(),20,'ABC','1');
upsert into po_test (date1,amount1,currency1,id) values (current_date(),20,'ABC','2');
upsert into po_test (amount1,currency1,id) values (20,'ABC','3');
upsert into po_test (amount1,currency1,id) values (20,'ABC','4');
upsert into po_test (amount1,currency1,id) values (20,'ABC','5');

3) Execute the following query : 

select  date1 date2, amount1 sum_amount, currency1 currency2
from (
                select 
                distinct 
                date1 date1, 
                amount1 amount1, 
                currency1 currency1 from po_test
                )
group by 
date2,sum_amount,currency2;





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message