ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Atri Sharma <atri.j...@gmail.com>
Subject Re: Execution of query functions.
Date Wed, 29 Jul 2015 15:19:05 GMT
How exactly is the per node result set merged into a single CSV file for
this? Would that need some file locks/synchronization?

On Wed, Jul 29, 2015 at 8:45 PM, Sergi Vladykin <sergi.vladykin@gmail.com>
wrote:

> I don't think this will work in distributed environment correctly now. If
> you want CSV export it must be implemented outside of SQL layer.
>
> Sergi
>
> 2015-07-29 14:13 GMT+03:00 Alexey Kuznetsov <akuznetsov@gridgain.com>:
>
> > Sergi Vladykin,
> >
> > I remember that we have same issue with "explain" queries.
> > I think fix should be pretty simple.
> >
> > If it is so, let us know and Vasiliy will create issue for it.
> >
> > On Wed, Jul 29, 2015 at 5:47 PM, Vasiliy Sisko <vsisko@gridgain.com>
> > wrote:
> >
> > > Hello Igniters.
> > >
> > > I try to execute SqlFieldsQuery with following statement:
> > > CALL CSVWRITE('/tmp/test.csv', 'SELECT * FROM WorkedHours')
> > > and receive next exception:
> > > class org.apache.ignite.IgniteException: Unknown query type: CALL
> > > CSVWRITE('/tmp/test.csv', 'SELECT * FROM WorkedHours')
> > >
> > > That query worked on GridGain 6.x
> > >
> > > Could we support such queries in Ignite?
> > >
> > > --
> > > Vasiliy Sisko
> > > GridGain Systems
> > > www.gridgain.com
> > >
> >
> >
> >
> > --
> > Alexey Kuznetsov
> > GridGain Systems
> > www.gridgain.com
> >
>



-- 
Regards,

Atri
*l'apprenant*

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message