[Monetdb-developers] TPC-H Query-14
Hello, I am running TPC-H in the default version, updated 1 minute ago. Compilation in Debug mode and I am running in my Desktop at CWI. I loaded TPC-H SF-10 without constraints. [goncalve@alviss queries]$ mclient -lsql < 14.sql MAPI = monetdb@localhost:55000 QUERY = select ERROR = !SQLException:convert:too many digits (20 > 19) #select * from optimizer_stats() stats; % .stats, .stats # table_name % rewrite, count # name % clob, int # type % 7, 1 # length [ "joinidx", 0 ] [goncalve@alviss queries]$ Why do I get an Exception when I got a result? Regards, Romulo
On Thu, Jul 15, 2010 at 07:03:51PM +0200, Romulo Goncalves wrote:
Hello,
I am running TPC-H in the default version, updated 1 minute ago. Compilation in Debug mode and I am running in my Desktop at CWI.
I loaded TPC-H SF-10 without constraints.
[goncalve@alviss queries]$ mclient -lsql < 14.sql MAPI = monetdb@localhost:55000 QUERY = select ERROR = !SQLException:convert:too many digits (20 > 19) #select * from optimizer_stats() stats; % .stats, .stats # table_name % rewrite, count # name % clob, int # type % 7, 1 # length [ "joinidx", 0 ] [goncalve@alviss queries]$
Why do I get an Exception when I got a result?
"overflow" in decimal representation of intermediate result --- a known issue with TPCH Q14 with SF >=10 when using decimals in your schema (using floats or doubles, instead, would avoid the overflow, but provides less numerical accuracy) Stefan
Regards, Romulo
------------------------------------------------------------------------------ This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4199 |
On 15-07-2010 19:27:55 +0200, Stefan Manegold wrote:
Why do I get an Exception when I got a result?
Indeed, that violates the protocol.
"overflow" in decimal representation of intermediate result --- a known issue with TPCH Q14 with SF >=10 when using decimals in your schema (using floats or doubles, instead, would avoid the overflow, but provides less numerical accuracy)
participants (3)
-
Fabian Groffen -
Romulo Goncalves -
Stefan Manegold