Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

Re: Querying Hive tables using DBD::ODBC

by poj (Abbot)
on Oct 29, 2018 at 07:34 UTC ( [id://1224821]=note: print w/replies, xml ) Need Help??


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
    Duh! You wouldn't think I'd been using DBI since the late 90s! Thanks for the fresh pair of eyes - I couldn't see the wood for the trees

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1224821]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (2)
As of 2024-04-26 04:47 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found