Just another Perl shrine | |
PerlMonks |
Re: Querying Hive tables using DBD::ODBCby poj (Abbot) |
on Oct 29, 2018 at 07:34 UTC ( [id://1224821]=note: print w/replies, xml ) | Need Help?? |
->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.)
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
|
|