Table Creatation Fail

Follow

Sumit

• March 20, 2020 04:28

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

0

• 

  anon23740792

  • March 20, 2020 04:38

  do you want to try 'select * FROM NOTIFICATION' ?

  0

  Comment actions Permalink
• 

  Sumit

  • March 20, 2020 04:40

  select * FROM NOTIFICATION limit 10;

  Received the output

  0

  Comment actions Permalink
• 

  Sumit

  • March 20, 2020 04:47

  My Mistake.....

  from is missing in above query...

  Close this case

  0

  Comment actions Permalink

Please sign in to leave a comment.