[JBoss JIRA] (TEIID-3645) Upgrade of Amazon aws sdk version
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3645?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-3645.
---------------------------------
> Upgrade of Amazon aws sdk version
> ---------------------------------
>
> Key: TEIID-3645
> URL: https://issues.jboss.org/browse/TEIID-3645
> Project: Teiid
> Issue Type: Component Upgrade
> Components: Misc. Connectors
> Affects Versions: 8.11.2
> Environment: teiid 8.11.2
> windows 8.1
> java 8
> Reporter: avinash misra
> Assignee: Steven Hawkins
> Fix For: 8.12, 8.11.3
>
>
> I was working on dynamodb connector with latest dynamodb sdk.
> This sdk uses aws-java-sdk-core version 1.10.11 but teiid uses aws-java-sdk 1.5.7. internally for simple db connector.
> Could you please upgrade the aws sdk version to latest?
>
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 3 months
[JBoss JIRA] (TEIID-3438) Null value returned from BlobImpl getBytes
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3438?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-3438.
---------------------------------
> Null value returned from BlobImpl getBytes
> ------------------------------------------
>
> Key: TEIID-3438
> URL: https://issues.jboss.org/browse/TEIID-3438
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 7.7
> Reporter: Kylin Soong
> Assignee: Steven Hawkins
> Fix For: 8.7.1.6_2, 8.10.1, 8.11
>
> Attachments: TEIID-3438.zip
>
>
> If translator retrieveValue return a empty Blob, the engine will throw NPE as below
> Caused by: java.lang.NullPointerException
> at javax.sql.rowset.serial.SerialBlob.<init>(SerialBlob.java:100)
> at org.teiid.common.buffer.LobManager.persistLob(LobManager.java:226)
> at org.teiid.common.buffer.LobManager.updateReferences(LobManager.java:141)
> at org.teiid.common.buffer.TupleBuffer.addTupleBatch(TupleBuffer.java:203)
> at org.teiid.query.processor.BatchCollector.flushBatchDirect(BatchCollector.java:229)
> at org.teiid.dqp.internal.process.RequestWorkItem$1.flushBatchDirect(RequestWorkItem.java:653)
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 3 months
[JBoss JIRA] (TEIID-3627) Infinispan-dsl-cache translator: comparison operators(GE, LE) problem with string
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3627?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-3627.
---------------------------------
> Infinispan-dsl-cache translator: comparison operators(GE,LE) problem with string
> --------------------------------------------------------------------------------
>
> Key: TEIID-3627
> URL: https://issues.jboss.org/browse/TEIID-3627
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.7.1.6_2
> Reporter: Jan Stastny
> Assignee: Van Halbert
> Fix For: 8.7.1.6_2, 8.12
>
>
> Comparison of string values provides wrong results for GE and LE operators. I provide example queries, notice the number of rows returned by the queries.
> For query: {code:sql}SELECT BQT1.SmallA.StringNum FROM BQT1.SmallA WHERE BQT1.SmallA.StringNum <= -22 ORDER BY StringNum{code}
> * Process Tree:
> {code:plain}
> LimitNode(0) output=[g_0.stringNum] limit 100
> AccessNode(1) output=[g_0.stringNum] SELECT g_0.stringNum FROM SmallAs.smallARemotecache AS g_0 WHERE g_0.stringNum <= '-22' ORDER BY g_0.stringNum
> {code}
> * SRC CMD: {code:sql}SELECT g_0.stringNum FROM SmallAs.smallARemotecache AS g_0 WHERE g_0.stringNum <= '-22' ORDER BY g_0.stringNum{code}
> * result 0 rows
> But for query: {code:sql}SELECT BQT1.SmallA.StringNum FROM BQT1.SmallA WHERE BQT1.SmallA.StringNum < -22 ORDER BY StringNum{code}
> * Process Tree:
> {code:plain}ProjectNode(0) output=[c.stringNum AS StringNum] [c.stringNum AS StringNum]
> LimitNode(1) output=[c.stringNum] limit 100
> SortNode(2) output=[c.stringNum] [SORT] [c.stringNum]
> SelectNode(3) output=[c.stringNum] c.stringNum < '-22'
> AccessNode(4) output=[c.stringNum] SELECT g_0.stringNum FROM SmallAs.smallARemotecache AS g_0{code}
> * SRC CMD: {code:sql}SELECT g_0.stringNum FROM SmallAs.smallARemotecache AS g_0{code}
> * result 14 rows
> And query: {code:sql}SELECT BQT1.SmallA.StringNum FROM BQT1.SmallA WHERE BQT1.SmallA.StringNum = -22 ORDER BY StringNum{code}
> * Process Tree:
> {code:plain}LimitNode(0) output=[c.stringNum AS StringNum] limit 100
> AccessNode(1) output=[c.stringNum AS StringNum] SELECT g_0.stringNum FROM SmallAs.smallARemotecache AS g_0 WHERE g_0.stringNum = '-22' ORDER BY g_0.stringNum{code}
> * SRC CMD: {code:sql}SELECT g_0.stringNum FROM SmallAs.smallARemotecache AS g_0 WHERE g_0.stringNum = '-22' ORDER BY g_0.stringNum{code}
> * result 1 row
> The first query should then return 15 rows instead of 0. Also the queries differ in a way they are processed, the first one is pushed down to infinispan, the other two are processed by teiid, which is probably a regression originally tracked here: TEIID-3424
> The same cause introduces problems with similar queries:
> {code:sql}Select IntKey, StringKey From BQT1.SmallA WHERE NOT(StringKey > 10 AND IntKey < 47) ORDER BY IntKey{code}
> Which is processed as:
> * Process Tree:
> {code:plain}LimitNode(0) output=[c.intKey AS IntKey, c.stringKey AS StringKey] limit 100
> AccessNode(1) output=[c.intKey AS IntKey, c.stringKey AS StringKey] SELECT g_0.intKey, g_0.stringKey FROM SmallAs.smallARemotecache AS g_0 WHERE (g_0.stringKey <= '10') OR (g_0.intKey >= 47) ORDER BY g_0.intKey{code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 3 months
[JBoss JIRA] (TEIID-3424) infinispan dsl cache translator has disabled capabilities for NE, GT, LT
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3424?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-3424.
---------------------------------
> infinispan dsl cache translator has disabled capabilities for NE,GT, LT
> ------------------------------------------------------------------------
>
> Key: TEIID-3424
> URL: https://issues.jboss.org/browse/TEIID-3424
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.7.1.6_2, 8.11
> Reporter: Van Halbert
> Assignee: Steven Hawkins
> Fix For: 8.7.1.6_2, 8.11
>
>
> Documentation states that Infinispan DSL cache translator has this capabilities: Compare Criteria - EQ, NE, LT, GT, LE, GE.
> However capabilities for LT, GT and NE are disabled.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 3 months
[JBoss JIRA] (TEIID-3187) Error Casting TimeStamp to Date using Impala
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3187?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-3187.
---------------------------------
> Error Casting TimeStamp to Date using Impala
> --------------------------------------------
>
> Key: TEIID-3187
> URL: https://issues.jboss.org/browse/TEIID-3187
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.7.1
> Reporter: Van Halbert
> Assignee: Steven Hawkins
> Fix For: 8.7.1, 8.9.1, 8.10
>
>
> With ER3 getting [1] for the conversion of a timestamp to a Date:
> convert(Source.smalla.DATEVALUE, date) AS DateValue
> [1]
> org.teiid.jdbc.TeiidSQLException: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 Source: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT DISTINCT cast(g_0.DATEVALUE AS date) AS c_0 FROM smalla g_0 ORDER BY c_0]
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135)
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71)
> at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:667)
> at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:63)
> at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:515)
> at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:135)
> at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:40)
> at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:79)
> at org.teiid.net.socket.SocketServerInstanceImpl.receivedMessage(SocketServerInstanceImpl.java:264)
> at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:302)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:98)
> at com.sun.proxy.$Proxy1.read(Unknown Source)
> at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:401)
> at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:524)
> at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:393)
> at org.teiid.jdbc.StatementImpl.executeQuery(StatementImpl.java:327)
> at JDBCClient.execute(JDBCClient.java:80)
> at JDBCClient.main(JDBCClient.java:46)
> Caused by: org.teiid.core.TeiidProcessingException: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 Source: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT DISTINCT cast(g_0.DATEVALUE AS date) AS c_0 FROM smalla g_0 ORDER BY c_0]
> at org.teiid.dqp.internal.process.DataTierTupleSource.exceptionOccurred(DataTierTupleSource.java:381)
> at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:154)
> at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:369)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278)
> at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136)
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151)
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141)
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:444)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:326)
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: org.teiid.core.TeiidException: 0 Remote org.teiid.translator.jdbc.JDBCExecutionException: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT DISTINCT cast(g_0.DATEVALUE AS date) AS c_0 FROM smalla g_0 ORDER BY c_0]
> at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:131)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:325)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:298)
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110)
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:107)
> at java.util.concurrent.FutureTask.run(FutureTask.java:262)
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58)
> ... 6 more
> Caused by: java.sql.SQLException: Remote java.sql.SQLException: AnalysisException: Invalid type cast of g_0.DATEVALUE from TIMESTAMP to DATE
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 3 months
[JBoss JIRA] (TEIID-3652) Teiid could push some outer joins to the source database, but does not
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3652?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-3652.
---------------------------------
> Teiid could push some outer joins to the source database, but does not
> ----------------------------------------------------------------------
>
> Key: TEIID-3652
> URL: https://issues.jboss.org/browse/TEIID-3652
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.11.2
> Reporter: Mike Higgins
> Assignee: Steven Hawkins
> Fix For: 8.12
>
>
> In the following SQL:
> select *
> from s1.t1 t1
> left outer join s2.t2 t2 on (t1.id = t2.id)
> left outer join s2.t3 t3 on (t2.id2 = t3.id2)
> where t1.name = 'x'
> option makedep s2.t2
>
> where t1 is in one database and t2 and t3 are in a different database,
> Teiid could push the second left outer join to the source database. Currently, it does not and performs the join itself. Some outer joins cannot be pushed, of course, but this one and others like it could be.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 3 months
[JBoss JIRA] (TEIID-3699) execute immediate only checks immediate parent scope
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3699?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-3699.
---------------------------------
> execute immediate only checks immediate parent scope
> ----------------------------------------------------
>
> Key: TEIID-3699
> URL: https://issues.jboss.org/browse/TEIID-3699
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.7
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 8.12, 8.11.4
>
>
> A procedure such as:
> {code}
> begin
> create local temporary table t1 (e1 string);
> loop on (select 1 as a union all select 2) as c
> begin
> execute immediate 'select c.a' as e1 string into t1;
> end
> select * from t1;
> end
> {code}
> should return two rows, but instead returns nothing because the execute immediate statement doesn't see the surrounding t1 temp table.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 3 months
[JBoss JIRA] (TEIID-3681) Subquery field added in wrong place in generated JDBC SQL
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3681?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-3681.
---------------------------------
> Subquery field added in wrong place in generated JDBC SQL
> ---------------------------------------------------------
>
> Key: TEIID-3681
> URL: https://issues.jboss.org/browse/TEIID-3681
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.10
> Reporter: Mark Tawk
> Assignee: Steven Hawkins
> Fix For: 8.12
>
>
> I'm using Teiid 8.11.3 and h2 translator:
> I have a query that contains a subquery field in the select statement and a join over another subquery. In the JDBC query executed, i found that the subquery field was added into the subquery join which is giving an error in execution.
> Here is my query:
> SELECT
> "Profile_fqS_030915"."CID" as "Profile_fqS_030915_CID"
> ,
> (
> SELECT
> MAX("Trx_fil_030915_sub"."TransactionDate") as "Trx_fil_030915_TransactionDa"
> FROM
> "implify_data_BanksModel"."implify_data_Banks"."Trx_fil_030915"
> "Trx_fil_030915_sub"
> WHERE
> ("Profile_fqS_030915"."CID" = "Trx_fil_030915_sub"."CID") ) as "SubQuery Trx" ,
> TIMESTAMPDIFF(SQL_TSI_DAY, "Trx"."TransactionDate", PARSETIMESTAMP( '2015-04-02 00:00:00.000', 'yyyy-MM-dd HH:mm:ss.SSS' )) as "CalculatedField2"
> ,
> "Trxmo3UMEoebyXTVyguosX_Sub"."Trxmo3U_CalculatedField12" as
> "Trxmo3U_CalculatedField1"
> ,
> "Trxmo3UMEoebyXTVyguosX_Sub"."Trxmo3U_CalculatedField3" as
> "Trxmo3U_CalculatedField"
> ,
> "Trxmo3UMEoebyXTVyguosX_Sub"."Trxmo3U_CalculatedField11" as
> "Trxmo3U_CalculatedField11"
> ,
> "Trxmo3UMEoebyXTVyguosX_Sub"."Trxmo3U_CalculatedField2" as
> "Trxmo3U_CalculatedField2"
> ,
> "Trxmo3UMEoebyXTVyguosX_Sub"."Trxmo3U_CalculatedField1" as
> "Trxmo3U_CalculatedField12"
> ,
> "Trxmo3UMEoebyXTVyguosX_Sub"."Trxmo3U_CalculatedField" as
> "Trxmo3U_CalculatedField3"
> FROM
> "implify_data_BanksModel"."implify_data_Banks"."Profile_fqS_030915"
> "Profile_fqS_030915"
> LEFT JOIN
> "implify_data_BanksModel"."implify_data_Banks"."Trx_fil_030915" "Trx"
> ON
> "Profile_fqS_030915"."CID" = "Trx"."CID"
> LEFT JOIN
> (
> SELECT
> "Trxmo3U_sub"."Trx_fil_030915_CID" as "Trxmo3U_Trx_fil_030915_CID"
> ,
> MIN("Trxmo3U_sub"."CalculatedField1") as "Trxmo3U_CalculatedField1"
> ,
> MIN("Trxmo3U_sub"."CalculatedField") as "Trxmo3U_CalculatedField"
> ,
> MAX("Trxmo3U_sub"."CalculatedField") as "Trxmo3U_CalculatedField2"
> ,
> MAX("Trxmo3U_sub"."CalculatedField1") as "Trxmo3U_CalculatedField11"
> ,
> AVG(1.0 * "Trxmo3U_sub"."CalculatedField") as "Trxmo3U_CalculatedField3"
> ,
> AVG(1.0 * "Trxmo3U_sub"."CalculatedField1") as "Trxmo3U_CalculatedField12"
> FROM
> "Domain1BusinessModel"."Trxmo3U" "Trxmo3U_sub"
> WHERE
> ( ( ("Trxmo3U_sub"."Trx_fil_030915_Channel" IN ('ATM'
> ,
> 'Branch'
> ,
> 'P.O.S.') ) ) )
> GROUP BY
> "Trxmo3U_sub"."Trx_fil_030915_CID") "Trxmo3UMEoebyXTVyguosX_Sub" ON
> "Profile_fqS_030915"."CID" =
> "Trxmo3UMEoebyXTVyguosX_Sub"."Trxmo3U_Trx_fil_030915_CID" LIMIT 0, 10
> Here is the executed JDBC query:
> SELECT
> g_0."CID" AS c_0,
> (
> SELECT
> MAX(g_4."TransactionDate")
> FROM
> "implify_data_Banks"."Trx_fil_030915" AS g_4
> WHERE
> g_4."CID" = g_0."CID") AS c_1 ,
> g_1."TransactionDate" AS c_2,
> v_0.c_2 AS c_3,
> v_0.c_3 AS c_4,
> v_0.c_4 AS c_5,
> v_0.c_5 AS c_6,
> v_0.c_6 AS c_7,
> v_0.c_7 AS c_8
> FROM
> ("implify_data_Banks"."Profile_fqS_030915" AS g_0
> LEFT OUTER JOIN
> "implify_data_Banks"."Trx_fil_030915" AS g_1
> ON
> g_0."CID" = g_1."CID")
> LEFT OUTER JOIN
> (
> SELECT
> g_2."Trx_fil_030915_CID" AS c_0
> ,
> *_(
> SELECT
> MAX(g_3."TransactionDate")
> FROM
> "implify_data_Banks"."Trx_fil_030915" AS g_3
> WHERE
> g_3."CID" = g_0."CID") AS c_1_* ,
> AVG((1.0 * cast(g_2."CalculatedField1" AS decimal))) AS c_2 ,
> AVG((1.0 * g_2."CalculatedField")) AS c_3 ,
> MAX(g_2."CalculatedField1") AS c_4 ,
> MAX(g_2."CalculatedField") AS c_5 ,
> MIN(g_2."CalculatedField1") AS c_6 ,
> MIN(g_2."CalculatedField") AS c_7
> FROM
> "implify_data_Banks"."Trxmo3U" AS g_2
> WHERE
> g_2."Trx_fil_030915_Channel" IN ('ATM', 'Branch', 'P.O.S.')
> GROUP BY
> g_2."Trx_fil_030915_CID") AS v_0 ON g_0."CID" = v_0.c_0 LIMIT 10
> Error:
> Please try again! TEIID30504 implify_data_BanksModelVDB: 42122 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: []
> Note that if i remove TIMESTAMPDIFF from the main query, the query executes without a problem and the subquery field is no longer added in the join subquery
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 3 months