When I attempted to use double quotes around 'name' , I received "SyntaxError: invalid syntax"
On Tue, Jun 14, 2016 at 10:02 PM, Ross McDonald <[email protected]> wrote: > The word "name" is a keyword within InfluxQL, so you have to wrap it in > double-quotes. Do you get the same error if you update the query to the > following (wrapping 'name' in double-quotes)? > > > SELECT * FROM bmspoint WHERE time > now() - 10m AND "name" = > 'B10_Area3for2_E_MtrEl6_PwrActv' > > You can find more information on proper quoting in the InfluxDB > documentation FEI here > <https://docs.influxdata.com/influxdb/v0.13/troubleshooting/frequently_encountered_issues/#single-quoting-and-double-quoting-in-queries> > . > > Thanks, > Ross > > On Mon, Jun 13, 2016 at 10:01 PM, <[email protected]> wrote: > >> I'm trying to collect data from a particular sensor, so I used the >> following code to retrieve the data. >> >> data = client.query("SELECT * FROM bmspoint WHERE time > now() - 10m AND >> name = 'B10_Area3for2_E_MtrEl6_PwrActv'") >> >> >> Although data does exist for this sensor in this particular time frame, I >> receive the following error. >> >> InfluxDBClientError Traceback (most recent call >> last) >> <ipython-input-252-a8110907c888> in <module>() >> 4 if n.find(request) != -1: >> 5 print ("True") >> ----> 6 data2 = client.query("SELECT * FROM bmspoint WHERE time > >> now() - 10m AND name = 'B10_Area3for2_E_MtrEl6_PwrActv'") >> 7 print data2 >> 8 else: >> >> /Users/3for2/anaconda/lib/python2.7/site-packages/influxdb/_dataframe_client.pyc >> in query(self, query, chunked, database) >> 77 >> 78 """ >> ---> 79 results = super(DataFrameClient, self).query(query, >> database=database) >> 80 if query.upper().startswith("SELECT"): >> 81 if len(results) > 0: >> >> /Users/3for2/anaconda/lib/python2.7/site-packages/influxdb/client.pyc in >> query(self, query, params, epoch, expected_response_code, database, >> raise_errors) >> 323 params=params, >> 324 data=None, >> --> 325 expected_response_code=expected_response_code >> 326 ) >> 327 >> >> /Users/3for2/anaconda/lib/python2.7/site-packages/influxdb/client.pyc in >> request(self, url, method, params, data, expected_response_code, headers) >> 246 return response >> 247 else: >> --> 248 raise InfluxDBClientError(response.content, >> response.status_code) >> 249 >> 250 def write(self, data, params=None, >> expected_response_code=204): >> >> InfluxDBClientError: 400: {"error":"error parsing query: found NAME, >> expected identifier, string, number, bool at line 1, char 53"} >> >> >> I did not receive this error when I used other tags. Any advice? >> >> Thanks! >> >> -- >> Remember to include the InfluxDB version number with all issue reports >> --- >> You received this message because you are subscribed to the Google Groups >> "InfluxDB" 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 https://groups.google.com/group/influxdb. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/influxdb/b93de22f-af40-48df-804d-3c570bb01803%40googlegroups.com >> . >> For more options, visit https://groups.google.com/d/optout. >> > > -- > Remember to include the InfluxDB version number with all issue reports > --- > You received this message because you are subscribed to a topic in the > Google Groups "InfluxDB" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/influxdb/1xO89WxckRs/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/influxdb. > To view this discussion on the web visit > https://groups.google.com/d/msgid/influxdb/CAD8sRLD46J39p0jcYYv%3DmSWcRGqWpKqa7H0TuP_twpFn%2BAq-MA%40mail.gmail.com > <https://groups.google.com/d/msgid/influxdb/CAD8sRLD46J39p0jcYYv%3DmSWcRGqWpKqa7H0TuP_twpFn%2BAq-MA%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > > For more options, visit https://groups.google.com/d/optout. > -- Melissa Flores The University of Texas at Austin Cockrell School of Engineering | Architectural Engineering Senate of College Councils | Co-Chair, Undergraduate Research Committee -- Remember to include the InfluxDB version number with all issue reports --- You received this message because you are subscribed to the Google Groups "InfluxDB" 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 https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/CAHFqZhRg3N70ZVRad2BQJ5H948qEBm-w5_qNH266ChjENgBcyg%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
