Home Forums HDP on Linux – Installation ODBC connection to Hive

This topic contains 0 replies, has 1 voice, and was last updated by  Tarun Kumar 3 months ago.

  • Creator
    Topic
  • #57693

    Tarun Kumar
    Participant

    Hi I have installed Hortonworks Hive ODBC driver on my Linux server. I configured .odbc.ini and .hortonworks.hiveodbc.ini as mentioned in the document. When i try to test the odbc connection using isql i get the below error. Appreciate if someone could help me on this.

    # isql -v <data source name>

    Error Trace:

    Jul 23 01:48:42 DEBUG 2010535680 HardyConnection::LogConnectionSettings: End of DSIConnSettingResponseMap.
    Jul 23 01:48:42 TRACE 2010535680 HardyConnection::Connect: +++++ enter +++++
    Jul 23 01:48:42 TRACE 2010535680 HardyThriftHiveClient::HardyThriftHiveClient: +++++ enter +++++
    Jul 23 01:48:42 TRACE 2010535680 HardyThriftHiveClient::TestConnection: +++++ enter +++++
    Jul 23 01:48:42 DEBUG 2010535680 HardyThriftHiveClient::TestConnection():
    Jul 23 01:48:42 TRACE 2010535680 HardyThriftHiveClient::ExecuteUseDatabaseQuery: +++++ enter +++++
    Jul 23 01:48:42 DEBUG 2010535680 HardyThriftHiveClient::ExecuteUseDatabaseQuery():
    Jul 23 01:49:42 ERROR 2010535680 Connection::SQLConnectW: [Hortonworks][HiveODBC] (22) Error from ThriftHiveClient: EAGAIN (timed out)
    Jul 23 01:49:42 TRACE 2010535680 CInterface::SQLGetDiagRec: +++++ enter +++++
    Jul 23 01:49:42 TRACE 2010535680 CInterface::SQLGetDiagRec: +++++ enter +++++
    Jul 23 01:49:42 TRACE 2010535680 CInterface::SQLFreeHandle: +++++ enter +++++
    Jul 23 01:49:42 TRACE 2010535680 Environment::SQLFreeHandle: +++++ enter +++++
    Jul 23 01:49:42 TRACE 2010535680 HardyConnection::~HardyConnection: +++++ enter +++++
    Jul 23 01:49:42 TRACE 2010535680 HardyConnection::Disconnect: +++++ enter +++++
    Jul 23 01:49:42 TRACE 2010535680 HardyThriftHiveClient::GetAllTablesOfDatabase: +++++ enter +++++
    Jul 23 01:49:42 DEBUG 2010535680 HardyThriftHiveClient::GetAllTablesOfDatabase(std::vector<simba_string>& out_tables, const simba_string& in_database): in_schemaName=”default”
    Jul 23 01:50:43 TRACE 2010535680 HardyThriftHiveClient::~HardyThriftHiveClient: +++++ enter +++++
    Jul 23 01:50:43 TRACE 2010535680 Driver::UnregisterConnection: +++++ enter +++++
    Jul 23 01:50:43 TRACE 2010535680 CInterface::SQLFreeHandle: +++++ enter +++++
    Jul 23 01:50:43 TRACE 2010535680 Driver::FreeEnvironment: +++++ enter +++++
    Jul 23 01:50:43 TRACE 2010535680 Driver::GetEnvironment: +++++ enter +++++
    Jul 23 01:50:43 TRACE 2010535680 Driver::UnregisterEnvironment: +++++ enter +++++
    [S1000][unixODBC][Hortonworks][HiveODBC] (22) Error from ThriftHiveClient: EAGAIN (timed out)
    [ISQL]ERROR: Could not SQLConnect
    Jul 23 01:50:43 TRACE 2010535680 HardyDriver::~HardyDriver: +++++ enter +++++

You must be logged in to reply to this topic.