hive python thrift client

最新推荐文章于 2024-09-17 23:15:58 发布

lancefox

最新推荐文章于 2024-09-17 23:15:58 发布

阅读量118

点赞数

分类专栏： hadoop 文章标签： python 大数据

本文链接：https://blog.csdn.net/lancefox/article/details/84422845

版权

hadoop 专栏收录该内容

9 篇文章 0 订阅

订阅专栏



#!/usr/bin/env python
#coding:utf-8

import sys
sys.path.append("/usr/local/lib/python2.7/site-packages/py")
from hive_service import ThriftHive
from hive_service.ttypes import HiveServerException
from thrift import Thrift
from thrift.transport import TSocket
from thrift.transport import TTransport
from thrift.protocol import TBinaryProtocol

ip = '192.168.0.176'
port = 10000
#sql = "show tables"
sql = "select count(0) from test_table"

def hiveExe(sql):
        transport = None
        try:
                transport = TSocket.TSocket( ip , port )
                transport = TTransport.TBufferedTransport( transport )
                protocol = TBinaryProtocol.TBinaryProtocol( transport )
                client = ThriftHive.Client( protocol )
                transport.open()
                print "execute sql : %s \n" % sql 
                client.execute( sql )

                print "The return value is : \n"
                print client.fetchAll()
                print "\n......"

                transport.close()
        except Thrift.TException,tx:
                print '%s' % tx.message
        finally:
                if transport != None :
                        transport.close()
if __name__ == '__main__':
        hiveExe(sql)