-
1. Re: teiid throwing teiid.api.exception.query.QueryResolverException
rareddy Jan 3, 2017 9:06 AM (in response to kulbhushanc)Your date needs to be in format "DD-Mon-RR HH24:MI:SS.FF" according TO_TIMESTAMP What is the user query you are submitting to Teiid? What is the version of Teiid?
-
2. Re: teiid throwing teiid.api.exception.query.QueryResolverException
kulbhushanc Jan 4, 2017 12:22 AM (in response to rareddy)Teiid version is 8.13 and the user query is given below:
insert into OraConnCDC.SYSTEM."SOURCE_DM"("SOURCE_SK","SOURCE_SHORT_DESC","SOURCE_LONG_DESC","SOURCE_HOME","DW_CREATE_DTM","UPDATE_BY","DW_UPDATE_DTM","CURRENT_IND") values ('4816','trade credit','Term Loans from Government Banks','Income Protection Insurance',TO_TIMESTAMP('16-DEC-16 09.53.31 AM'),'emotionallady_94@hotmail.com',TO_TIMESTAMP('13-DEC-16 09.00.31 AM'),'0');
-
3. Re: teiid throwing teiid.api.exception.query.QueryResolverException
rareddy Jan 4, 2017 9:39 AM (in response to kulbhushanc)These are time & date functions in Teiid Date_Time Functions · Teiid Documentation Anything else you use that Teiid supports will be native pushdown function supported by *only* that particular source. When you write queries knowing they are going to be using a pushdown function, you need to follow the semantics of usage of that function. I already pointed what is wrong with your usage in my previous comment. Fix the timestamp format resubmit and that will execute fine.
-
4. Re: teiid throwing teiid.api.exception.query.QueryResolverException
kulbhushanc Jan 10, 2017 8:05 AM (in response to rareddy)What do you mean by native pushdown function?
When I am firing this query using sql developer(oracle sql client) it working fine..
Are you suggesting to fire native query on a database using teiid?
You have suggested to use Teiid Date_Time Functions · Teiid Documentation which function will be appropriate for To_TIMESTAMP () function.
-
5. Re: teiid throwing teiid.api.exception.query.QueryResolverException
rhn-engineering-rareddy Jan 10, 2017 10:07 AM (in response to kulbhushanc)I am saying use "parsedate" function from the Teiid function library instead of using the Oracle specific to_timestamp function. Also follow the format rules for parsedate as to how your text based date string is represented.