Here is a query and a parser error I'm getting when passing query that is
using multiple columns in Group By and also using Order By:
Query:
select airportcode as 'Airport', rehabyear as 'Year', rehab as 'Capital
Plan', sum(rehabcost) as 'Cost' from
1QJuHSpcAPgtU62DY5UGTjRnUWa90p6obhelV3fA where airportcode='BOS' and
rehabyear>0 group by airportcode, rehabyear, rehab order by airportcode,
rehabyear, rehab
Error:
google.visualization.Query.setResponse({version:'0.5',reqId:'0',status:'error',errors:[{reason:'internal_error',
message:'Could not parse query'}]})
However using the same query without Order By works fine.
i.e.
select airportcode as 'Airport', crackrepair as 'Crack Repair',
sum(crackrepair_length) as 'Length (ft)' from
1QJuHSpcAPgtU62DY5UGTjRnUWa90p6obhelV3fA where airportcode='BOS' and
crackrepair_length>0 group by airportcode, crackrepair
Bogdan
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at
http://groups.google.com/group/google-visualization-api?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
