]
Lucie Fabrikova commented on TEIID-4368:
----------------------------------------
The grammar says for "text table":
TEXTTABLE <lparen> <common value expression> ( SELECTOR <string> )?
COLUMNS <text table column> ... ( HEADER ( <unsigned integer> )? )? ( SKIP
<unsigned integer> )? ( NO TRIM )? <rparen> ( AS )? <identifier>
and for "text table column":
<identifier> ( ( FOR ORDINALITY ) | ( ( HEADER <string> )? <data type> (
WIDTH <unsigned integer> ( NO TRIM )? )? ( SELECTOR <string> <unsigned
integer> )? ) )
I see the header both in text table and in text table column definition... why is query
"TEXTTABLE(UNESCAPE('a\nb\nc\nd') COLUMNS a HEADER 'a' string HEADER
1) " incorrect then? The first use of header is supposed to be from texttable column
definition and the second one from texttable...
Fail to deploy VDB with TextTable SELECTOR, ROW DELIMITER, HEADER
-----------------------------------------------------------------
Key: TEIID-4368
URL:
https://issues.jboss.org/browse/TEIID-4368
Project: Teiid
Issue Type: Bug
Affects Versions: 8.7
Reporter: Lucie Fabrikova
Assignee: Steven Hawkins
Attachments: texttabvdb-vdb.xml
Server fails to deploy dynamic vdb with models which contain following TextTable
parameters: SELECTOR, ROW DELIMITER, HEADER.
Part of server log:
10:24:02,171 INFO [org.jboss.as.server.deployment] (MSC service thread 1-1) JBAS015876:
Starting deployment of "texttabvdb-vdb.xml" (runtime-name:
"texttabvdb-vdb.xml")
10:24:02,213 INFO [org.teiid.RUNTIME] (MSC service thread 1-6) TEIID50029 VDB texttab.1
model "model2" metadata is currently being loaded. Start Time: 8/1/16 10:24 AM
10:24:02,214 INFO [org.teiid.RUNTIME] (MSC service thread 1-6) TEIID50029 VDB texttab.1
model "model3" metadata is currently being loaded. Start Time: 8/1/16 10:24 AM
10:24:02,217 WARN [org.teiid.RUNTIME] (teiid-async-threads - 2) TEIID50036 VDB texttab.1
model "model2" metadata failed to load. Reason:TEIID30386
org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered
"COLUMNS col1 string [*]ROW[*] DELIMITER 'X'" at line 7, column 59.
Was expecting: "escape" | "no" | "selector" |
"skip" | "width" | "delimiter" | "quote" |
"header" | "," | "(" ...
10:24:02,218 WARN [org.teiid.RUNTIME] (teiid-async-threads - 3) TEIID50036 VDB texttab.1
model "model3" metadata failed to load. Reason:TEIID30386
org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered
") COLUMNS a [*]HEADER[*] 'a' string" at line 7, column 52.
Was expecting: "string" | "varbinary" | "varchar" |
"boolean" | "byte" | "tinyint" | "short" |
"smallint" | "char" | "integer" ...
10:24:02,219 INFO [org.teiid.RUNTIME] (MSC service thread 1-6) TEIID50029 VDB texttab.1
model "model5" metadata is currently being loaded. Start Time: 8/1/16 10:24 AM
10:24:02,222 INFO [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID50030 VDB texttab.1
model "model5" metadata loaded. End Time: 8/1/16 10:24 AM
10:24:02,298 INFO [org.jboss.as.server] (management-handler-thread - 14) JBAS015865:
Replaced deployment "texttabvdb-vdb.xml" with deployment
"texttabvdb-vdb.xml"