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

;ianghaibin commented on CALCITE-3241:
--------------------------------------

OK ,

 
 
  
Just table structure   is  INTEGER 
1: jdbc:calcite:model=/root/calcite/apache-ca> !describe "liucun"
+-----------+-------------+------------+-----------------+-----------+---------------------+-------------+---------------+----------------+----------------+----------+---------+-------------+
| TABLE_CAT | TABLE_SCHEM | TABLE_NAME | COLUMN_NAME | DATA_TYPE | TYPE_NAME | 
COLUMN_SIZE | BUFFER_LENGTH | DECIMAL_DIGITS | NUM_PREC_RADIX | NULLABLE | 
REMARKS | COLUMN_DEF |
+-----------+-------------+------------+-----------------+-----------+---------------------+-------------+---------------+----------------+----------------+----------+---------+-------------+

| | click | liucun | xx | 4 | INTEGER NOT NULL | -1 | null | null | 10 | 0 | | |
| | click | liucun | days| 4 | INTEGER NOT NULL | -1 | null | null | 10 | 0 | | 
|
+-----------+-------------+------------+-----------------+-----------+---------------------+-------------+---------------+----------------+----------------+----------+---------+---------

 

This is the song error recurrence

 

1: jdbc:calcite:model=/root/calcite/apache-ca> select "xx",sum("days") from 
"liucun" group by "xx" limit 2;
+-----------+--------+
|xx | EXPR$1 |
+-----------+--------+
| 00016G442 | 452 |
| 00016Z551 | 478 |
+-----------+--------+
2 rows selected (1.032 seconds)
1: jdbc:calcite:model=/root/calcite/apache-ca> select sum("days") from "liucun";
java.lang.NumberFormatException: For input string: "13485468068"
 at 
ru.yandex.clickhouse.response.ByteFragmentUtils.parseInt(ByteFragmentUtils.java:61)
 at 
ru.yandex.clickhouse.response.ClickHouseResultSet.getInt(ClickHouseResultSet.java:342)
 at 
org.apache.commons.dbcp2.DelegatingResultSet.getInt(DelegatingResultSet.java:623)
 at 
org.apache.commons.dbcp2.DelegatingResultSet.getInt(DelegatingResultSet.java:623)
 at Baz$1$1.apply(Unknown Source)
 at 
org.apache.calcite.runtime.ResultSetEnumerable$ResultSetEnumerator.current(ResultSetEnumerable.java:365)
 at org.apache.calcite.linq4j.Linq4j$EnumeratorIterator.next(Linq4j.java:683)
 at org.apache.calcite.avatica.util.IteratorCursor.next(IteratorCursor.java:46)
 at org.apache.calcite.avatica.AvaticaResultSet.next(AvaticaResultSet.java:217)
 at sqlline.BufferedRows.nextList(BufferedRows.java:110)
 at sqlline.BufferedRows.<init>(BufferedRows.java:52)
 at sqlline.SqlLine.print(SqlLine.java:1640)
 at sqlline.Commands.executeSingleQuery(Commands.java:1017)
 at sqlline.Commands.execute(Commands.java:957)
 at sqlline.Commands.sql(Commands.java:921)
 at sqlline.SqlLine.dispatch(SqlLine.java:717)
 at sqlline.SqlLine.begin(SqlLine.java:536)
 at sqlline.SqlLine.start(SqlLine.java:266)
 at sqlline.SqlLine.main(SqlLine.java:205)
1: jdbc:calcite:model=/root/calcite/apache-ca>

 

Of course, this error does not occur in other integer fields in a table.

 

| | click | liucun | str_id | 12 | VARCHAR(0) NOT NULL | 0 | null | null | 10 | 
0 | | |
| | click | liucun | map_act_id | 4 | INTEGER NOT NULL | -1 | null | null | 10 
| 0 | | |
| | click | liucun | days | 4 | INTEGER NOT NULL | -1 | null | null | 10 | 0 | 
| |
+-----------+-------------+------------+-----------------+-----------+---------------------+-------------+---------------+----------------+----------------+----------+---------+-------------+
1: jdbc:calcite:model=/root/calcite/apache-ca> select sum("map_act_id") from 
"liucun";
+-----------+
| EXPR$0 |
+-----------+
| 956366751 |
+-----------+
1 row selected (0.363 seconds)
1: jdbc:calcite:model=/root/calcite/apache-ca> select sum("days") from "liucun";
java.lang.NumberFormatException: For input string: "13485468068"
 at 
ru.yandex.clickhouse.response.ByteFragmentUtils.parseInt(ByteFragmentUtils.java:61)
 at 
ru.yandex.clickhouse.response.ClickHouseResultSet.getInt(ClickHouseResultSet.java:342)
 at 
org.apache.commons.dbcp2.DelegatingResultSet.getInt(DelegatingResultSet.java:623)
 at 
org.apache.commons.dbcp2.DelegatingResultSet.getInt(DelegatingResultSet.java:623)
 at Baz$1$1.apply(Unknown Source)
 at 
org.apache.calcite.runtime.ResultSetEnumerable$ResultSetEnumerator.current(ResultSetEnumerable.java:365)
 at org.apache.calcite.linq4j.Linq4j$EnumeratorIterator.next(Linq4j.java:683)
 at org.apache.calcite.avatica.util.IteratorCursor.next(IteratorCursor.java:46)
 at org.apache.calcite.avatica.AvaticaResultSet.next(AvaticaResultSet.java:217)
 at sqlline.BufferedRows.nextList(BufferedRows.java:110)
 at sqlline.BufferedRows.<init>(BufferedRows.java:52)
 at sqlline.SqlLine.print(SqlLine.java:1640)
 at sqlline.Commands.executeSingleQuery(Commands.java:1017)
 at sqlline.Commands.execute(Commands.java:957)
 at sqlline.Commands.sql(Commands.java:921)
 at sqlline.SqlLine.dispatch(SqlLine.java:717)
 at sqlline.SqlLine.begin(SqlLine.java:536)
 at sqlline.SqlLine.start(SqlLine.java:266)
 at sqlline.SqlLine.main(SqlLine.java:205)
1: jdbc:calcite:model=/root/calcite/apache-ca>

 

 

> Calcite this is a very strange mistake
> --------------------------------------
>
>                 Key: CALCITE-3241
>                 URL: https://issues.apache.org/jira/browse/CALCITE-3241
>             Project: Calcite
>          Issue Type: Bug
>            Reporter: ;ianghaibin
>            Priority: Major
>
> 0: jdbc:calcite:model=/root/calcite/apache-ca> select sum("xxx") as a from 
> "xxx";
> java.lang.NumberFormatException: For input string: "13485468068"
> at 
> ru.yandex.clickhouse.response.ByteFragmentUtils.parseInt(ByteFragmentUtils.java:61)
> at 
> ru.yandex.clickhouse.response.ClickHouseResultSet.getInt(ClickHouseResultSet.java:342)
> at 
> org.apache.commons.dbcp2.DelegatingResultSet.getInt(DelegatingResultSet.java:623)
> at 
> org.apache.commons.dbcp2.DelegatingResultSet.getInt(DelegatingResultSet.java:623)
> at Baz$1$1.apply(Unknown Source)
> at 
> org.apache.calcite.runtime.ResultSetEnumerable$ResultSetEnumerator.current(ResultSetEnumerable.java:365)
> at org.apache.calcite.linq4j.Linq4j$EnumeratorIterator.next(Linq4j.java:683)
> at org.apache.calcite.avatica.util.IteratorCursor.next(IteratorCursor.java:46)
> at org.apache.calcite.avatica.AvaticaResultSet.next(AvaticaResultSet.java:217)
> at sqlline.BufferedRows.nextList(BufferedRows.java:110)
> at sqlline.BufferedRows.(BufferedRows.java:52)
> at sqlline.SqlLine.print(SqlLine.java:1640)
> at sqlline.Commands.executeSingleQuery(Commands.java:1017)
> at sqlline.Commands.execute(Commands.java:957)
> at sqlline.Commands.sql(Commands.java:921)
> at sqlline.SqlLine.dispatch(SqlLine.java:717)
> at sqlline.SqlLine.begin(SqlLine.java:536)
> at sqlline.SqlLine.start(SqlLine.java:266)
> at sqlline.SqlLine.main(SqlLine.java:205)
> The data I got is integer, and I am getting an error.
> However, this is not an error.
> select "xx","xx",sum("xx") as xx from "xx" group by "xx","xxx" limit 1;



--
This message was sent by Atlassian JIRA
(v7.6.14#76016)

Reply via email to