You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@ignite.apache.org by pingzing <ji...@gmail.com> on 2017/06/09 22:19:53 UTC

SQL Query against BigDecimal value field

Anyone with experience? A simple query against BigDecimal value field doesn't
work.
Also query from DBeaver via JDBC or Tableau via ODBC doesn't show the
correct number. Am I missing something? I have no problem switching the
field to DOUBLE.

SELECT SUM(SomeBigDecimalValueField) FROM SomeCache




--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/SQL-Query-against-BigDecimal-value-field-tp13584.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: SQL Query against BigDecimal value field

Posted by Igor Sapego <is...@gridgain.com>.

Hi,

We need a little bit more info. What is the expected and real values?
Does JDBC, ODBC and API show the same value?

Best Regards,
Igor

On Sat, Jun 10, 2017 at 1:19 AM, pingzing <ji...@gmail.com> wrote:

> Anyone with experience? A simple query against BigDecimal value field
> doesn't
> work.
> Also query from DBeaver via JDBC or Tableau via ODBC doesn't show the
> correct number. Am I missing something? I have no problem switching the
> field to DOUBLE.
>
> SELECT SUM(SomeBigDecimalValueField) FROM SomeCache
>
>
>
>
> --
> View this message in context: http://apache-ignite-users.
> 70518.x6.nabble.com/SQL-Query-against-BigDecimal-value-field-tp13584.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>