不获取行(但也不获取任何错误)

z4iuyo4d  于 2021-06-10  发布在  Hbase
关注(0)|答案(1)|浏览(565)

我已经安装了一个apachephoenix数据库,我正在尝试使用python和phoenixdb插件来查询它。
我有一个包含以下行的表:

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| PK | did | sensorid | sensor_timestamp | EXTRA_LEVEL | EXTRA_SCALE | EXTRA_HEALTH | EXTRA_STATUS | EXTRA_PLUGGED | EXTRA_PRESENT | EXTRA_VOLTAGE | level_percent | temperature_C | EXTRA_TECHNOLOGY | EXTRA_TEMPERATURE |
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

当我尝试使用phoenixdb查询它时,它遗漏了一行我没有得到的内容,但是我没有得到任何错误。
我的查询代码是:

import phoenixdb

connection = phoenixdb.connect(<url>)
cursor = connection.cursor()

query = """select PK,"did", "sensorid", "sensor_timestamp", {3}
           from "sensor_data"
           where "did"='{0}'
           and "sensorid" = '{1}'
           and "sensor_timestamp" > '{2}'
           order by "sensor_timestamp"
           limit 10""".format(357139052213522, 902, 1463163952256, '"EXTRA_LEVEL", "EXTRA_SCALE", "EXTRA_HEALTH", ' \
             '"EXTRA_STATUS" "EXTRA_PLUGGED", "EXTRA_PRESENT", ' \
             '"EXTRA_VOLTAGE", "level_percent", "temperature_C", ' \
             '"EXTRA_TECHNOLOGY","EXTRA_TEMPERATURE"')

cursor.execute(query)

rows = cursor.fetchall()
for row in rows:
    print(row)

我的输出是:

['357139052213522_1486731821342_902', '357139052213522', '902', '1486731821342', '64', '100', '2', '2', 'true', '3990', '64.0', '25.0', 'Li-ion', '257']

数一数,我发现少了一件。。有人知道这是怎么回事吗?

4jb9z9bj

4jb9z9bj1#

可以。这真是个愚蠢的错误。我发现我的查询中缺少一个逗号。。解决了所有问题:

query = """select PK,"did", "sensorid", "sensor_timestamp", {3}
       from "sensor_data"
       where "did"='{0}'
       and "sensorid" = '{1}'
       and "sensor_timestamp" > '{2}'
       order by "sensor_timestamp"
       limit 10""".format(357139052213522, 902, 1463163952256, '"EXTRA_LEVEL", "EXTRA_SCALE", "EXTRA_HEALTH", ' \
         '"EXTRA_STATUS", "EXTRA_PLUGGED", "EXTRA_PRESENT", ' \
         '"EXTRA_VOLTAGE", "level_percent", "temperature_C", ' \
         '"EXTRA_TECHNOLOGY","EXTRA_TEMPERATURE"')

相关问题