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
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
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
___
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 be
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 +0100, Matteo
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
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 -
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
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
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
10 matches
Mail list logo