2 Replies Latest reply on Dec 15, 2011 5:36 PM by Vineela Gampa

    Problem in creating the temporary tables the implicit way

    Vineela Gampa Novice

      Hi,

       

      Iam planning ot use temporary table creation for one of our usecase.Iam creating temptables as per mentioned in the document.

       

      http://docs.jboss.org/teiid/7.6.0.Final/reference/en-US/html/ddl_support.html#temp_tables

       

      Iam unable to create temp tables using the implicit way thats mentioned here. I have posted the statement and the error iam seeing. 

       

      Query issued : insert into #temptable123(sysid,name) select sysid,name from demodata.user

       

      Error : Cannot determine element or expression type

       

       

      Elapsed Time:  0 hr, 0 min, 0 sec, 0 ms.

       

       

      Is this the only way or there is some better way to create temp tables implicit way ?