Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How to load data into Kudu table from kudu table in another database?

How to load data into Kudu table from kudu table in another database?

Explorer

Is it possible to load a kudu table with data from kudu table in another database? Both tables have same structure. It it possible to do a cross-db import?

 

3 REPLIES 3

Re: How to load data into Kudu table from kudu table in another database?

Contributor

Hi Rams,

 

As of the latest version, Kudu itself doesn't have a concept of database. Are you using Kudu with Impala? If so, you can create the second table as external in Impala and use the same Kudu table under the hood.

 

Best,

Hao

Highlighted

Re: How to load data into Kudu table from kudu table in another database?

Explorer

Hi Hao,

The source "database" is on another cluster and the destination on a different cluster. can I run something like

 

insert into cluster2DB.table select * from cluster1DB.table ?

Re: How to load data into Kudu table from kudu table in another database?

Contributor

Hi Rams,

 

I don't think you can directly import data from another cluster yet with Kudu Impala integration. One way is to export the data in Parquet files and then import the data into the other cluster.