[
https://issues.apache.org/jira/browse/PHOENIX-2687?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15152748#comment-15152748
]
Vivek K T commented on PHOENIX-2687:
------------------------------------
Hey [~sergey.soldatov], even after applying the patch, I'm still getting the
following exception on squirrel client :
[2016-02-18 23:21:14.629 IST] ERROR [] [] [] [] [] [] [] [] [] Thread-11
net.sourceforge.squirrel_sql.fw.sql.ResultSetReader [126] - Error reading
column data, column index = 1
java.lang.IllegalArgumentException: nanos > 999999999 or < 0
at java.sql.Timestamp.setNanos(Timestamp.java:386)
at
org.apache.phoenix.schema.types.PTimestamp.toObject(PTimestamp.java:111)
at
org.apache.phoenix.schema.types.PTimestamp.toObject(PTimestamp.java:31)
at
org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:997)
at
org.apache.phoenix.compile.ExpressionProjector.getValue(ExpressionProjector.java:75)
at
org.apache.phoenix.jdbc.PhoenixResultSet.getTimestamp(PhoenixResultSet.java:643)
at
net.sourceforge.squirrel_sql.fw.datasetviewer.cellcomponent.DataTypeTimestamp.readResultSet(DataTypeTimestamp.java:504)
at
net.sourceforge.squirrel_sql.fw.datasetviewer.cellcomponent.CellComponentFactory.readResultSet(CellComponentFactory.java:488)
at
net.sourceforge.squirrel_sql.fw.sql.ResultSetReader.doContentTabRead(ResultSetReader.java:613)
at
net.sourceforge.squirrel_sql.fw.sql.ResultSetReader.readRow(ResultSetReader.java:184)
at
net.sourceforge.squirrel_sql.fw.datasetviewer.ResultSetDataSet.createRow(ResultSetDataSet.java:238)
at
net.sourceforge.squirrel_sql.fw.datasetviewer.ResultSetDataSet._setResultSet(ResultSetDataSet.java:204)
at
net.sourceforge.squirrel_sql.fw.datasetviewer.ResultSetDataSet.setSqlExecutionTabResultSet(ResultSetDataSet.java:127)
at
net.sourceforge.squirrel_sql.client.session.mainpanel.SQLExecutionHandler.sqlResultSetAvailable(SQLExecutionHandler.java:423)
at
net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.processResultSet(SQLExecuterTask.java:549)
at
net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.processQuery(SQLExecuterTask.java:414)
at
net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.run(SQLExecuterTask.java:212)
at
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Thread.java:744)
> 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)
