Hello,

Using Metamodel, is it possible to build an INSERT statement that is paired with a SELECT subquery?  For example:

INSERT TABLE `us_south_es_etg`
SELECT
   `lon`,
   `lat`,
   `number`,
   `street`,
   `unit`,
   `city`,
   `district`,
   `region`,
   `postcode`,
   `id`,
   `hash`
FROM us_south;
Any suggestions would be greatly appreciated!
Tim
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB