Stefan Manegold Stefan.Manegold at cwi.nl
Mon Jul 22 10:08:38 CEST 2013


Ketan,

could you please also share the schema of your enzensubstation table?

Does the select query (without insert part) work fine?

If not, could you please also share the EXPLAIN of the select part?

Thanks!
Stefan

----- Original Message -----
> can you also please send the output of
> explain [query]
> 
> where [query] is the insert query. So we can see which leftfetchjoin
> complains? Run twice the query, one with explain and one alone and
> send both outputs exactly as they appear.
> 
> Thank you
> 
> On Mon, Jul 22, 2013 at 10:37 AM, Ketan Sharma <ketan780 at gmail.com> wrote:
> > 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 at 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 at 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 at monetdb.org
> >> > http://mail.monetdb.org/mailman/listinfo/developers-list
> >> >
> >> _______________________________________________
> >> developers-list mailing list
> >> developers-list at monetdb.org
> >> http://mail.monetdb.org/mailman/listinfo/developers-list
> >
> >
> >
> > _______________________________________________
> > developers-list mailing list
> > developers-list at monetdb.org
> > http://mail.monetdb.org/mailman/listinfo/developers-list
> >
> _______________________________________________
> developers-list mailing list
> developers-list at monetdb.org
> http://mail.monetdb.org/mailman/listinfo/developers-list
> 

-- 
| Stefan.Manegold at CWI.nl | DB Architectures   (DA) |
| www.CWI.nl/~manegold/  | Science Park 123 (L321) |
| +31 (0)20 592-4212     | 1098 XG Amsterdam  (NL) |




More information about the developers-list mailing list