HDP on Windows – Installation Forum

HDP 1.3 Windows and Excel PowerPivot

  • #33102
    Ted Malone
    Participant

    Has anyone here connected Excel 2013 PowerPivot to a Hive table in HDP 1.3 for Windows? Every time I try Excel throws a GPF and restarts.. (This happens on every instance of Excel I’ve tried)

    I’m using the 64-bit ODBC driver against hiveserver2. It took quite a bit of monkeying around to even get the driver to connect, so I’m wondering what I’ve done incorrectly.

    Thanks.

to create new topics or reply. | New User Registration

  • Author
    Replies
  • #33387
    Seth Lyubich
    Moderator

    Hi Ted,

    Can you please see following post and let me know if this is useful?

    http://hortonworks.com/community/forums/topic/how-to-configure-hive-server-2-for-odbc-connection-in-hdp-1-3-on-windows/

    Thanks,
    Seth

    #33389
    Ted Malone
    Participant

    Hi Seth,

    Thank you for the response. I have the hiverserver2 instance configured to use thrift and was able to get the driver to connect. It actually works fine with Excel 2010, but even a simple query in Excel 2013 causes Excel to restart.

    #33690
    Seth Lyubich
    Moderator

    Hi Ted,

    Can you please check to make sure that you configured correct Hive driver version in ODBC settings? Also, can you please check Event log for any errors?

    Thanks,
    Seth

    #33816
    Ted Malone
    Participant

    Thanks for the reply Seth. I do have everything configured per the post, and the driver does work in Excel 2010 as well as with Revolution R studio (via the RODBC library), but it will NOT work in Excel 2013. Any attempt to query data in Excel 2013 results in Excel crashing, and this is true from multiple machines. Not sure what the issue is.

    #35052
    Seth Lyubich
    Moderator

    Hi Ted,

    Can you please let us know the steps you took so that I can try to reproduce the issue?

    Thanks,
    Seth

    #35245
    Ted Malone
    Participant

    Hi, my steps were:

    1) Install and configure HDP 1.3 on a multi-node (in my case the cluster is 8 nodes total) cluster
    2) Configure hiveserver2 to use thrift per the post on the forums here. (I also changed the port to 10002)
    3) Create a simple hive external table using a small text data set
    4) Install and configure a client workstation with Office Pro 2013 (Enable PowerPivot in Excel)
    5) Download and install the HDP ODBC driver
    6) Configure a System DSN that points to hiveserver2 on port 10002
    7) Attempt to connect from PowerPivot to the ODBC connection. You can connect and list tables, but as soon as you attempt to pull data from the table Excel will “unexpectedly” crash and restart
    8) Note that attempting to connect from anything else, such as Revolution Analytics (using RODBC) or even Excel 2010 works just fine… Also note that Excel 2013 fails from ANY workstation you attempt to connect to, including a workstation where Excel 2013 works to connect to the HDInsight Service on Azure…..

You must be to reply to this topic. | Create Account

Support from the Experts

A HDP Support Subscription connects you experts with deep experience running Apache Hadoop in production, at-scale on the most demanding workloads.

Enterprise Support »

Become HDP Certified

Real world training designed by the core architects of Hadoop. Scenario-based training courses are available in-classroom or online from anywhere in the world

Training »

Hortonworks Data Platform
The Hortonworks Data Platform is a 100% open source distribution of Apache Hadoop that is truly enterprise grade having been built, tested and hardened with enterprise rigor.
Get started with Sandbox
Hortonworks Sandbox is a self-contained virtual machine with Apache Hadoop pre-configured alongside a set of hands-on, step-by-step Hadoop tutorials.
Modern Data Architecture
Tackle the challenges of big data. Hadoop integrates with existing EDW, RDBMS and MPP systems to deliver lower cost, higher capacity infrastructure.