Query.list_rows
This method is deprecated. See the other table.to_* methods for different approaches to loading data.
For similar functionality but improved performance, see Table.to_arrow_table().to_pydict()
Query.list_rows(max_results=None, *, progress=True) → list<namedtuple>
Return a list of rows in the query results.
Parameters:
max_results
: int, default None
The maximum number of rows to return. If not specified, all rows in the query results will be read.
progress
: bool, default True
Whether to display a progress bar.
Returns:
list<namedtuple>
Notes:
When calling list_rows
, a python list of named tuples will be returned, allowing you to reference values in each row by either the variable name or offset. E.g.,:
rows = (
redivis.query("""
SELECT 1 + 1 AS some_number, 'foo' AS some_string
UNION ALL
SELECT 4, 'bar'
""").list_rows()
)
print(rows) # [Row(some_number='2', some_string='foo'), Row(some_number='4', some_string='bar')]
rows[0]["some_number"] # 2
rows[0][1] # "foo"
Last updated
Was this helpful?