Dear Wiki user, You have subscribed to a wiki page or wiki category on "Hadoop Wiki" for change notification.
The following page has been changed by RaghothamMurthy: http://wiki.apache.org/hadoop/Hive/HiveClient ------------------------------------------------------------------------------ = JDBC = For embedded mode, uri is just "jdbc:hive://". For standalone server, uri is "jdbc:hive://host:port/dbname" where host and port are determined by where the hive server is run. For example, "jdbc:hive://localhost:10000/default". Currently, the only dbname supported is "default". - + == JDBC Client Sample Code == {{{ import java.sql.SQLException; import java.sql.Connection; @@ -77, +77 @@ } } } - + }}} + == Running the JDBC Sample Code == + {{{ # Then on the command-line $ javac HiveJdbcClient.java @@ -164, +166 @@ = PHP = Operates only on a standalone server. + {{{ + <?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(); + }}} = Thrift Java Client = Operates both in embedded mode and on standalone server. + = ODBC = - Operates only on a standalone server. In the works. + Operates only on a standalone server. See [wiki:Self:Hive/HiveODBC HiveODBC]. = Thrift C++ Client = Operates only on a standalone server. In the works.
