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"