8:08 a.m.
[
https://issues.jboss.org/browse/TEIID-3002?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-3002.
-----------------------------------
Resolution: Rejected
If you specify header, then we will look for row values by matching their name to the
header. Otherwise we will assume that the columns are defined positionally.
TEIID30181 HEADER entry missing for column name id in Unknown
-------------------------------------------------------------
Key: TEIID-3002
URL: https://issues.jboss.org/browse/TEIID-3002
Project: Teiid
Issue Type: Bug
Security Level: Public(Everyone can see)
Environment: TEIID 8.8, JBoss EAP 6.1alpha
Reporter: luca gioppo
Assignee: Steven Hawkins
I'm accessing a CSV file through the web service connector (follows the
resource-adapter):
<resource-adapter id="webservice">
<module slot="main"
id="org.jboss.teiid.resource-adapter.webservice"/>
<connection-definitions>
<connection-definition
class-name="org.teiid.resource.adapter.ws.WSManagedConnectionFactory"
jndi-name="java:/amm" enabled="true" use-java-context="true"
pool-name="amm">
<config-property
name="EndPoint">http://spcdata.digitpa.gov.it/data/amm.csv</config-property>
</connection-definition>
</connection-definitions>
</resource-adapter>
I create a table from, this CSV but not have the first row as header column name, so I
gave names to the table and have this transformation:
SELECT
A.id, A.denominazione, A.sede_legale, A.nome_resp, A.cognome_resp, A.cap, A.provincia,
A.regione, A.sito_istituzionale, A.indirizzo, A.titolo_resp, A.tipo_istat, A.acronimo,
A.cf_validato, A.cf, A.mail, A.tipo_mail, A.mail2, A.tipo_mail2, A.mail3, A.tipo_mail3,
A.facebook, A.twitter, A.googleplus, A.youtube, A.liv_access
FROM
(EXEC amm.invokeHttp('GET', null,
'http://spcdata.digitpa.gov.it/data/amm.csv', 'TRUE')) AS f,
TEXTTABLE(TO_CHARS(f.result, 'UTF-8') COLUMNS id string, denominazione string,
sede_legale string, nome_resp string, cognome_resp string, cap string, provincia string,
regione string, sito_istituzionale string, indirizzo string, titolo_resp string,
tipo_istat string, acronimo string, cf_validato string, cf string, mail string, tipo_mail
string, mail2 string, tipo_mail2 string, mail3 string, tipo_mail3 string, facebook string,
twitter string, googleplus string, youtube string, liv_access string DELIMITER ' '
HEADER) AS A
When I try to access the VDB I get this error:
14:52:42,410 ERROR [org.teiid.PROCESSOR.MATVIEWS] (Worker2_QueryProcessorQueue56)
Ho/sIQ8ukETA TEIID30015 Failed to load materialized view table #MAT_AMMV.AMMINISTRAZIONI.:
org.teiid.core.TeiidProcessingException: TEIID30181 HEADER entry missing for column name
id in Unknown.
at
org.teiid.query.processor.relational.TextTableNode.processHeader(TextTableNode.java:477)
[teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
at
org.teiid.query.processor.relational.TextTableNode.initReader(TextTableNode.java:453)
[teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
at
org.teiid.query.processor.relational.TextTableNode.nextBatchDirect(TextTableNode.java:198)
[teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278)
[teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69)
[teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
at
org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70)
[teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84)
[teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
at
org.teiid.common.buffer.AbstractTupleSource.hasNext(AbstractTupleSource.java:92)
[teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
at
org.teiid.query.processor.relational.NestedTableJoinStrategy.process(NestedTableJoinStrategy.java:119)
[teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
at
org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:211)
[teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278)
[teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
at
org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146)
[teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278)
[teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
at
org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136)
[teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
at
org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151)
[teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114)
[teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
at
org.teiid.query.processor.BatchCollector$BatchProducerTupleSource.nextTuple(BatchCollector.java:94)
[teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
at org.teiid.query.tempdata.TempTable$UpdateProcessor.process(TempTable.java:255)
[teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
at
org.teiid.query.tempdata.TempTable$InsertUpdateProcessor.process(TempTable.java:102)
[teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
at org.teiid.query.tempdata.TempTable.insert(TempTable.java:682)
[teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
at
org.teiid.query.tempdata.TempTableDataManager$7.createTupleSource(TempTableDataManager.java:659)
[teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
at
org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:108)
[teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
at
org.teiid.query.tempdata.TempTableDataManager$4.load(TempTableDataManager.java:558)
[teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
at
org.teiid.query.tempdata.TempTableDataManager$4.createTupleSource(TempTableDataManager.java:487)
[teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
at
org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:108)
[teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
at
org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:369)
[teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278)
[teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
at
org.teiid.query.processor.relational.LimitNode.nextBatchDirect(LimitNode.java:102)
[teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278)
[teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
at
org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136)
[teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
at
org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151)
[teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114)
[teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
at
org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164)
[teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
at
org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146)
[teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
at
org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:444)
[teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
at
org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:326)
[teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
[teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254)
[teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
at
org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274)
[teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
[teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214)
[teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
[rt.jar:1.6.0_25]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
[rt.jar:1.6.0_25]
at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_25]
14:52:42,413 WARN [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue56) Ho/sIQ8ukETA
TEIID30020 Processing exception for request Ho/sIQ8ukETA.5 'TEIID30181 HEADER entry
missing for column name id in Unknown.'. Originally TeiidProcessingException
TextTableNode.java:477. Enable more detailed logging to see the entire stacktrace.
Where I do something wrong?
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
3862
days inactive
3862
days old
0 comments
1 participants
participants (1)
-
Steven Hawkins (JIRA)