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 <lsidir@gmail.com> 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 <ketan780@gmail.com> 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