[JBoss JIRA] (TEIIDDES-2388) Add SAP HANA Driver Type
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2388?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2388:
----------------------------------------
Appears deploying the SAP HANA driver jar returns a standard/generic connection URL template property: *jdbc://<host>:<port>*
[~rareddy] The URL template for SqlServer, for instance is: jdbc:sqlserver://<host>:1433;databaseName=<dbName>, however it's <datasource> entry in the standalone.xml config file doesn't reflect this template. Where does the Teiid server get these specific templates?
> Add SAP HANA Driver Type
> ------------------------
>
> Key: TEIIDDES-2388
> URL: https://issues.jboss.org/browse/TEIIDDES-2388
> Project: Teiid Designer
> Issue Type: Feature Request
> Components: Modeling
> Affects Versions: 8.6.1
> Reporter: Ted Jones
> Fix For: 8.6.1, 9.0.1, 9.0
>
>
> Need to add the SAP HANA driver to our list of drivers. The URL should be "jdbc:sap://{host:port}"
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
11 years, 5 months
[JBoss JIRA] (TEIIDDES-2383) Transformation editor removes cache hint in SQL
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2383?page=com.atlassian.jira.plu... ]
Steven Hawkins commented on TEIIDDES-2383:
------------------------------------------
Non-hint comments are ignored yes - and most of our hints are positional. So if a hint is in the wrong spot it would get ignored. These choices are mainly due to the lack of true global referencing in hints (although that has changed somewhat), not capturing a complete ast, etc.
> Transformation editor removes cache hint in SQL
> -----------------------------------------------
>
> Key: TEIIDDES-2383
> URL: https://issues.jboss.org/browse/TEIIDDES-2383
> Project: Teiid Designer
> Issue Type: Bug
> Components: Transformations
> Affects Versions: 8.6, 9.0
> Reporter: Jan Stastny
>
> When adding a comment in transformation editor, the comment disappears after saving its content. It happens with any comment. This disables usage of cache hints.
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
11 years, 5 months
[JBoss JIRA] (TEIIDDES-2389) Add ui support for whole texttable no trim
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2389?page=com.atlassian.jira.plu... ]
Steven Hawkins updated TEIIDDES-2389:
-------------------------------------
Description:
TEIID-3167 allows for NO TRIM to be specified against the whole texttable regardless of whether it is fixed width or delimited. If delimited, then unqualified entries will not be trimmed. For example:
a , "b"
would be parsed as
a ,b - such that the space is preserved after a, but the qualified entry is unaffected.
was:
In case of Delimited text files, currently, we always TRIM the input data.
The enhancement request is to make this behaviour configurable, and let user determine, whether the leading or trailing spaces for the column text should be trimmed or not.
Refer thread https://developer.jboss.org/message/905658?et=watches.email.thread#905658 for complete background discussion.
Assignee: (was: Steven Hawkins)
> Add ui support for whole texttable no trim
> ------------------------------------------
>
> Key: TEIIDDES-2389
> URL: https://issues.jboss.org/browse/TEIIDDES-2389
> Project: Teiid Designer
> Issue Type: Enhancement
> Environment: Teiid 8.8.0 Final
> Reporter: Shiveeta Mattoo
> Labels: File-connector, TEXTTABLE, TRIM
>
> TEIID-3167 allows for NO TRIM to be specified against the whole texttable regardless of whether it is fixed width or delimited. If delimited, then unqualified entries will not be trimmed. For example:
> a , "b"
> would be parsed as
> a ,b - such that the space is preserved after a, but the qualified entry is unaffected.
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
11 years, 5 months
[JBoss JIRA] (TEIIDDES-2388) Add SAP HANA Driver Type
by Ted Jones (JIRA)
Ted Jones created TEIIDDES-2388:
-----------------------------------
Summary: Add SAP HANA Driver Type
Key: TEIIDDES-2388
URL: https://issues.jboss.org/browse/TEIIDDES-2388
Project: Teiid Designer
Issue Type: Feature Request
Components: Modeling
Affects Versions: 8.6.1
Reporter: Ted Jones
Fix For: 8.6.1, 9.0.1, 9.0
Need to add the SAP HANA driver to our list of drivers. The URL should be "jdbc:sap://{host:port}"
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
11 years, 5 months
[JBoss JIRA] (TEIIDDES-2383) Transformation editor removes cache hint in SQL
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2383?page=com.atlassian.jira.plu... ]
Barry LaFond edited comment on TEIIDDES-2383 at 11/11/14 10:45 AM:
-------------------------------------------------------------------
[~shawkins] Yes, we've forked the code. Our choice at that time was to not implement cache hints nor comments due to time/resource contraints. I think our plan will be to implement general comments and that should handle this cache hint use-case as well. Looking at your latest doc, I found supported comments for FROM clause (includes after the JOIN keyword). I didn't find any examples for general comments in SQL. Can I assume that they'll be ignored by Teiid's parser/query engine?
was (Author: blafond):
[~shawkins] Yes, we've forked the code. Our choice at that time was to not implement cache hints nor comments due to time/resource contraints. I think our plan will be to implement general comments and that should handle this cache hint use-case as well.
> Transformation editor removes cache hint in SQL
> -----------------------------------------------
>
> Key: TEIIDDES-2383
> URL: https://issues.jboss.org/browse/TEIIDDES-2383
> Project: Teiid Designer
> Issue Type: Bug
> Components: Transformations
> Affects Versions: 8.6, 9.0
> Reporter: Jan Stastny
>
> When adding a comment in transformation editor, the comment disappears after saving its content. It happens with any comment. This disables usage of cache hints.
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
11 years, 5 months
[JBoss JIRA] (TEIIDDES-2383) Transformation editor removes cache hint in SQL
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2383?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2383:
----------------------------------------
[~shawkins] Yes, we've forked the code. Our choice at that time was to not implement cache hints nor comments due to time/resource contraints. I think our plan will be to implement general comments and that should handle this cache hint use-case as well.
> Transformation editor removes cache hint in SQL
> -----------------------------------------------
>
> Key: TEIIDDES-2383
> URL: https://issues.jboss.org/browse/TEIIDDES-2383
> Project: Teiid Designer
> Issue Type: Bug
> Components: Transformations
> Affects Versions: 8.6, 9.0
> Reporter: Jan Stastny
>
> When adding a comment in transformation editor, the comment disappears after saving its content. It happens with any comment. This disables usage of cache hints.
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
11 years, 5 months
[JBoss JIRA] (TEIIDDES-2383) Transformation editor removes cache hint in SQL
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2383?page=com.atlassian.jira.plu... ]
Steven Hawkins commented on TEIIDDES-2383:
------------------------------------------
> But in determining the command it throws away the prepended cache hint.
Unless you have forked the parser, the cache hint would be set on the Command - see getCacheHint and the logic in QueryParser that is setting it.
> Transformation editor removes cache hint in SQL
> -----------------------------------------------
>
> Key: TEIIDDES-2383
> URL: https://issues.jboss.org/browse/TEIIDDES-2383
> Project: Teiid Designer
> Issue Type: Bug
> Components: Transformations
> Affects Versions: 8.6, 9.0
> Reporter: Jan Stastny
>
> When adding a comment in transformation editor, the comment disappears after saving its content. It happens with any comment. This disables usage of cache hints.
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
11 years, 5 months