Reply
Explorer
Posts: 10
Registered: ‎04-12-2018

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

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?

 

Highlighted
Cloudera Employee
Posts: 30
Registered: ‎02-22-2017

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

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

Explorer
Posts: 10
Registered: ‎04-12-2018

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

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 ?

Cloudera Employee
Posts: 30
Registered: ‎02-22-2017

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

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.