http://qs321.pair.com?node_id=1224821


in reply to Querying Hive tables using DBD::ODBC

->fetchall_arrayref fetches all records so you don't need to loop (unless you don't have enough memory to fetch and return all the rows in one go.)

my $rows = $sth->fetchall_arrayref; say Dumper $rows;

Try fetching each row using ->fetchrow_arrayref.

#while (my $row = $sth->fetchall_arrayref) {
while (my $row = $sth->fetchrow_arrayref) {
   say Dumper $row;
}
poj