On 10-01-2013 23:04:24 +0000, Luis Neves wrote:
On 01/10/2013 09:26 AM, Fabian Groffen wrote:
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.
Where does the hllagg function come from? Does it perhaps write to the stream or flush? It looks like the server sends some sequence the JDBC driver doesn't like.
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;";
-- Fabian Groffen fabian@monetdb.org column-store pioneer http://www.monetdb.org/Home _______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list