I have some database in My Hiveserver2 which I need to export to hdfs and than import them to an other cluster (other hiveserver).
I see this answer but it's csv form. I would like also know if there's a such command "export $database" and "import $database".
I don't think there is an option to export database.
Hope this helps you.
Hi @yassine sihi
One way which I could think of is to import the database from one cluster to the other cluster using sqoop, which is possible at all means. Converting into csv and then again performing the work around is a time consuming process.
Hope it helps!!