Re: SQL Query on REST APIs
Hi Francesco, Francesco wrote > But let me notice you that the example in your link > (https://apacheignite.readme.io/docs/rest-api#sql-query-execute) is wrong, > in fact it uses 'pzs' instead of 'pageSize'. This is what has confused me. Sorry for the late reply. Thank you for your note, I've fixed the examples involved. You can also help us improve and fix the documentation by using a 'Suggest Edits' link. -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/SQL-Query-on-REST-APIs-tp4815p6311.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.
Re: SQL Query on REST APIs
Hi, Francesco. I’ve found the problem in your second query: http://hostaddress:8080/ignite?cmd=qryexe=Integer&=cacheName=traccia=10=order+by+%5FVAL+desc+limit+10 According https://apacheignite.readme.io/docs/rest-api#sql-query-execute parameter "Page size for the query" must have name: "pageSize" not "pzs" I’ve created the ticket for correct handle this case. https://issues.apache.org/jira/browse/IGNITE-3407 -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/SQL-Query-on-REST-APIs-tp4815p6035.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.
Re: SQL Query on REST APIs
Hi, Francesco. Sniffing web console traffic won't help you, because an agent directly connects to web console server. Do you have any antivirus or firewall software? If yes try to disable them. You could also try to sniff what happens then you sending a query request to rest server. 2016-06-29 9:29 GMT+03:00 Francesco <fran.arag...@gmail.com>: > Hi Alexei, > > I should be now properly subscribed. > > About your answer: > > 1) My cache has about 3000 entries (3 thousand). > > 2) I've not tried the client mode. Meanwhile I've tried the H2 console and, > from remote, it doesn't work. But using it on a local machine it works. (My > program is running on an AWS server, so I've configured H2 server to allow > external connections). > > 3) There are no errors in the server log. > > > Anyway I have a new: > > I've updated my cache configuration with 1 backup level per-node, and I've > accidentally noticed that now I can perform sql queries from gridgain > webconsole properly. > But I'm still not able to do this using rest APIs. > > Maybe is crazy, but I'm thinking I could analyse with a packet sniffer my > network traffic to see exactly what request is sent from webconsole to my > ignite cluster (or to the webagent, I don't know how do the webconsole > requests work). > > Do you think it could be usefull? > > > > -- > View this message in context: > http://apache-ignite-users.70518.x6.nabble.com/SQL-Query-on-REST-APIs-tp4815p5985.html > Sent from the Apache Ignite Users mailing list archive at Nabble.com. > -- Best regards, Alexei Scherbakov
Re: SQL Query on REST APIs
Hi, Francesco. Please properly subscribe to the user mailing list so community members can see your questions as soon as possible and provide answers on them quicker. All you need to do is send an email to user-subscr...@ignite.apache.orgî and follow simple instructions in the reply. How many entries do you have in cache? Have you tried to run a query using client mode or in H2 console ? [1] Have you any errors in the server log? [1] https://apacheignite.readme.io/docs/sql-queries#using-h2-debug-console -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/SQL-Query-on-REST-APIs-tp4815p5964.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.