Search code examples
hivetableau-apibusiness-intelligenceamazon-emrdata-lake

Multiple Tableau users connected to Hive LLAP

I’m hoping to allow interactive queries for many Tableau users with data accessed via Hive LLAP. So far results have disappointed.... should I expect this setup to work for me or should I use a different backend?

Solution

  • We had the same approach in our project but not very fruitful.

    2 options I would suggest:

    1. Double the nodes for LLAP server if possible.
    2. Use Snowflake database - Copy your hive tables to Snowflake and expose Snowflake to Tableau.

    Unfortunately, both the suggestion incur a good cost. :( but I am saying this from my experience!