[
https://issues.apache.org/jira/browse/PHOENIX-2687?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15154713#comment-15154713
]
Sergey Soldatov commented on PHOENIX-2687:
------------------------------------------
According to the explain you are still using old version of client jar. Please
check that you replaced it with new one and restarted Squirrel. The correct
explain should be like:
CLIENT 1-CHUNK PARALLEL 1-WAY FULL SCAN OVER PO_TEST
SERVER AGGREGATE INTO DISTINCT ROWS BY [AMOUNT1, CURRENCY1, DATE1]
CLIENT MERGE SORT
CLIENT SORTED BY [AMOUNT1, CURRENCY1, DATE1]
CLIENT AGGREGATE INTO DISTINCT ROWS BY [AMOUNT1, CURRENCY1, DATE1]
CLIENT 100 ROW LIMIT
> 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.4.0, 4.5.0, 4.6.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)
