An HDInsight cluster created only after 2020-10-15 supports SQL Export/Import for the Hive default metastore DB by using sqlpackage. Install sqlpackage to the cluster.

I would like to know how I can import data from MongoDB (documents) to Hive or Hbase ? Best option would be using Mongo hadoop connector with hive external tables but you need to built that jar ...

This paper proposes how to conduct the specific job performance optimization of Hive and Spark SQL, and make a comparison of them at the same time. First, we compare Hive and Spark SQL by ten SQL ...