Forum: Managing VoltDB

Post: Create table t1 as select * from t2 union t2;

Create table t1 as select * from t2 union t2;
Benny
Jun 15, 2015
Hey Any workaround on this option?
xin
Jun 15, 2015
Benny,

I guess your syntax is not standard SQL. Could you explain more about your intention?

Thanks,
Xin
Benny
Jun 15, 2015
Of course:
HP vertica - example: https://my.vertica.com/docs/4.1/HTML/Master/1293.htm(old version but same in newer)
redShif same example as HPVertica works.
MySQL- example : create table test2 as select * from test1;
xin
Jun 15, 2015
I see.

We do not support this syntax, but you can do with two statements:
(1) create table... : http://docs.voltdb.com/UsingVoltDB/ddlref_createtable.php
(2) insert into select ... : http://docs.voltdb.com/UsingVoltDB/sqlref_insert.php

Please let us know if you have more questions.

Xin
Benny
Jun 16, 2015
Saw that already, And the insert into select is also restricted and limited.
But I'll manage. Ty.