[JBoss JIRA] (TEIID-3074) NPE When using External Materialization management is use
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-3074?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-3074:
-------------------------------------
Yes, it does release the threads. Since I had break point I could see all the threads just hit break point an waiting. Seems like there is no limit on how many threads we use in that situation. yes, it was confusing to explain the behavior. You deterministic comment makes sense, let me change it and I report back
> NPE When using External Materialization management is use
> ---------------------------------------------------------
>
> Key: TEIID-3074
> URL: https://issues.jboss.org/browse/TEIID-3074
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Query Engine
> Affects Versions: 8.5
> Reporter: Ramesh Reddy
> Assignee: Steven Hawkins
> Attachments: debug_plan.txt, solr-integration-with-matview-vdb.xml
>
>
> When I was issuing query that has externalized materialization with management option to true, I am seeing NPE. Tried to see why NPE is occurring was not able to figure out (yet)
> {code}
> 14:37:50,269 ERROR [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue8477) 0z97J5OWq7x9 Connector worker process failed for atomic-request=0z97J5OWq7x9.7.1.4220: java.lang.NullPointerException
> at org.teiid.translator.jdbc.JDBCQueryExecution.next(JDBCQueryExecution.java:338)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:385) [teiid-engine-8.9.0.Alpha1-SNAPSHOT.jar:8.9.0.Alpha1-SNAPSHOT]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:203) [teiid-engine-8.9.0.Alpha1-SNAPSHOT.jar:8.9.0.Alpha1-SNAPSHOT]
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:301) [teiid-engine-8.9.0.Alpha1-SNAPSHOT.jar:8.9.0.Alpha1-SNAPSHOT]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110) [teiid-engine-8.9.0.Alpha1-SNAPSHOT.jar:8.9.0.Alpha1-SNAPSHOT]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:107) [teiid-engine-8.9.0.Alpha1-SNAPSHOT.jar:8.9.0.Alpha1-SNAPSHOT]
> at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_65]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.9.0.Alpha1-SNAPSHOT.jar:8.9.0.Alpha1-SNAPSHOT]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.9.0.Alpha1-SNAPSHOT.jar:8.9.0.Alpha1-SNAPSHOT]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.9.0.Alpha1-SNAPSHOT.jar:8.9.0.Alpha1-SNAPSHOT]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.9.0.Alpha1-SNAPSHOT.jar:8.9.0.Alpha1-SNAPSHOT]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_65]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_65]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_65]
> {code}
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 7 months
[JBoss JIRA] (TEIID-3091) Excel translator issue: FIRST_DATA_ROW_NUMBER option not working
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-3091?page=com.atlassian.jira.plugin... ]
Ramesh Reddy edited comment on TEIID-3091 at 8/18/14 3:25 PM:
--------------------------------------------------------------
ROW_ID represents row number from excel document, not a sequential number, if you need a sequential number see ROW_NUMBER function. I believe you could like
select * from Sheet1 where ROW_ID = 2
was (Author: rareddy):
ROW_ID represents row number from excel document, not a sequential number, if you need a sequential number see ROW_NUMBER function.
> Excel translator issue: FIRST_DATA_ROW_NUMBER option not working
> -----------------------------------------------------------------
>
> Key: TEIID-3091
> URL: https://issues.jboss.org/browse/TEIID-3091
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Misc. Connectors
> Affects Versions: 8.7.1
> Reporter: Van Halbert
> Assignee: Ramesh Reddy
> Attachments: excel.png, excel_row_number_issue.tiff, otherholdings.xls, portfolio-vdb.xml
>
>
> The FIRST_DATA_ROW_NUMBER option not working, seeing the first row in the results, when using the following dynamic VDB definition:
> {code}
> <model name="OtherHoldings">
> <property name="importer.headerRowNumber" value="1"/>
> <property name="importer.ExcelFileName" value="otherholdings.xls"/>
> <source name="excelconnector" translator-name="excel" connection-jndi-name="java:/excel-file"/>
> <metadata type="DDL"><![CDATA[
> SET NAMESPACE 'http://www.teiid.org/translator/excel/2014' AS teiid_excel;
> CREATE FOREIGN TABLE Sheet1 (
> ROW_ID integer OPTIONS (SEARCHABLE 'All_Except_Like', "teiid_excel:CELL_NUMBER" 'ROW_ID'),
> FirstName string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '1'),
> LastName string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '2'),
> Age string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '3'),
> CONSTRAINT PK0 PRIMARY KEY(ROW_ID)
> ) OPTIONS ("teiid_excel:FILE" 'otherholdings.xls', "teiid_excel:FIRST_DATA_ROW_NUMBER" '2');
> ]]> </metadata>
> </model>
> {code}
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 7 months
[JBoss JIRA] (TEIID-3091) Excel translator issue: FIRST_DATA_ROW_NUMBER option not working
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-3091?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-3091:
-------------------------------------
ROW_ID represents row number from excel document, not a sequential number, if you need a sequential number see ROW_NUMBER function.
> Excel translator issue: FIRST_DATA_ROW_NUMBER option not working
> -----------------------------------------------------------------
>
> Key: TEIID-3091
> URL: https://issues.jboss.org/browse/TEIID-3091
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Misc. Connectors
> Affects Versions: 8.7.1
> Reporter: Van Halbert
> Assignee: Ramesh Reddy
> Attachments: excel.png, excel_row_number_issue.tiff, otherholdings.xls, portfolio-vdb.xml
>
>
> The FIRST_DATA_ROW_NUMBER option not working, seeing the first row in the results, when using the following dynamic VDB definition:
> {code}
> <model name="OtherHoldings">
> <property name="importer.headerRowNumber" value="1"/>
> <property name="importer.ExcelFileName" value="otherholdings.xls"/>
> <source name="excelconnector" translator-name="excel" connection-jndi-name="java:/excel-file"/>
> <metadata type="DDL"><![CDATA[
> SET NAMESPACE 'http://www.teiid.org/translator/excel/2014' AS teiid_excel;
> CREATE FOREIGN TABLE Sheet1 (
> ROW_ID integer OPTIONS (SEARCHABLE 'All_Except_Like', "teiid_excel:CELL_NUMBER" 'ROW_ID'),
> FirstName string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '1'),
> LastName string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '2'),
> Age string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '3'),
> CONSTRAINT PK0 PRIMARY KEY(ROW_ID)
> ) OPTIONS ("teiid_excel:FILE" 'otherholdings.xls', "teiid_excel:FIRST_DATA_ROW_NUMBER" '2');
> ]]> </metadata>
> </model>
> {code}
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 7 months
[JBoss JIRA] (TEIID-3091) Excel translator issue: FIRST_DATA_ROW_NUMBER option not working
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-3091?page=com.atlassian.jira.plugin... ]
Van Halbert commented on TEIID-3091:
------------------------------------
but interesting though, the ROW_ID starts with 2, and not 1.
> Excel translator issue: FIRST_DATA_ROW_NUMBER option not working
> -----------------------------------------------------------------
>
> Key: TEIID-3091
> URL: https://issues.jboss.org/browse/TEIID-3091
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Misc. Connectors
> Affects Versions: 8.7.1
> Reporter: Van Halbert
> Assignee: Ramesh Reddy
> Attachments: excel.png, excel_row_number_issue.tiff, otherholdings.xls, portfolio-vdb.xml
>
>
> The FIRST_DATA_ROW_NUMBER option not working, seeing the first row in the results, when using the following dynamic VDB definition:
> {code}
> <model name="OtherHoldings">
> <property name="importer.headerRowNumber" value="1"/>
> <property name="importer.ExcelFileName" value="otherholdings.xls"/>
> <source name="excelconnector" translator-name="excel" connection-jndi-name="java:/excel-file"/>
> <metadata type="DDL"><![CDATA[
> SET NAMESPACE 'http://www.teiid.org/translator/excel/2014' AS teiid_excel;
> CREATE FOREIGN TABLE Sheet1 (
> ROW_ID integer OPTIONS (SEARCHABLE 'All_Except_Like', "teiid_excel:CELL_NUMBER" 'ROW_ID'),
> FirstName string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '1'),
> LastName string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '2'),
> Age string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '3'),
> CONSTRAINT PK0 PRIMARY KEY(ROW_ID)
> ) OPTIONS ("teiid_excel:FILE" 'otherholdings.xls', "teiid_excel:FIRST_DATA_ROW_NUMBER" '2');
> ]]> </metadata>
> </model>
> {code}
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 7 months
[JBoss JIRA] (TEIID-3091) Excel translator issue: FIRST_DATA_ROW_NUMBER option not working
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-3091?page=com.atlassian.jira.plugin... ]
Van Halbert commented on TEIID-3091:
------------------------------------
Never mind, user error. I had an old .vdb that I was trying things out with. It had the "teiid_excel:FIRST_DATA_ROW_NUMBER" '2'); option removed. When I added it back. It worked.
> Excel translator issue: FIRST_DATA_ROW_NUMBER option not working
> -----------------------------------------------------------------
>
> Key: TEIID-3091
> URL: https://issues.jboss.org/browse/TEIID-3091
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Misc. Connectors
> Affects Versions: 8.7.1
> Reporter: Van Halbert
> Assignee: Ramesh Reddy
> Attachments: excel.png, excel_row_number_issue.tiff, otherholdings.xls, portfolio-vdb.xml
>
>
> The FIRST_DATA_ROW_NUMBER option not working, seeing the first row in the results, when using the following dynamic VDB definition:
> {code}
> <model name="OtherHoldings">
> <property name="importer.headerRowNumber" value="1"/>
> <property name="importer.ExcelFileName" value="otherholdings.xls"/>
> <source name="excelconnector" translator-name="excel" connection-jndi-name="java:/excel-file"/>
> <metadata type="DDL"><![CDATA[
> SET NAMESPACE 'http://www.teiid.org/translator/excel/2014' AS teiid_excel;
> CREATE FOREIGN TABLE Sheet1 (
> ROW_ID integer OPTIONS (SEARCHABLE 'All_Except_Like', "teiid_excel:CELL_NUMBER" 'ROW_ID'),
> FirstName string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '1'),
> LastName string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '2'),
> Age string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '3'),
> CONSTRAINT PK0 PRIMARY KEY(ROW_ID)
> ) OPTIONS ("teiid_excel:FILE" 'otherholdings.xls', "teiid_excel:FIRST_DATA_ROW_NUMBER" '2');
> ]]> </metadata>
> </model>
> {code}
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 7 months
[JBoss JIRA] (TEIID-3091) Excel translator issue: FIRST_DATA_ROW_NUMBER option not working
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-3091?page=com.atlassian.jira.plugin... ]
Van Halbert updated TEIID-3091:
-------------------------------
Attachment: portfolio-vdb.xml
> Excel translator issue: FIRST_DATA_ROW_NUMBER option not working
> -----------------------------------------------------------------
>
> Key: TEIID-3091
> URL: https://issues.jboss.org/browse/TEIID-3091
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Misc. Connectors
> Affects Versions: 8.7.1
> Reporter: Van Halbert
> Assignee: Ramesh Reddy
> Attachments: excel.png, excel_row_number_issue.tiff, otherholdings.xls, portfolio-vdb.xml
>
>
> The FIRST_DATA_ROW_NUMBER option not working, seeing the first row in the results, when using the following dynamic VDB definition:
> {code}
> <model name="OtherHoldings">
> <property name="importer.headerRowNumber" value="1"/>
> <property name="importer.ExcelFileName" value="otherholdings.xls"/>
> <source name="excelconnector" translator-name="excel" connection-jndi-name="java:/excel-file"/>
> <metadata type="DDL"><![CDATA[
> SET NAMESPACE 'http://www.teiid.org/translator/excel/2014' AS teiid_excel;
> CREATE FOREIGN TABLE Sheet1 (
> ROW_ID integer OPTIONS (SEARCHABLE 'All_Except_Like', "teiid_excel:CELL_NUMBER" 'ROW_ID'),
> FirstName string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '1'),
> LastName string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '2'),
> Age string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '3'),
> CONSTRAINT PK0 PRIMARY KEY(ROW_ID)
> ) OPTIONS ("teiid_excel:FILE" 'otherholdings.xls', "teiid_excel:FIRST_DATA_ROW_NUMBER" '2');
> ]]> </metadata>
> </model>
> {code}
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 7 months
[JBoss JIRA] (TEIID-3091) Excel translator issue: FIRST_DATA_ROW_NUMBER option not working
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-3091?page=com.atlassian.jira.plugin... ]
Van Halbert reopened TEIID-3091:
--------------------------------
> Excel translator issue: FIRST_DATA_ROW_NUMBER option not working
> -----------------------------------------------------------------
>
> Key: TEIID-3091
> URL: https://issues.jboss.org/browse/TEIID-3091
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Misc. Connectors
> Affects Versions: 8.7.1
> Reporter: Van Halbert
> Assignee: Ramesh Reddy
> Attachments: excel.png, excel_row_number_issue.tiff, otherholdings.xls, portfolio-vdb.xml
>
>
> The FIRST_DATA_ROW_NUMBER option not working, seeing the first row in the results, when using the following dynamic VDB definition:
> {code}
> <model name="OtherHoldings">
> <property name="importer.headerRowNumber" value="1"/>
> <property name="importer.ExcelFileName" value="otherholdings.xls"/>
> <source name="excelconnector" translator-name="excel" connection-jndi-name="java:/excel-file"/>
> <metadata type="DDL"><![CDATA[
> SET NAMESPACE 'http://www.teiid.org/translator/excel/2014' AS teiid_excel;
> CREATE FOREIGN TABLE Sheet1 (
> ROW_ID integer OPTIONS (SEARCHABLE 'All_Except_Like', "teiid_excel:CELL_NUMBER" 'ROW_ID'),
> FirstName string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '1'),
> LastName string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '2'),
> Age string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '3'),
> CONSTRAINT PK0 PRIMARY KEY(ROW_ID)
> ) OPTIONS ("teiid_excel:FILE" 'otherholdings.xls', "teiid_excel:FIRST_DATA_ROW_NUMBER" '2');
> ]]> </metadata>
> </model>
> {code}
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 7 months
[JBoss JIRA] (TEIID-3091) Excel translator issue: FIRST_DATA_ROW_NUMBER option not working
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-3091?page=com.atlassian.jira.plugin... ]
Van Halbert edited comment on TEIID-3091 at 8/18/14 3:11 PM:
-------------------------------------------------------------
I grabbed the latest changes and build the 8.9 version of the translator, then applied it to my 8.7.x server, and I get the same results using the attached .xls file. The changes didn't appear to fix the issue.
was (Author: van.halbert):
I grabbed the latest changes and build the 8.9 version of the translator, then applied it to my 8.7.x server, and I get the same results using the attached .xls file
> Excel translator issue: FIRST_DATA_ROW_NUMBER option not working
> -----------------------------------------------------------------
>
> Key: TEIID-3091
> URL: https://issues.jboss.org/browse/TEIID-3091
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Misc. Connectors
> Affects Versions: 8.7.1
> Reporter: Van Halbert
> Assignee: Ramesh Reddy
> Attachments: excel.png, excel_row_number_issue.tiff, otherholdings.xls
>
>
> The FIRST_DATA_ROW_NUMBER option not working, seeing the first row in the results, when using the following dynamic VDB definition:
> {code}
> <model name="OtherHoldings">
> <property name="importer.headerRowNumber" value="1"/>
> <property name="importer.ExcelFileName" value="otherholdings.xls"/>
> <source name="excelconnector" translator-name="excel" connection-jndi-name="java:/excel-file"/>
> <metadata type="DDL"><![CDATA[
> SET NAMESPACE 'http://www.teiid.org/translator/excel/2014' AS teiid_excel;
> CREATE FOREIGN TABLE Sheet1 (
> ROW_ID integer OPTIONS (SEARCHABLE 'All_Except_Like', "teiid_excel:CELL_NUMBER" 'ROW_ID'),
> FirstName string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '1'),
> LastName string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '2'),
> Age string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '3'),
> CONSTRAINT PK0 PRIMARY KEY(ROW_ID)
> ) OPTIONS ("teiid_excel:FILE" 'otherholdings.xls', "teiid_excel:FIRST_DATA_ROW_NUMBER" '2');
> ]]> </metadata>
> </model>
> {code}
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 7 months
[JBoss JIRA] (TEIID-3091) Excel translator issue: FIRST_DATA_ROW_NUMBER option not working
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-3091?page=com.atlassian.jira.plugin... ]
Van Halbert updated TEIID-3091:
-------------------------------
Attachment: otherholdings.xls
excel file
> Excel translator issue: FIRST_DATA_ROW_NUMBER option not working
> -----------------------------------------------------------------
>
> Key: TEIID-3091
> URL: https://issues.jboss.org/browse/TEIID-3091
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Misc. Connectors
> Affects Versions: 8.7.1
> Reporter: Van Halbert
> Assignee: Ramesh Reddy
> Attachments: excel.png, excel_row_number_issue.tiff, otherholdings.xls
>
>
> The FIRST_DATA_ROW_NUMBER option not working, seeing the first row in the results, when using the following dynamic VDB definition:
> {code}
> <model name="OtherHoldings">
> <property name="importer.headerRowNumber" value="1"/>
> <property name="importer.ExcelFileName" value="otherholdings.xls"/>
> <source name="excelconnector" translator-name="excel" connection-jndi-name="java:/excel-file"/>
> <metadata type="DDL"><![CDATA[
> SET NAMESPACE 'http://www.teiid.org/translator/excel/2014' AS teiid_excel;
> CREATE FOREIGN TABLE Sheet1 (
> ROW_ID integer OPTIONS (SEARCHABLE 'All_Except_Like', "teiid_excel:CELL_NUMBER" 'ROW_ID'),
> FirstName string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '1'),
> LastName string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '2'),
> Age string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '3'),
> CONSTRAINT PK0 PRIMARY KEY(ROW_ID)
> ) OPTIONS ("teiid_excel:FILE" 'otherholdings.xls', "teiid_excel:FIRST_DATA_ROW_NUMBER" '2');
> ]]> </metadata>
> </model>
> {code}
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 7 months
[JBoss JIRA] (TEIID-3091) Excel translator issue: FIRST_DATA_ROW_NUMBER option not working
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-3091?page=com.atlassian.jira.plugin... ]
Van Halbert commented on TEIID-3091:
------------------------------------
I grabbed the latest changes and build the 8.9 version of the translator, then applied it to my 8.7.x server, and I get the same results using the attached .xls file
> Excel translator issue: FIRST_DATA_ROW_NUMBER option not working
> -----------------------------------------------------------------
>
> Key: TEIID-3091
> URL: https://issues.jboss.org/browse/TEIID-3091
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Misc. Connectors
> Affects Versions: 8.7.1
> Reporter: Van Halbert
> Assignee: Ramesh Reddy
> Attachments: excel.png, excel_row_number_issue.tiff, otherholdings.xls
>
>
> The FIRST_DATA_ROW_NUMBER option not working, seeing the first row in the results, when using the following dynamic VDB definition:
> {code}
> <model name="OtherHoldings">
> <property name="importer.headerRowNumber" value="1"/>
> <property name="importer.ExcelFileName" value="otherholdings.xls"/>
> <source name="excelconnector" translator-name="excel" connection-jndi-name="java:/excel-file"/>
> <metadata type="DDL"><![CDATA[
> SET NAMESPACE 'http://www.teiid.org/translator/excel/2014' AS teiid_excel;
> CREATE FOREIGN TABLE Sheet1 (
> ROW_ID integer OPTIONS (SEARCHABLE 'All_Except_Like', "teiid_excel:CELL_NUMBER" 'ROW_ID'),
> FirstName string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '1'),
> LastName string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '2'),
> Age string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '3'),
> CONSTRAINT PK0 PRIMARY KEY(ROW_ID)
> ) OPTIONS ("teiid_excel:FILE" 'otherholdings.xls', "teiid_excel:FIRST_DATA_ROW_NUMBER" '2');
> ]]> </metadata>
> </model>
> {code}
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 7 months