[JBoss JIRA] (TEIID-3055) Querying JDG local cache using greater than value cause exception
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3055?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-3055.
-----------------------------------
Resolution: Done
Applied Van's patch
> Querying JDG local cache using greater than value cause exception
> -----------------------------------------------------------------
>
> Key: TEIID-3055
> URL: https://issues.jboss.org/browse/TEIID-3055
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Misc. Connectors
> Affects Versions: 8.7.1, 8.9
> Reporter: Van Halbert
> Assignee: Steven Hawkins
> Fix For: 8.7.1, 8.9
>
>
> Issuing query: select nss, valor_inicial, valor_final from CacheView.Resumen where valor_inicial > 950.0
> produces the following in the query plan:
> USER COMMAND:
> SELECT nss, valor_inicial, valor_final FROM CacheView.Resumen WHERE nss > '950.0'
> request=/1MuNPfoG76j.0.0.5: org.hibernate.search.SearchException: Cannot create numeric range query for field saldo.valorInicial, since values are not numeric (int,long, short or double)
> at org.hibernate.search.bridge.util.impl.NumericFieldUtils.createNumericRangeQuery(NumericFieldUtils.java:69)
> at org.hibernate.search.query.dsl.impl.ConnectedMultiFieldsRangeQueryBuilder.createQuery(ConnectedMultiFieldsRangeQueryBuilder.java:107)
> at org.hibernate.search.query.dsl.impl.ConnectedMultiFieldsRangeQueryBuilder.createQuery(ConnectedMultiFieldsRangeQueryBuilder.java:83)
> at org.teiid.translator.object.infinispan.LuceneSearch.createRangeAboveQuery(LuceneSearch.java:349)
> at org.teiid.translator.object.infinispan.LuceneSearch.visit(LuceneSearch.java:217)
> at org.teiid.translator.object.infinispan.LuceneSearch.buildQueryFromWhereClause(LuceneSearch.java:145)
> at org.teiid.translator.object.infinispan.LuceneSearch.performSearch(LuceneSearch.java:66)
> at org.teiid.translator.object.infinispan.InfinispanExecutionFactory.search(InfinispanExecutionFactory.java:119)
> at org.teiid.translator.object.ObjectExecution.execute(ObjectExecution.java:102)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:312) [te
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
9 years, 9 months
[JBoss JIRA] (TEIID-3057) Kerberos ODBC connection on Teiid 8.8.0
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-3057?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-3057:
-------------------------------------
ODBC was one weak spot, I never tested with recent changes. Cristiano, can you tell what configuration you did you enable the kerberoes with ODBC driver?
> Kerberos ODBC connection on Teiid 8.8.0
> ---------------------------------------
>
> Key: TEIID-3057
> URL: https://issues.jboss.org/browse/TEIID-3057
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Affects Versions: 8.8
> Environment: Teiid 8.8.0
> EAP 6.1.1
> Reporter: Cristiano Nicolai
> Assignee: Steven Hawkins
> Priority: Blocker
>
> After upgrading from version 8.7.0.Final to version 8.8.0.Final connections via ODBC using Kerberos/GSS stopped working.
> When I try to connect with the new version, on the server I get the following error:
>
> 12:24:31,755 ERROR [org.teiid.ODBC] (New I/O worker #2) TEIID40015 Unexpected error occurred: java.lang.NullPointerException
> at java.util.Hashtable.put(Hashtable.java:514) [rt.jar:1.7.0_55]
> at org.teiid.odbc.ODBCServerRemoteImpl.logon(ODBCServerRemoteImpl.java:244) [teiid-runtime-8.8.0.Final.jar:8.8.0.Final]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_55]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_55]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_55]
> at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_55]
> at org.teiid.transport.ODBCClientInstance.processMessage(ODBCClientInstance.java:127) [teiid-runtime-8.8.0.Final.jar:8.8.0.Final]
> at org.teiid.transport.ODBCClientInstance.receivedMessage(ODBCClientInstance.java:116) [teiid-runtime-8.8.0.Final.jar:8.8.0.Final]
> at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:211) [teiid-runtime-8.8.0.Final.jar:8.8.0.Final]
>
> From the client I get the following message: psql: duplicate GSS authentication request
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
9 years, 9 months
[JBoss JIRA] (TEIID-3057) Kerberos ODBC connection on Teiid 8.8.0
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3057?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3057:
---------------------------------------
I'm not failure enough to say for sure. I think that it would be part of the configuration of the underlying kerberos service.
> Kerberos ODBC connection on Teiid 8.8.0
> ---------------------------------------
>
> Key: TEIID-3057
> URL: https://issues.jboss.org/browse/TEIID-3057
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Affects Versions: 8.8
> Environment: Teiid 8.8.0
> EAP 6.1.1
> Reporter: Cristiano Nicolai
> Assignee: Steven Hawkins
> Priority: Blocker
>
> After upgrading from version 8.7.0.Final to version 8.8.0.Final connections via ODBC using Kerberos/GSS stopped working.
> When I try to connect with the new version, on the server I get the following error:
>
> 12:24:31,755 ERROR [org.teiid.ODBC] (New I/O worker #2) TEIID40015 Unexpected error occurred: java.lang.NullPointerException
> at java.util.Hashtable.put(Hashtable.java:514) [rt.jar:1.7.0_55]
> at org.teiid.odbc.ODBCServerRemoteImpl.logon(ODBCServerRemoteImpl.java:244) [teiid-runtime-8.8.0.Final.jar:8.8.0.Final]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_55]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_55]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_55]
> at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_55]
> at org.teiid.transport.ODBCClientInstance.processMessage(ODBCClientInstance.java:127) [teiid-runtime-8.8.0.Final.jar:8.8.0.Final]
> at org.teiid.transport.ODBCClientInstance.receivedMessage(ODBCClientInstance.java:116) [teiid-runtime-8.8.0.Final.jar:8.8.0.Final]
> at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:211) [teiid-runtime-8.8.0.Final.jar:8.8.0.Final]
>
> From the client I get the following message: psql: duplicate GSS authentication request
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
9 years, 9 months
[JBoss JIRA] (TEIID-3057) Kerberos ODBC connection on Teiid 8.8.0
by Cristiano Nicolai (JIRA)
[ https://issues.jboss.org/browse/TEIID-3057?page=com.atlassian.jira.plugin... ]
Cristiano Nicolai commented on TEIID-3057:
------------------------------------------
How exactly I do that? Some property on login module?
> Kerberos ODBC connection on Teiid 8.8.0
> ---------------------------------------
>
> Key: TEIID-3057
> URL: https://issues.jboss.org/browse/TEIID-3057
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Affects Versions: 8.8
> Environment: Teiid 8.8.0
> EAP 6.1.1
> Reporter: Cristiano Nicolai
> Assignee: Steven Hawkins
> Priority: Blocker
>
> After upgrading from version 8.7.0.Final to version 8.8.0.Final connections via ODBC using Kerberos/GSS stopped working.
> When I try to connect with the new version, on the server I get the following error:
>
> 12:24:31,755 ERROR [org.teiid.ODBC] (New I/O worker #2) TEIID40015 Unexpected error occurred: java.lang.NullPointerException
> at java.util.Hashtable.put(Hashtable.java:514) [rt.jar:1.7.0_55]
> at org.teiid.odbc.ODBCServerRemoteImpl.logon(ODBCServerRemoteImpl.java:244) [teiid-runtime-8.8.0.Final.jar:8.8.0.Final]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_55]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_55]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_55]
> at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_55]
> at org.teiid.transport.ODBCClientInstance.processMessage(ODBCClientInstance.java:127) [teiid-runtime-8.8.0.Final.jar:8.8.0.Final]
> at org.teiid.transport.ODBCClientInstance.receivedMessage(ODBCClientInstance.java:116) [teiid-runtime-8.8.0.Final.jar:8.8.0.Final]
> at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:211) [teiid-runtime-8.8.0.Final.jar:8.8.0.Final]
>
> From the client I get the following message: psql: duplicate GSS authentication request
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
9 years, 9 months
[JBoss JIRA] (TEIID-3057) Kerberos ODBC connection on Teiid 8.8.0
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3057?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3057:
---------------------------------------
Can you turn credential delegation on as a workaround?
Also it looks like there may be a bit of a protocol issue in the exception case as we'd expect something more meaningful than that message from psql.
> Kerberos ODBC connection on Teiid 8.8.0
> ---------------------------------------
>
> Key: TEIID-3057
> URL: https://issues.jboss.org/browse/TEIID-3057
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Affects Versions: 8.8
> Environment: Teiid 8.8.0
> EAP 6.1.1
> Reporter: Cristiano Nicolai
> Assignee: Steven Hawkins
> Priority: Blocker
>
> After upgrading from version 8.7.0.Final to version 8.8.0.Final connections via ODBC using Kerberos/GSS stopped working.
> When I try to connect with the new version, on the server I get the following error:
>
> 12:24:31,755 ERROR [org.teiid.ODBC] (New I/O worker #2) TEIID40015 Unexpected error occurred: java.lang.NullPointerException
> at java.util.Hashtable.put(Hashtable.java:514) [rt.jar:1.7.0_55]
> at org.teiid.odbc.ODBCServerRemoteImpl.logon(ODBCServerRemoteImpl.java:244) [teiid-runtime-8.8.0.Final.jar:8.8.0.Final]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_55]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_55]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_55]
> at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_55]
> at org.teiid.transport.ODBCClientInstance.processMessage(ODBCClientInstance.java:127) [teiid-runtime-8.8.0.Final.jar:8.8.0.Final]
> at org.teiid.transport.ODBCClientInstance.receivedMessage(ODBCClientInstance.java:116) [teiid-runtime-8.8.0.Final.jar:8.8.0.Final]
> at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:211) [teiid-runtime-8.8.0.Final.jar:8.8.0.Final]
>
> From the client I get the following message: psql: duplicate GSS authentication request
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
9 years, 9 months
[JBoss JIRA] (TEIID-3057) Kerberos ODBC connection on Teiid 8.8.0
by Cristiano Nicolai (JIRA)
Cristiano Nicolai created TEIID-3057:
----------------------------------------
Summary: Kerberos ODBC connection on Teiid 8.8.0
Key: TEIID-3057
URL: https://issues.jboss.org/browse/TEIID-3057
Project: Teiid
Issue Type: Bug
Security Level: Public (Everyone can see)
Affects Versions: 8.8
Environment: Teiid 8.8.0
EAP 6.1.1
Reporter: Cristiano Nicolai
Assignee: Steven Hawkins
Priority: Blocker
After upgrading from version 8.7.0.Final to version 8.8.0.Final connections via ODBC using Kerberos/GSS stopped working.
When I try to connect with the new version, on the server I get the following error:
12:24:31,755 ERROR [org.teiid.ODBC] (New I/O worker #2) TEIID40015 Unexpected error occurred: java.lang.NullPointerException
at java.util.Hashtable.put(Hashtable.java:514) [rt.jar:1.7.0_55]
at org.teiid.odbc.ODBCServerRemoteImpl.logon(ODBCServerRemoteImpl.java:244) [teiid-runtime-8.8.0.Final.jar:8.8.0.Final]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_55]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_55]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_55]
at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_55]
at org.teiid.transport.ODBCClientInstance.processMessage(ODBCClientInstance.java:127) [teiid-runtime-8.8.0.Final.jar:8.8.0.Final]
at org.teiid.transport.ODBCClientInstance.receivedMessage(ODBCClientInstance.java:116) [teiid-runtime-8.8.0.Final.jar:8.8.0.Final]
at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:211) [teiid-runtime-8.8.0.Final.jar:8.8.0.Final]
>From the client I get the following message: psql: duplicate GSS authentication request
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
9 years, 9 months
[JBoss JIRA] (TEIID-3050) allow for more incremental insert with iterator
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3050?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3050:
---------------------------------------
Looking at this more, we do little in the way of parallel read/write in the current code anyway. As requests are sent to be executed we block on the results - without performing a prefetch. So I'll take a look at improving that as well.
> allow for more incremental insert with iterator
> -----------------------------------------------
>
> Key: TEIID-3050
> URL: https://issues.jboss.org/browse/TEIID-3050
> Project: Teiid
> Issue Type: Enhancement
> Security Level: Public(Everyone can see)
> Components: Misc. Connectors, Query Engine
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 8.9
>
>
> The current bulk insert logic assumes that it is avoiding a global transactions by fully reading the results before sending the tuplebuffer iterator to the source for processing, which can then just use a local transaction. However if we are already operating under a transaction or the user doesn't want a transaction (such as with a staging materialized view load) then the insert should happen more incrementally.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
9 years, 9 months
[JBoss JIRA] (TEIID-3050) allow for more incremental insert with iterator
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3050?page=com.atlassian.jira.plugin... ]
Work on TEIID-3050 started by Steven Hawkins.
> allow for more incremental insert with iterator
> -----------------------------------------------
>
> Key: TEIID-3050
> URL: https://issues.jboss.org/browse/TEIID-3050
> Project: Teiid
> Issue Type: Enhancement
> Security Level: Public(Everyone can see)
> Components: Misc. Connectors, Query Engine
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 8.9
>
>
> The current bulk insert logic assumes that it is avoiding a global transactions by fully reading the results before sending the tuplebuffer iterator to the source for processing, which can then just use a local transaction. However if we are already operating under a transaction or the user doesn't want a transaction (such as with a staging materialized view load) then the insert should happen more incrementally.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
9 years, 9 months
[JBoss JIRA] (TEIID-3056) MongoDB: Put nested JSON documents in one single table
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-3056?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-3056:
-------------------------------------
Now that TEIID-2958 is available, this can be solved with a "import" option that user can define how he/she wants their existing documents be imported. However, the caveat is when the document is being written back to the mongodb store it will write back in the same flat organization without nesting. I do not believe that is the expecting behavior.
I am open to implementing this if above restriction is acceptable.
> MongoDB: Put nested JSON documents in one single table
> -------------------------------------------------------
>
> Key: TEIID-3056
> URL: https://issues.jboss.org/browse/TEIID-3056
> Project: Teiid
> Issue Type: Enhancement
> Security Level: Public(Everyone can see)
> Components: Misc. Connectors
> Affects Versions: 8.7
> Environment: MongoDB with Teiid
> Reporter: Ivan Chan
> Assignee: Ramesh Reddy
> Labels: teiid
>
> Currently, it seems like ID needs to be appear in parent and child for nested documents. But it is unlikely a case for MongoDB customers. It would be nice if Teiid can flatten out data in one single table. Therefore, users would not need to insert parent id in the child document in order for Teiid to work.
> I am thinking the following case. For example I have a JSON object like this:
> {code}
> Customer
> {
> _id: 1374932,
> FirstName: "John",
> LastName: "Doe",
> Address: {
> _id: 43839430,
> Street: "123 Lane",
> City: "New York",
> State: "NY",
> Zipcode: "12345"
> }
> }
> {code}
>
> In this case, customer._id doesn't exist inside Address. There is no way to do join in regular SQL fashion. But it would be nice if teiid can put the column from parent and child into a single table. Maybe something similar to the following schema:
> {code}
> CREATE FOREIGN TABLE Customer (
> CustomerId integer PRIMARY KEY,
> FirstName varchar(25),
> LastName varchar(25),
> address__id integer,
> address_Street varchar(50),
> address_City varchar(25),
> address_State varchar(25),
> address_Zipcode varchar(6),
> ) OPTIONS(UPDATABLE 'TRUE');
> {code}
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
9 years, 9 months