[JBoss JIRA] (TEIID-3921) Accumulo translator doesn't end query execution when there are no tablet servers
by Jan Stastny (JIRA)
[ https://issues.jboss.org/browse/TEIID-3921?page=com.atlassian.jira.plugin... ]
Jan Stastny commented on TEIID-3921:
------------------------------------
When I set a timeout for the query in my vdb, there's a problem when DV is turned off, before Accumulo instance comes alive. (Note that this happen, even though the query was cancelled by the timeout).
When there is no tablet server and I have timeout set, this appears in the console:
{code:plain}
11:13:56,733 WARN [org.apache.accumulo.core.client.impl.ServerClient] (Worker1_QueryProcessorQueue1) There are no tablet servers: check that zookeeper and accumulo are running.
11:14:01,616 INFO [org.teiid.PROCESSOR] (Server Side Timeout1) TEIID31096 Canceling query Si5TJdVBy6QQ.0 since it has exceeded the timeout of 5,000 milliseconds.
{code}
But when turning Teiid off, this appears:
{code:plain}
11:14:28,210 ERROR [org.apache.accumulo.core.util.UtilWaitThread] (Worker1_QueryProcessorQueue1) sleep interrupted: java.lang.InterruptedException: sleep interrupted
at java.lang.Thread.sleep(Native Method) [rt.jar:1.7.0_79]
at org.apache.accumulo.core.util.UtilWaitThread.sleep(UtilWaitThread.java:26) [accumulo-core-1.5.0.jar:1.5.0]
at org.apache.accumulo.core.client.impl.ServerClient.executeRaw(ServerClient.java:112) [accumulo-core-1.5.0.jar:1.5.0]
at org.apache.accumulo.core.client.impl.ServerClient.execute(ServerClient.java:71) [accumulo-core-1.5.0.jar:1.5.0]
at org.apache.accumulo.core.client.impl.ConnectorImpl.<init>(ConnectorImpl.java:64) [accumulo-core-1.5.0.jar:1.5.0]
at org.apache.accumulo.core.client.ZooKeeperInstance.getConnector(ZooKeeperInstance.java:227) [accumulo-core-1.5.0.jar:1.5.0]
at org.apache.accumulo.core.client.ZooKeeperInstance.getConnector(ZooKeeperInstance.java:222) [accumulo-core-1.5.0.jar:1.5.0]
at org.teiid.resource.adapter.accumulo.AccumuloConnectionImpl.<init>(AccumuloConnectionImpl.java:64)
at org.teiid.resource.adapter.accumulo.AccumuloManagedConnectionFactory$AccumuloConnectionFactory.getConnection(AccumuloManagedConnectionFactory.java:60)
at org.teiid.resource.adapter.accumulo.AccumuloManagedConnectionFactory$AccumuloConnectionFactory.getConnection(AccumuloManagedConnectionFactory.java:49)
at org.teiid.resource.spi.BasicManagedConnectionFactory.createManagedConnection(BasicManagedConnectionFactory.java:71) [teiid-api-8.12.3.redhat-1.jar:8.12.3.redhat-1]
at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:873)
at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:418)
at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:470)
at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:442)
at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:354)
at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:327)
at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:510)
at org.teiid.resource.spi.WrappedConnectionFactory.getConnection(WrappedConnectionFactory.java:58) [teiid-api-8.12.3.redhat-1.jar:8.12.3.redhat-1]
at org.teiid.translator.ExecutionFactory.getConnection(ExecutionFactory.java:173) [teiid-api-8.12.3.redhat-1.jar:8.12.3.redhat-1]
at org.teiid.translator.ExecutionFactory.getConnection(ExecutionFactory.java:194) [teiid-api-8.12.3.redhat-1.jar:8.12.3.redhat-1]
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:313) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_79]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_79]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_79]
at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_79]
at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
at com.sun.proxy.$Proxy93.execute(Unknown Source)
at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_79]
at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_79]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_79]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_79]
{code}
This indicates, that there is still a thread waiting for Accumulo to become available, even though the query was cancelled, thus there's no need to wait for it anymore.
> Accumulo translator doesn't end query execution when there are no tablet servers
> --------------------------------------------------------------------------------
>
> Key: TEIID-3921
> URL: https://issues.jboss.org/browse/TEIID-3921
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.12.3
> Reporter: Jan Stastny
> Assignee: Ramesh Reddy
>
> Teiid accumulo translator doesn't interrupt query execution when the accumulo instance is not running.
> There might be a situation that Zookeeper instance is running, but Accumulo is not.
> The translator, even though there is no tablet server entry in zookeeper, for given accumulo instance, executes the query. The query is running until query timeout exceeds. There is no indication of the fact, that accumulo tablet server is not present/responding except for
> {code}
> 09:25:46,539 WARN [org.apache.accumulo.core.client.impl.ServerClient] (Worker3_QueryProcessorQueue21) There are no tablet servers: check that zookeeper and accumulo are running.
> {code}
> There might be even situation, that Accumulo stopped in unusual way and didn't alter the tablet server information in Zookeeper, this way, there is a tablet server entry present in Zookeeper, but the tablet server is in fact not running. So Teiid should check the tablet server's address which received from Zookeeper.
> Interesting to note is the fact, that the same problem can be examined in accumulo's shell:
> {code}
> $ bin/accumulo shell -u root
> Password: ******
> 2016-01-22 10:02:05,604 [impl.ServerClient] WARN : There are no tablet servers: check that zookeeper and accumulo are running.
> {code}
> and then the shell hangs. Teiid needs to overcome this limitation.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 11 months
[JBoss JIRA] (TEIID-3918) HIVE translator does not support direct query procedure
by jie tao (JIRA)
[ https://issues.jboss.org/browse/TEIID-3918?page=com.atlassian.jira.plugin... ]
jie tao commented on TEIID-3918:
--------------------------------
when and in which version will this feature be released?
> HIVE translator does not support direct query procedure
> -------------------------------------------------------
>
> Key: TEIID-3918
> URL: https://issues.jboss.org/browse/TEIID-3918
> Project: Teiid
> Issue Type: Feature Request
> Components: JDBC Connector
> Reporter: jie tao
> Assignee: Steven Hawkins
> Fix For: 9.0
>
>
> I used EXEC native (sqlstring) to let my query be executed directly on my Hive without Teiid's modification of my query. This works with MySQL. For HIVE I got:
> "org.teiid.jdbc.TeiidSQLException: TEIID30504 Hive13: TEIID24000 This EXEC native('select a.game, a.lang, get_json_object(a.json, \"$.product\") from test.event_log a') command not supported.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 11 months
[JBoss JIRA] (TEIID-3871) moving documentation from confluence to gitbook
by Kylin Soong (JIRA)
[ https://issues.jboss.org/browse/TEIID-3871?page=com.atlassian.jira.plugin... ]
Kylin Soong commented on TEIID-3871:
------------------------------------
So far, for https://teiid.gitbooks.io/documents/content/index.html there still have 2 aspect works left:
h2. Fix the link
There are lot of pages have link point to conference pages that need to fixed, some pages have internal link that not work. Steven have created a Sub-task for addressing this.
h2. Polish the UI
The UI not so user-friendly, at least, navigation tree should add expand and collapse ability. But from F2F notes, teiid document will add to teiid's website, so I think the polish UI work should let the website developer do, we only need to provide html/pdf/epub each time a new version released.
> moving documentation from confluence to gitbook
> -------------------------------------------------
>
> Key: TEIID-3871
> URL: https://issues.jboss.org/browse/TEIID-3871
> Project: Teiid
> Issue Type: Task
> Components: Documentation
> Affects Versions: 9.x
> Reporter: Kylin Soong
> Assignee: Kylin Soong
> Fix For: 9.x
>
>
> From Teiid DV 7 F2F Notes,
> " In the Teiid 9.x timeframe we should look toward moving everything to gitbook / markdown. We should start by migrating the documentation and solicit help with the website if possible."
> This issue will address this.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 11 months
[JBoss JIRA] (TEIID-3871) moving documentation from confluence to gitbook
by Kylin Soong (JIRA)
[ https://issues.jboss.org/browse/TEIID-3871?page=com.atlassian.jira.plugin... ]
Kylin Soong edited comment on TEIID-3871 at 1/25/16 9:04 PM:
-------------------------------------------------------------
>Do you know off hand what needs to be done for the subpages like the ones under https://teiid.gitbooks.io/reference-guide/content/reference/Scalar_Functi... to show up?
The reason https://teiid.gitbooks.io/reference-guide/content/reference/Scalar_Functi... not show up is some content not submitted, now it works.
[1] is a draft which I used in migration, Due to we have created [2], so I think [2] is the place which hold the content, and future update/maintenance should base on.
[1] https://github.com/teiiddoc
[2] https://github.com/teiid/teiid-documents/
>Also the general link https://teiid.gitbooks.io/documents/content seems to provide dead links, is that expected?
If you append a slash or slash with index.html, for example
* https://teiid.gitbooks.io/documents/content/
* https://teiid.gitbooks.io/documents/content/index.html
it will works, probably some more investigation can find root cause.What I have considered is we should custom domain, as [3], we can buy a domain(eg,doc.teiid.org), then replace default https://teiid.gitbooks.io/documents/content/, what's about your think?
[3] http://help.gitbook.com/platform/domains.html
was (Author: kylin):
>Do you know off hand what needs to be done for the subpages like the ones under https://teiid.gitbooks.io/reference-guide/content/reference/Scalar_Functi... to show up?
The reason https://teiid.gitbooks.io/reference-guide/content/reference/Scalar_Functi... not show up is some content not submitted, now it works.
[1] is a draft which I used in migration, Due to we have created [2], so I think [2] is the place which hold the content, and future update/maintenance should base on.
[1] https://github.com/teiiddoc
[2] https://github.com/teiid/teiid-documents/
>Also the general link https://teiid.gitbooks.io/documents/content seems to provide dead links, is that expected?
If you append a slash or slash with index.html, for example
* https://teiid.gitbooks.io/documents/content/
* https://teiid.gitbooks.io/documents/content/index.html
it will works, probably some more investigation can find root cause.What I have considered is we should custom domain, as [3], we can buy a domain(eg,doc.teiid.org), then replace default https://teiid.gitbooks.io/documents/content/, what's about your think?
[3] http://help.gitbook.com/platform/domains.html
> moving documentation from confluence to gitbook
> -------------------------------------------------
>
> Key: TEIID-3871
> URL: https://issues.jboss.org/browse/TEIID-3871
> Project: Teiid
> Issue Type: Task
> Components: Documentation
> Affects Versions: 9.x
> Reporter: Kylin Soong
> Assignee: Kylin Soong
> Fix For: 9.x
>
>
> From Teiid DV 7 F2F Notes,
> " In the Teiid 9.x timeframe we should look toward moving everything to gitbook / markdown. We should start by migrating the documentation and solicit help with the website if possible."
> This issue will address this.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 11 months
[JBoss JIRA] (TEIID-3871) moving documentation from confluence to gitbook
by Kylin Soong (JIRA)
[ https://issues.jboss.org/browse/TEIID-3871?page=com.atlassian.jira.plugin... ]
Kylin Soong commented on TEIID-3871:
------------------------------------
>Do you know off hand what needs to be done for the subpages like the ones under https://teiid.gitbooks.io/reference-guide/content/reference/Scalar_Functi... to show up?
The reason https://teiid.gitbooks.io/reference-guide/content/reference/Scalar_Functi... not show up is some content not submitted, now it works.
[1] is a draft which I used in migration, Due to we have created [2], so I think [2] is the place which hold the content, and future update/maintenance should base on.
[1] https://github.com/teiiddoc
[2] https://github.com/teiid/teiid-documents/
>Also the general link https://teiid.gitbooks.io/documents/content seems to provide dead links, is that expected?
If you append a slash or slash with index.html, for example
* https://teiid.gitbooks.io/documents/content/
* https://teiid.gitbooks.io/documents/content/index.html
it will works, probably some more investigation can find root cause.What I have considered is we should custom domain, as [3], we can buy a domain(eg,doc.teiid.org), then replace default https://teiid.gitbooks.io/documents/content/, what's about your think?
[3] http://help.gitbook.com/platform/domains.html
> moving documentation from confluence to gitbook
> -------------------------------------------------
>
> Key: TEIID-3871
> URL: https://issues.jboss.org/browse/TEIID-3871
> Project: Teiid
> Issue Type: Task
> Components: Documentation
> Affects Versions: 9.x
> Reporter: Kylin Soong
> Assignee: Kylin Soong
> Fix For: 9.x
>
>
> From Teiid DV 7 F2F Notes,
> " In the Teiid 9.x timeframe we should look toward moving everything to gitbook / markdown. We should start by migrating the documentation and solicit help with the website if possible."
> This issue will address this.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 11 months
[JBoss JIRA] (TEIID-3929) Accumulo does not return null values
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3929?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3929:
---------------------------------------
Ramesh does this imply that you need to also select the key column at the translator layer?
> Accumulo does not return null values
> ------------------------------------
>
> Key: TEIID-3929
> URL: https://issues.jboss.org/browse/TEIID-3929
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.12.3
> Reporter: Jan Stastny
> Assignee: Steven Hawkins
>
> Accumulo doesn't return null values when a whole 'column' is being selected.
> For a command in accumulo shell like:
> {code:plain}
> scan -c name:BYTENUM
> {code}
> Accumulo returns only non-empty values, this is expected behaviour.
> Equivalent query in Teiid would be:
> {code:sql}
> SELECT ByteNum FROM SmallA
> {code}
> Which returns the same results as Accumulo does. That means, no NULL values, if there are rowids without specified column families/qualifiers missing. But when a user has his schema defined in a vdb, he probably expects, that he will get as many rows as there are in the table.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 11 months