Problem in creating the temporary tables the implicit way

[gamvi01]

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 ?

[shawkins]

Vineela,

You can also use the explicit CREATE LOCAL TEMPORARY TABLE described in the ddl section.  I believe this is a regression from https://issues.jboss.org/browse/TEIID-1177.  As long as you are using Teiid 7.1 or later you should be able to just issue:

insert into #temptable123 select sysid,name from demodata.user

and it will infer the appropirate column names.  I've logged https://issues.jboss.org/browse/TEIID-1872 to address this.

Thanks,

Steve

[gamvi01]

Thanks Hawkins. That works.