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
In Section
Seekers of Perl Wisdom