Forum Discussion

josehcr's avatar
josehcr
Frequent Visitor
6 years ago

Use HDP Hive LLAP from Power BI using Direct Query

Is there a way to use HDP (version 3.1.0) Hive LLAP from Spark Connector?

 

I already got access using: 1) Hive ODBC Driver with ODBC connector; 2) Hive Thrift Server with Spark connector. But both do not support Direct Query.

 

I know it's possible to use HDInsight Interactive Query connector, but in my case I want to access my own HDP cluster using Direct Query with Spark connector or other connector if possible. 

 

 

Need Help

4 Replies

  • v-xicai's avatar
    v-xicai
    Community Support
    6 years ago

    Hi josehcr ,

     

    You can refer to the similar case power bi spark directquery support .

     

    Best Regards,

    Amy

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • josehcr's avatar
      josehcr
      Frequent Visitor
      6 years ago

      Dear v-xicai  , thanks for the response.

       

      The link in the last post mentions a case of HDP access using Spark with Direct Query. This already worked.

       

      What I need is to know how to access HDP with Direct Query using LLAP, either with Spark or otherwise.

       

      Hive LLAP makes queries much faster than accessing the traditional way.

  • Farrukh's avatar
    Farrukh
    New Member
    5 years ago

    Hi josehcr 

    Were you able to connect using hivellap connector ? if yes could you please guide me as well. Thanks

     

    Regards,

     

    Farrukh