[JBoss JIRA] (TEIID-3259) dynamic sql cannot use into with updates
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-3259:
-------------------------------------
Summary: dynamic sql cannot use into with updates
Key: TEIID-3259
URL: https://issues.jboss.org/browse/TEIID-3259
Project: Teiid
Issue Type: Quality Risk
Components: Query Engine
Affects Versions: 8.9
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.10
TEIID-3198 refined the dynamic sql handling such that the use of AS columns required a result set from the query. However our materialization logic in SYSADMIN and our documentation indicated that the approach should be used. We may need to offer backward compatibility and at the very least should update the materialization sql.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
11 years, 3 months
[JBoss JIRA] (TEIID-3073) Tableau Connection Issues
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3073?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3073:
---------------------------------------
Added single line comment support with TEIID-3256
> Tableau Connection Issues
> -------------------------
>
> Key: TEIID-3073
> URL: https://issues.jboss.org/browse/TEIID-3073
> Project: Teiid
> Issue Type: Bug
> Components: ODBC, Server
> Reporter: Ramesh Reddy
> Assignee: Ramesh Reddy
> Fix For: 8.10
>
> Attachments: server.log, server.log, tablue-wireshark.pcapng
>
>
> It has been reported that using Tableu with Teiid ODBC port show the following errors. These need to be investigated and fixed
> {code}
> This ODBC driver does not support important capabilities used by Tableau.
> This unsupported function is required for relative date filters: The date part named 'week' for the date function: DATETRUNC(date_part, date, [start_of_week])
> -----
> Tableau identified the following warnings for the ODBC data source named 'streamyx_sales (streamyx_sales.streamyx_sales) (TMJDV)':
> This aggregation is unsupported: Attribute
> This aggregation is unsupported: Std. Dev
> This aggregation is unsupported: Std. Dev (Pop.)
> This aggregation is unsupported: Trunc Week Number
> This aggregation is unsupported: Variance
> This aggregation is unsupported: Variance (Pop.)
> This function is unsupported: % with parameter types 'integer, integer'
> This function is unsupported: ABS(number) with parameter types 'float'
> This function is unsupported: ABS(number) with parameter types 'integer'
> This function is unsupported: ACOS(number) with parameter types 'float'
> This function is unsupported: ASCII(string) with parameter types 'string'
> This function is unsupported: ASIN(number) with parameter types 'float'
> This function is unsupported: ATAN(number) with parameter types 'float'
> This function is unsupported: ATAN2(y number, x number) with parameter types 'float, float'
> This function is unsupported: CHAR(integer) with parameter types 'float'
> This function is unsupported: CHAR(integer) with parameter types 'integer'
> This function is unsupported: COS(angle) with parameter types 'float'
> This function is unsupported: COT(angle) with parameter types 'float'
> This function is unsupported: DATEPART_DAYOFWEEK_INTERNAL with parameter types 'date'
> This function is unsupported: DATEPART_WEEK_INTERNAL with parameter types 'date'
> This function is unsupported: DATETIME with parameter types 'integer'
> This function is unsupported: DEGREES(number) with parameter types 'float'
> This function is unsupported: EXP(number) with parameter types 'float'
> This function is unsupported: LN with parameter types 'float'
> This function is unsupported: LN(number) with parameter types 'float'
> This function is unsupported: LOG with parameter types 'float'
> This function is unsupported: LOG(number, [base]) with parameter types 'float'
> This function is unsupported: PI()
> This function is unsupported: POWER with parameter types 'float, integer'
> This function is unsupported: POWER with parameter types 'integer, integer'
> This function is unsupported: POWER(number,power) with parameter types 'float, integer'
> This function is unsupported: POWER(number,power) with parameter types 'integer, integer'
> This function is unsupported: RADIANS(number) with parameter types 'float'
> This function is unsupported: ROUND(number, [decimals]) with parameter types 'float'
> This function is unsupported: ROUND(number, [decimals]) with parameter types 'float, integer'
> This function is unsupported: SIGN(number) with parameter types 'float'
> This function is unsupported: SIN(angle) with parameter types 'float'
> This function is unsupported: SPACE with parameter types 'float'
> This function is unsupported: SPACE(number) with parameter types 'integer'
> This function is unsupported: SQRT(number) with parameter types 'float'
> This function is unsupported: SQUARE with parameter types 'float'
> This function is unsupported: TAN(angle) with parameter types 'float'
> This function is unsupported: The date part named 'week' for the date function: DATEDIFF(date_part, start_date, end_date, [start_of_week])
> This function is unsupported: The date part named 'week' for the date function: DATEDIFF(date_part, start_date, end_date, [start_of_week])
> This function is unsupported: The date part named 'week' for the date function: DATENAME(date_part, date, [start_of_week])
> This function is unsupported: The date part named 'week' for the date function: DATENAME(date_part, date, [start_of_week])
> This function is unsupported: The date part named 'week' for the date function: DATEPART(date_part, date, [start_of_week])
> This function is unsupported: The date part named 'week' for the date function: DATEPART(date_part, date, [start_of_week])
> This function is unsupported: The date part named 'weekday' for the date function: DATENAME(date_part, date, [start_of_week])
> This function is unsupported: The date part named 'weekday' for the date function: DATENAME(date_part, date, [start_of_week])
> This function is unsupported: The date part named 'weekday' for the date function: DATEPART(date_part, date, [start_of_week])
> This function is unsupported: The date part named 'weekday' for the date function: DATEPART(date_part, date, [start_of_week])
> This is unsupported: SELECT ... INTO
> This is unsupported: Temporary tables
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
11 years, 3 months
[JBoss JIRA] (TEIID-3255) Support PicketBox / XACML authorization
by John Muller (JIRA)
John Muller created TEIID-3255:
----------------------------------
Summary: Support PicketBox / XACML authorization
Key: TEIID-3255
URL: https://issues.jboss.org/browse/TEIID-3255
Project: Teiid
Issue Type: Feature Request
Components: OData
Affects Versions: 8.9
Reporter: John Muller
Assignee: Steven Hawkins
We would like the OData, OData4, JDBC, and ODBC transports of Teiid to act as an XACML policy enforcement point for all CRUD operations (as well as execute stored procedures). Looking through old JIRAs:
https://issues.jboss.org/browse/TEIID-1031
it looks like this was considered back in the mid-2010 timeframe, but wasn't fully thought through. With XACML 3.0, it's possible to use Multiple Decision Profile to get all policy decisions for a given user / resource (or just everything for a user for multiple resources). Our idea here is to have Teiid set the action to be one of (SELECT|INSERT|UPDATE|DELETE|CREATE|DROP|EXECUTE) and the resource to be the fully qualified table (vdbName, SchemaName, TableName) plus a map of projected columns by the query. While this doesn't solve row-based restrictions, it would solve column / object based restrictions. MDP could be used to get policy decisions for all objects under a given schema.
Thoughts?
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
11 years, 3 months
[JBoss JIRA] (TEIID-3073) Tableau Connection Issues
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3073?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3073:
---------------------------------------
I've addressed the ON COMMIT clause error. In think we can do SET SESSION CHARACTERISTICS as well. But it will take more digging to see what's wrong with the aggregate queries and I don't think we'll want to add support for TOP n.
> Tableau Connection Issues
> -------------------------
>
> Key: TEIID-3073
> URL: https://issues.jboss.org/browse/TEIID-3073
> Project: Teiid
> Issue Type: Bug
> Components: ODBC, Server
> Reporter: Ramesh Reddy
> Assignee: Ramesh Reddy
> Fix For: 8.10
>
> Attachments: server.log, server.log, tablue-wireshark.pcapng
>
>
> It has been reported that using Tableu with Teiid ODBC port show the following errors. These need to be investigated and fixed
> {code}
> This ODBC driver does not support important capabilities used by Tableau.
> This unsupported function is required for relative date filters: The date part named 'week' for the date function: DATETRUNC(date_part, date, [start_of_week])
> -----
> Tableau identified the following warnings for the ODBC data source named 'streamyx_sales (streamyx_sales.streamyx_sales) (TMJDV)':
> This aggregation is unsupported: Attribute
> This aggregation is unsupported: Std. Dev
> This aggregation is unsupported: Std. Dev (Pop.)
> This aggregation is unsupported: Trunc Week Number
> This aggregation is unsupported: Variance
> This aggregation is unsupported: Variance (Pop.)
> This function is unsupported: % with parameter types 'integer, integer'
> This function is unsupported: ABS(number) with parameter types 'float'
> This function is unsupported: ABS(number) with parameter types 'integer'
> This function is unsupported: ACOS(number) with parameter types 'float'
> This function is unsupported: ASCII(string) with parameter types 'string'
> This function is unsupported: ASIN(number) with parameter types 'float'
> This function is unsupported: ATAN(number) with parameter types 'float'
> This function is unsupported: ATAN2(y number, x number) with parameter types 'float, float'
> This function is unsupported: CHAR(integer) with parameter types 'float'
> This function is unsupported: CHAR(integer) with parameter types 'integer'
> This function is unsupported: COS(angle) with parameter types 'float'
> This function is unsupported: COT(angle) with parameter types 'float'
> This function is unsupported: DATEPART_DAYOFWEEK_INTERNAL with parameter types 'date'
> This function is unsupported: DATEPART_WEEK_INTERNAL with parameter types 'date'
> This function is unsupported: DATETIME with parameter types 'integer'
> This function is unsupported: DEGREES(number) with parameter types 'float'
> This function is unsupported: EXP(number) with parameter types 'float'
> This function is unsupported: LN with parameter types 'float'
> This function is unsupported: LN(number) with parameter types 'float'
> This function is unsupported: LOG with parameter types 'float'
> This function is unsupported: LOG(number, [base]) with parameter types 'float'
> This function is unsupported: PI()
> This function is unsupported: POWER with parameter types 'float, integer'
> This function is unsupported: POWER with parameter types 'integer, integer'
> This function is unsupported: POWER(number,power) with parameter types 'float, integer'
> This function is unsupported: POWER(number,power) with parameter types 'integer, integer'
> This function is unsupported: RADIANS(number) with parameter types 'float'
> This function is unsupported: ROUND(number, [decimals]) with parameter types 'float'
> This function is unsupported: ROUND(number, [decimals]) with parameter types 'float, integer'
> This function is unsupported: SIGN(number) with parameter types 'float'
> This function is unsupported: SIN(angle) with parameter types 'float'
> This function is unsupported: SPACE with parameter types 'float'
> This function is unsupported: SPACE(number) with parameter types 'integer'
> This function is unsupported: SQRT(number) with parameter types 'float'
> This function is unsupported: SQUARE with parameter types 'float'
> This function is unsupported: TAN(angle) with parameter types 'float'
> This function is unsupported: The date part named 'week' for the date function: DATEDIFF(date_part, start_date, end_date, [start_of_week])
> This function is unsupported: The date part named 'week' for the date function: DATEDIFF(date_part, start_date, end_date, [start_of_week])
> This function is unsupported: The date part named 'week' for the date function: DATENAME(date_part, date, [start_of_week])
> This function is unsupported: The date part named 'week' for the date function: DATENAME(date_part, date, [start_of_week])
> This function is unsupported: The date part named 'week' for the date function: DATEPART(date_part, date, [start_of_week])
> This function is unsupported: The date part named 'week' for the date function: DATEPART(date_part, date, [start_of_week])
> This function is unsupported: The date part named 'weekday' for the date function: DATENAME(date_part, date, [start_of_week])
> This function is unsupported: The date part named 'weekday' for the date function: DATENAME(date_part, date, [start_of_week])
> This function is unsupported: The date part named 'weekday' for the date function: DATEPART(date_part, date, [start_of_week])
> This function is unsupported: The date part named 'weekday' for the date function: DATEPART(date_part, date, [start_of_week])
> This is unsupported: SELECT ... INTO
> This is unsupported: Temporary tables
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
11 years, 3 months
[JBoss JIRA] (TEIID-3216) Implement INSERT, UPDATE and DELETE support for google-spreadsheet connector
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3216?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-3216.
-----------------------------------
Resolution: Done
Marking as initially resolved. Also logged TEIID-3254 to cover refinements to capabilities.
> Implement INSERT, UPDATE and DELETE support for google-spreadsheet connector
> ----------------------------------------------------------------------------
>
> Key: TEIID-3216
> URL: https://issues.jboss.org/browse/TEIID-3216
> Project: Teiid
> Issue Type: Enhancement
> Components: Misc. Connectors
> Reporter: Filip Elias
> Assignee: Filip Elias
> Fix For: 8.10
>
>
> Current plan is to use list-based feed of the Google Data API[1].
> There are three known issues:
> performance - to delete/update 100 rows Teiid must generate 100 http requests
> consistency - user wants to update 50 rows. After the 10th row is updated the connection could fail which would cause that 10 rows would be updated and 40 wouldn't.
> headers - update, delete and and insert statements will be supported only for the spreadsheets that have a header for each column (headers are in the first row of a spreadsheet)
> Select statement is implemented using Google Visualisation API, but this API doesn't support updates and doesn't return row numbers.
> [1] https://developers.google.com/google-apps/spreadsheets/
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
11 years, 3 months