[jira] [Comment Edited] (PHOENIX-2687) nested exception is java.sql.SQLException: Error while parsing row for Timestamp columns with null values

["Vivek K T (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/PHOENIX-2687?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15153879#comment-15153879 ] 

Vivek K T edited comment on PHOENIX-2687 at 2/19/16 8:03 AM:
-------------------------------------------------------------

Yes, I have. we're using v4.6.0-Hbase-0.98. I applied PHOENIX-2257.patch manually. I ignored the test case mentioned in the patch and just replaced the last line of code at the end of the function QueryCompiler.compileSingleQuery(...) with

    boolean isInRowKeyOrder = (innerPlan.getGroupBy() == GroupByCompiler.GroupBy.EMPTY_GROUP_BY) && (innerPlan.getOrderBy() == OrderByCompiler.OrderBy.EMPTY_ORDER_BY);

    return compileSingleFlatQuery(context, select, binds, asSubquery, allowPageFilter, innerPlan, tupleProjector, isInRowKeyOrder);

We're using squirrel 3.7

Did i miss something? The above test case still fails!!! 


was (Author: vivek.kt):
Yes, I have. we're using v4.6.0-Hbase-0.98. I applied PHOENIX-2257.patch manually. I ignored the test case mentioned in the patch and just replaced the last line of code at the end of the function QueryCompiler.compileSingleQuery(...) with

    boolean isInRowKeyOrder = (innerPlan.getGroupBy() == GroupByCompiler.GroupBy.EMPTY_GROUP_BY) && (innerPlan.getOrderBy() == OrderByCompiler.OrderBy.EMPTY_ORDER_BY);

    return compileSingleFlatQuery(context, select, binds, asSubquery, allowPageFilter, innerPlan, tupleProjector, isInRowKeyOrder);

We're using squirrel 3.7

Did i miss something?

> 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)