Le mardi 20 janvier 2015 10:40:05, Jürgen E. Fischer a écrit :
> Hi Matteo,
>
> On Tue, 20. Jan 2015 at 09:47:50 +0100, Matteo Ghetta wrote:
> > yes, the column is ID.
>
> Meaning that ID is the only column in au? Did you try to use ID instead of
> *?
>
> > On Fri, 16. Jan 2015 at 10:48:16 +010
Hi Matteo,
On Tue, 20. Jan 2015 at 09:47:50 +0100, Matteo Ghetta wrote:
> yes, the column is ID.
Meaning that ID is the only column in au? Did you try to use ID instead of *?
> On Fri, 16. Jan 2015 at 10:48:16 +0100, Matteo Ghetta wrote:
> > GDAL execution console output
> >
> > ERROR 1: SQL E
Hi Jürgen,
yes, the column is ID.
BTW, if I import the shapefile in SpatiaLite (or PostGIS) through DB
Manager the same query works and I can easily load the file in QGIS.
Maybe GROUP BY function is not supported in Processing yet?
Thanks
Matteo
___
Qg
Hi Matteo,
On Fri, 16. Jan 2015 at 10:48:16 +0100, Matteo Ghetta wrote:
> I'm trying to run the Processing Execute SQL algorithm with super simple
> following query:
>
> select * from au where ID > 100 group by ID
Um, is ID the only column? Otherwise I'd expect that it needs to be
(as it would
Hi Matteo,
I thing the problem is that "GROUP BY" is not supported on shapefile
format.
Il 16/01/2015 12.08, Matteo Ghetta ha scritto:
mmm I made some attempts but always the same parsing error..
so, you are saying that the error in Processing is related to the
GEOMETRY column right?
in the
mmm I made some attempts but always the same parsing error..
so, you are saying that the error in Processing is related to the GEOMETRY
column right?
in the DB manager I can run the same query and then load the file when I
specify the GEOMETRY column. That's ok
But why I don't have any problem wi
Ok,
I see some issues:;:
1- your query does WHERE + GROUp BY. SQL standards requires a HAVING
CLAUSE with group by:
select * from au group by ID HAVING ID > 100
2- Geoprocessing waits for a spatial layer in return. I think you need to
add explicit aggregate operators for your columns and geom
Hi Régis,
nope, same error with the quotes.
BTW: `au` is a shapefile, but if I load it in a SpatiaLite DB and if I use
DB Manager the query runs without problems.
Last information: same error in 2.6 and in Master
Cheers
Matteo
___
Qgis-developer maili
Hi,
not sure, did you try double quotes on fields names, like:
select * from au where "ID" > 100 group by "ID"
?
Régis
--
View this message in context:
http://osgeo-org.1560.x6.nabble.com/problem-with-GROUP-BY-in-Execute-SQL-Processing-tp5181825p5181832.html
Sent from the Quantum GIS - Deve
Hi guys,
I'm trying to run the Processing Execute SQL algorithm with super simple
following query:
select * from au where ID > 100 group by ID
But it returns this error (Processing log):
GDAL execution console output
ERROR 1: SQL Expression Parsing Error: syntax error
No problem with other si
10 matches
Mail list logo