Home Forums Hive / HCatalog [ODBC] HY001 Memory Allocation

Tagged: ,

This topic contains 12 replies, has 7 voices, and was last updated by  Sasha J 11 months, 4 weeks ago.

  • Creator
    Topic
  • #29137

    owen rumney
    Participant

    Hi

    I’ve installed the 32Bit ODBC driver from your site using the instructions from the same page and I’m getting a memory allocation error when I connect to the correct host.

    If I put a known wrong host it gives me a sensible error, however when the correct one is used I’m just getting the HY001 memory allocation and no further logs or events to work with.

    Is this a known issue that there is a workaround for? I need to connect HIVE using ODBC one way or anoher.

    Thanks,
    Owen

Viewing 12 replies - 1 through 12 (of 12 total)

You must be logged in to reply to this topic.

  • Author
    Replies
  • #30835

    Sasha J
    Moderator

    Good to know you got it working!
    Thank you!
    Sasha

    Collapse
    #30796

    Actualy I take that back. It actually worked!

    Collapse
    #30792

    Hi all
    I am getting the same error when using the ODBC driver
    “Attempting connection
    Failed to establish connection
    SQLSTATE: HY001[Hortonworks][ODBC] (10010) Memory allocation error: std::bad_alloc exception is caught.

    TESTS COMPLETED WITH ERROR.”

    I tried the steps mentioned by Robert and my beeline seems to be working fine, at least I can do show tables and they show up correctly. However, I still cannot make the ODBC driver work

    Any other ideas?

    Collapse
    #30088

    Robert
    Participant

    Hi Owen,
    There should a odbc client called beeline on the your hiveserver2 node. If you try using this client to connect, I wonder if you are able to connect. This will hopefully isolate if the issue is on the server or client side. Here are the instructions for the command line for beeline:

    http://docs.hortonworks.com/HDPDocuments/HDP1/HDP-1.3.1/bk_installing_manually_book/content/rpm-chap6-5.html

    which is for linux, but I believe should apply.

    Let me know if this helps.

    Regards,
    Robert

    Collapse
    #30011

    owen rumney
    Participant

    Hi Seth

    I thought I’d put a reply with all of the errors for each of the configurations I’d tried, seems it didnt’ save.

    I’ve tried your recent suggestion and when testing the DSN I gett the following error;

    SQLSTATE: HY000 [Hortonworks][Hardy](34) Error from Hive: connect() failed: errno = 10060

    I’ve checked the ports and 10001 is open as well as 10000 (which was what I though the documentation said was the default port!)

    Thanks anyway
    Owen

    Collapse
    #29753

    Seth Lyubich
    Keymaster

    Hi Owen,

    I just wanted to check if you were able to test with the Hive Server 2? Also, can you please try with 64 bit driver as recommended in documentation?

    You can use instructions below that describe how query data from Hive through Microsoft Excel. Instructions for SQL server should be the same:

    On the client machine where you will run Microsoft Excel:

    Download the Windows 64-bit Hortonworks ODBC driver from here.

    Execute the MSI and follow the instructions to install the ODBC driver.

    Set up an ODBC DSN using the following instructions:

    For 64-bit ODBC driver: Open the 64-bit ODBC Administrator pane.

    Navigate to the System DSN tab.

    Click Add, select the Hortonworks Hive driver and click Finish.

    Configure the driver using the following instructions:

    Under Host, provide the hostname of the cluster node that runs the Apache Hadoop hiveserver2 service.

    Under Port, enter the port of the Hive Server 2 service. By default, the Hive Server port is set to 10001.

    Choose Username for authentication, and enter ‘Hadoop’ as the user name.

    Click Ok.

    You can now use this ODBC DSN from Excel, to see tables in Hive and pull data from these tables.

    Also, some additional resources can be found here:

    http://docs.hortonworks.com/HDPDocuments/HDP1/HDP-Win-1.1.0/bk_dataintegration/content/ch_using-hive-2.html

    Please let us know if this is helpful.

    Thanks,
    Seth

    Collapse
    #29628

    owen rumney
    Participant

    Ultimately I want to connect to hive from MS SQL and bring in data that way.

    The error I am getting is thorough the ODBC administrator in Windows.

    Interesting that you mention tableau, that is on my critical path later on.

    I’ll give hive server 2 a go, but I think that had an error as well. Will update tomorrow.

    Thanks
    Owen

    Collapse
    #29615

    Carter Shanklin
    Participant

    Owen, I was corrected by one of my colleagues that it is in fact Hive Server 2 on HDP / Win.

    What app are you using to connect? It might require the 64 bit driver. I know Tableau is one exception that requires 32 bit but I’m not aware of any others.

    Collapse
    #29613

    owen rumney
    Participant

    Hi Carter

    I’m connecting to Hive Server 1 with no authenication and the default port of 10000.

    Specific error is;

    Driver Version: V1.2.0.1005
    Running connectivity tests…
    Attempting connection
    Failed to establish connection
    SQLSTATE: HY001[Hortonworks][ODBC] (10010) Memory allocation error: std::bad_alloc exception is caught.
    TESTS COMPLETED WITH ERROR.

    Thanks,
    Owen

    Collapse
    #29612

    Carter Shanklin
    Participant

    Owen what client are you connecting with?

    I believe HDP for Windows only has HiveServer1 at this stage, are you connecting as HS1 or HS2?

    Collapse
    #29502

    owen rumney
    Participant

    Hi Ted

    Thanks, I’d begun to lose hope. It’s a critical component in our design so if I can’t find a resolution it rather undermines out use of HDP for Windows.

    In the meantime, I’m trying to see if I can use a Sqoop export to get the same result.

    Owen

    Collapse
    #29432

    tedr
    Moderator

    Hi Owen,

    Sorry about the delay in getting back to you here. I was hoping that someone out there is forum land knew the answer, but I guess not. I’ll do some digging/asking around to hunt one down for you.

    Thanks,
    Ted.

    Collapse
Viewing 12 replies - 1 through 12 (of 12 total)