Automic Workload Automation

Expand all | Collapse all

Hadoop HIVE Sql running

Jump to Best Answer
  • 1.  Hadoop HIVE Sql running

    Posted 03-27-2020 10:36 AM
    Can we run SQL on hive with the hadoop agent?


  • 2.  RE: Hadoop HIVE Sql running
    Best Answer

    Broadcom Employee
    Posted 03-30-2020 03:16 PM
    Yes, you can - the Hadoop Agent uses WebHCAT to connect.

    If that is not an option (for example Cloudera), then you can use a Database Agent and the Hive JDBC connector.

    DK


  • 3.  RE: Hadoop HIVE Sql running

    Posted 07-20-2021 03:26 PM
    Hi Dave!
    Can you explain with more details please?
    I configured hadoopconnection object and hive job but i always have an error. Is there an other solution?
    Thank you.
    Aurélien

    ------------------------------
    PACIFICA
    ------------------------------



  • 4.  RE: Hadoop HIVE Sql running

    Broadcom Employee
    Posted 07-23-2021 12:56 PM
    Hi Aurélien THIERY, what error message do you receive?

    Cheers,
    Alexander


  • 5.  RE: Hadoop HIVE Sql running

    Posted 07-27-2021 10:18 AM
    Edited by Aurélien THIERY 07-27-2021 10:19 AM
    Hi @Alexander Trenker,
    I want only to connect Workload Automation to hive server. Until now I configured ODBC Driver with this parameters:


    In AWI I configured hadoop connection:

    And hive job:​


    But when i click on folder in "Hive Script" parameter i have this error:


    Aurélien

    ------------------------------
    PACIFICA
    ------------------------------