Table Creatation Fail

omnisql> create table NOTIFICATION_New as select * NOTIFICATION;
Exception: Exception occurred: org.apache.calcite.runtime.CalciteContextException: At line 1, column 8: Unknown identifier ‘*’

do you want to try ‘select * FROM NOTIFICATION’ ?

select * FROM NOTIFICATION limit 10;

Received the output

My Mistake…

from is missing in above query…

Close this case