That query doesn't trigger any errors when run from the InfluxDB CLI, so it
might be referring to a Python syntax error. I would also expect to see an
exception if it was an error returned from InfluxDB.
Thanks,
Ross
On Wed, Jun 15, 2016 at 7:44 PM, Melissa Flores <meli.f...@live.com> wrote:
> data = client.query("SELECT * FROM bmspoint WHERE time > now() - 10m AND
> "name" = 'B10_Area3for2_E_MtrEl17_PwrActv'")
>
> Output:
>
> File "<ipython-input-587-bb9b83c27768>", line 1
> data = client.query("SELECT * FROM bmspoint WHERE time > now() - 10m AND
> "name" = 'B10_Area3for2_E_MtrEl17_PwrActv'")
> ^ SyntaxError: invalid syntax
>
>
> On Wed, Jun 15, 2016 at 8:39 PM, Ross McDonald <r...@influxdb.com> wrote:
>
>> Can you paste the full query and error output? It sounds like there might
>> be something else off with the query syntax.
>>
>> Thanks,
>> Ross
>>
>> On Tue, Jun 14, 2016 at 8:45 PM, Melissa Flores <meli.f...@live.com>
>> wrote:
>>
>>> 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 <r...@influxdb.com>
>>> 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, <melissa.flores...@gmail.com> 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 influxdb+unsubscr...@googlegroups.com.
>>>>> To post to this group, send email to influxdb@googlegroups.com.
>>>>> 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
>>>> influxdb+unsubscr...@googlegroups.com.
>>>> To post to this group, send email to influxdb@googlegroups.com.
>>>> 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 influxdb+unsubscr...@googlegroups.com.
>>> To post to this group, send email to influxdb@googlegroups.com.
>>> 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
>>> <https://groups.google.com/d/msgid/influxdb/CAHFqZhRg3N70ZVRad2BQJ5H948qEBm-w5_qNH266ChjENgBcyg%40mail.gmail.com?utm_medium=email&utm_source=footer>
>>> .
>>>
>>> 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
>> influxdb+unsubscr...@googlegroups.com.
>> To post to this group, send email to influxdb@googlegroups.com.
>> 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/CAD8sRLCv-S_f67tpy35%2Bd9xoSd-fi%3DC3qY02F7%3DsX4z6vY23Lw%40mail.gmail.com
>> <https://groups.google.com/d/msgid/influxdb/CAD8sRLCv-S_f67tpy35%2Bd9xoSd-fi%3DC3qY02F7%3DsX4z6vY23Lw%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 influxdb+unsubscr...@googlegroups.com.
> To post to this group, send email to influxdb@googlegroups.com.
> 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/CAHFqZhSwcWkT%2BnGkP%2B7g%2BaHKm09weLiqXj3WOSB5XVZcFPhSLQ%40mail.gmail.com
> <https://groups.google.com/d/msgid/influxdb/CAHFqZhSwcWkT%2BnGkP%2B7g%2BaHKm09weLiqXj3WOSB5XVZcFPhSLQ%40mail.gmail.com?utm_medium=email&utm_source=footer>
> .
>
> 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 the Google Groups
"InfluxDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
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/CAD8sRLC83DWU0NYyX7AJgminEj5y-nSS_A53U065MD3Gj5eaSw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
