Integrated Analytics System

Remote Federation Tables with IMPALA[ODBC] fails

  • 1.  Remote Federation Tables with IMPALA[ODBC] fails

    Posted Wed May 08, 2019 09:35 AM
    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.html

    But 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
    ------------------------------