I followed the following link to create a federation connection to Cloudera IMPALA[kerberos setup].
https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.data.fluidquery.doc/doc/t0070315.htmlBut its failing with the below error. My windows ODBC Connection [from ODBC Data source administrator to Impala works fine]. Where can I get more information about this error ?
"Connecting to the server IMPALA_2 has failed. Please make sure that the remote data server is available and a user mapping for the current user is created correctly on the Manage User Mappings page."
CREATE SERVER IMPALA_2 TYPE IMPALA VERSION 6.0 WRAPPER ODBC authorization "zsmdha1u@corp.abc.com" password "******" OPTIONS (host 'impala.iglbqa.abc.com', port '21050', dbname 'MDH_ESMSOR', SERVER_PRINCIPAL_NAME '
zsmdha1u@corp.abc.com', pushdown 'Y');
CREATE USER MAPPING FOR bluadmin SERVER IMPALA_2 OPTIONS (REMOTE_AUTHID '
zsmdha1u@corp.abc.com', REMOTE_PASSWORD '"******"', CLIENT_PRINCIPAL_NAME '
zsmdha1u@corp.abc.com');
------------------------------
Prem
------------------------------
#IntegratedAnalyticsSystem