Re:

hi Lefteris, Thanks For help me... MonetDB version that we are using is: MonetDB v11.15.11 This is the Schema of my table::: create table enzensubstation_hour( edate date, eHour int, ss_id varchar(50), loc_id varchar(50), tot_active_power_h decimal(5,4), phase_differ_voltage_h decimal(8,6), stn_bat_voltage_h decimal(8,5) ); insert into enzensubstation_hour SELECT edate, CAST(SUBSTRING(etime,0,2) AS int) AS eHour, ss_id, loc_id, avg(tot_active_power) as tot_active_power_h, avg(phase_differ_voltage) as phase_differ_voltage_h, avg(stn_bat_voltage) as stn_bat_voltage_h FROM enzensubstation group by edate, ehour, ss_id, loc_id ; Thanks Ketan Sharma On Mon, Jul 22, 2013 at 12:55 PM, Lefteris wrote:

Hi Ketan,

This does not sound right.

could you please tell us which MonetDB version are you using, also could you give us the complete query, as well as the output of running the query prefixed with "explain" ?

Also can you tell us the schema of the table and if you have any constraints on it, such as primary key?

thank you,

lefteris

On Mon, Jul 22, 2013 at 9:06 AM, Ketan Sharma wrote:

...

Hi all, I'm Ketan and I'm new to Monet DB. I have successfully installed MonetDB. I have a table of size ~200MB which is to be inserted into another MonetDB Table. But while inserting data using SELECT command, I am getting the following error:

#================================================ GDK reported error. BATfetchjoin(tmpr_2257,tmp_ 2241) does not hit always (|bn|=0 != 10=|l|) => can't use fetchjoin. #================================================

Please do help me in getting this error solved. Thanks.

_______________________________________________ developers-list mailing list developers-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/developers-list

_______________________________________________ developers-list mailing list developers-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/developers-list