解决Python连接hive环境问题

问题

(root) [user_00@VM_121_192_centos ~/ivan.chen]$ python demo.py 
Traceback (most recent call last):
  File "demo.py", line 4, in <module>
    g_spark_conn = create_engine('hive://hdfs:LXA0QVdTY3lMWms1V09HMFRD@10.0.2.245:10015/xy_ods', connect_args={'auth':'LDAP'})
  File "/home/user_00/ivan.chen/miniconda3/lib/python3.6/site-packages/sqlalchemy/engine/__init__.py", line 425, in create_engine
    return strategy.create(*args, **kwargs)
  File "/home/user_00/ivan.chen/miniconda3/lib/python3.6/site-packages/sqlalchemy/engine/strategies.py", line 57, in create
    entrypoint = u._get_entrypoint()
  File "/home/user_00/ivan.chen/miniconda3/lib/python3.6/site-packages/sqlalchemy/engine/url.py", line 156, in _get_entrypoint
    cls = registry.load(name)
  File "/home/user_00/ivan.chen/miniconda3/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 221, in load
    (self.group, name))
sqlalchemy.exc.NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:hive

解决

yum install gcc-c++ python-devel.x86_64 cyrus-sasl-devel.x86_64
pip install pyhive
pip install thrift
pip install sasl
pip install thrift-sasl