AnsweredAssumed Answered

Queries about PI-ODBC

Question asked by sharon.meng on Sep 6, 2019
Latest reply on Sep 6, 2019 by jyi

Hello, my predecessors


      I am a beginner of pi. Now I use ODBC to query pi.


       I found that if I used select * from pipoint where time >='2019-09-01'and time <='2019-09-05',


       it would execute a long time later and report an error of 504 GateWay Time-out.


      But if I changed to select * from pipoint where time >='2019-09-01' and tag='xxx',


       the data would be queried. So I was wondering if my SQL query for the time-range query was wrong, or if the query for PI itself relied on tag.