Or is there another way I can pull data from hive using php?
On 03/27/2014 11:54 AM, Jeremy wrote: > https://cwiki.apache.org/confluence/display/Hive/HiveClient#HiveClient-PHP > > What kind of setup and what do I need to do to get this client to run? > > > <?php > // set THRIFT_ROOT to php directory of the hive distribution > $GLOBALS['THRIFT_ROOT'] = '/lib/php/'; > // load the required files for connecting to Hive > require_once $GLOBALS['THRIFT_ROOT'] . > 'packages/hive_service/ThriftHive.php'; > require_once $GLOBALS['THRIFT_ROOT'] . 'transport/TSocket.php'; > require_once $GLOBALS['THRIFT_ROOT'] . 'protocol/TBinaryProtocol.php'; > // Set up the transport/protocol/client > $transport = new TSocket('localhost', 10000); > $protocol = new TBinaryProtocol($transport); > $client = new ThriftHiveClient($protocol); > $transport->open(); > > // run queries, metadata calls etc > $client->execute('SELECT * from src'); > var_dump($client->fetchAll()); > $transport->close(); > > Thanks >
