将MicroStrategy连接到身份验证的Apache配置单元
问题描述:
我已经安装了MicroStrategy BI工具和Apache Hive-1.1.x以及Hadoop服务。将MicroStrategy连接到身份验证的Apache配置单元
Started hiveserver2
and hadoop services
。并测试连接,完美工作。我没有使用任何身份验证来运行此服务。
有没有任何选项可以将非SASL Apache配置单元服务器与MicroStrategy连接? 如果没有用户和密码,则无法在MicroStrategy中创建DSN。
我用下面的步骤来与Apache蜂巢连接 “添加新Datasource-> Hadoop-> DSN的Datasource->的Apache蜂巢”
如果我给的用户和密码的任何未知值意味着抛以下错误
There is an error. Details
(Database error <5>: Connect failed. Error type: Odbc error. Odbc operation
attempted: SQLDriverConnect. [S1000:5: on HDBC] [MicroStrategy][ThriftExtension]
(5) Error occurred while contacting server: No more data to read.. This could be
because you are trying to establish a non-SSL connection to a SSL-enabled
server.
答
我发现蜂房的site.xml的问题,hive.server2.authentication值已用作NONE。 NOSASL
是原始运输,其中有用户名和密码。在蜂房的site.xml
添加以下属性
<property>
<name>hive.server2.authentication</name>
<value>NONE</value>
<description>
Expects one of [nosasl, none, ldap, kerberos, pam, custom].
Client authentication types.
NONE: no authentication check
LDAP: LDAP/AD based authentication
KERBEROS: Kerberos/GSSAPI authentication
CUSTOM: Custom authentication provider
(Use with property hive.server2.custom.authentication.class)
PAM: Pluggable authentication module
NOSASL: Raw transport
</description>
</property>