Support Questions

Find answers, ask questions, and share your expertise
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

Export/Import databases using beeline

Expert Contributor

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".


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!!

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.