Mapd loading table into db


#1

i have loaded a table in wrong db i have to load that same table into in another db
how to move a table from one db to another db
is there any query?


#2

Hi @nagulan,

The SQL command line does not support referring to a table in another database using

database.table

construct. So you are left with the following options:

  1. Reimport the database from original source file.
  2. Programmatically (Java/Python) open a cursor to each database and read the buffer from source table and copy it to the destination table.

Bulk import with option 1 will be more performant.
Regards,
Veda