Automic Workload Automation

 View Only
  • 1.  Hadoop HIVE Sql running

    Posted Mar 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 Mar 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 Jul 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 Jul 23, 2021 12:56 PM
    Hi Aurélien THIERY, what error message do you receive?

    Cheers,
    Alexander


  • 5.  RE: Hadoop HIVE Sql running

    Posted Jul 27, 2021 10:18 AM
    Edited by Aurélien THIERY Jul 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
    ------------------------------