migration from Cloudera Hadoop to HDINSIGHT

Can anyone tell me. I have HQL scripts that I used to run on Cloudera using hive -f scriptname.hql Now I want to run on these scripts in HDINSIGHT(Hadoop cluster) but the hive command line is not available in HDINSIGHT. Can someone guide how I can do that.


  • Create an environment variable :

    export hivef="beeline -u 'jdbc:hive2://hn0-hdi-uk.witechmill.co.uk:10001/default;principal=hive/[email protected];auth-kerberos;transportMode=http' -n umerrkhan "

    witechmill is my clustername

    Then call the script by using the below

    $hivef scriptname.hql