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
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^2: Querying Hive tables using DBD::ODBC
by astroboy (Chaplain) on Oct 29, 2018 at 20:20 UTC |
In Section
Seekers of Perl Wisdom