On 01/10/2013 09:26 AM, Fabian Groffen wrote:
I tried reproducing your error here
MonetDB 5 server v11.13.8 "Oct2012-d1937899c419" (64-bit, 64-bit oids) Driver: v2.8 (Liberica 20130110 based on MCL v1.8)
and it runs without problems (on my Mac).
I use attached load file, and simply issue a select * from largestrings using mclient and JdbcClient. Does that work for you on a simple table (created by the script) too?
It works here also... kind of... I created a table "tmp_foo": sql>\d tmp_foo CREATE TABLE "sys"."tmp_foo" ( "ts" BIGINT, "h_visitors_register" VARCHAR(1881) ); sql>INSERT INTO tmp_foo SELECT ts, hllagg(h_visitors_register) FROM wa_blogs_audience WHERE ts>=1355172393000 AND ts<=1357764393000 GROUP BY ts; 22 affected rows (157.172ms) In this sample program I only get this error when running the "sql_3" query... weird... they all have the same output. String sql_1 = "SELECT ts, h_visitors_register FROM tmp_foo;"; String sql_2 = "SELECT ts, hllagg(h_visitors_register) FROM tmp_foo GROUP BY ts;"; String sql_3 = "SELECT ts, hllagg(h_visitors_register) FROM wa_blogs_audience WHERE ts>=1355172393000 AND ts<=1357764393000 GROUP BY ts;"; Class.forName("nl.cwi.monetdb.jdbc.MonetDriver"); Connection conn = DriverManager.getConnection("jdbc:monetdb://host:9701/kpi_v1", "monetdb", "monetdb"); Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(sql_3); while (rs.next()) { System.out.print(rs.getLong(1)); System.out.print("\t"); System.out.println(rs.getString(2)); } rs.close(); stmt.close(); conn.close(); Thanks! -- /** * Luis Neves * @e-mail: luis.neves@co.sapo.pt * @xmpp: lfs_neves@sapo.pt * @web: http://technotes.blogs.sapo.pt/ * @tlm: +351 962 057 656 * -- * As opiniões expressas por mim não são * necessariamente opiniões em que eu acredito * -- */ _______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list