You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Vivek K T (JIRA)" <ji...@apache.org> on 2016/02/17 13:03:18 UTC
[jira] [Created] (PHOENIX-2687) nested exception is
java.sql.SQLException: Error while parsing row for Timestamp columns with
null values
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)