You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
- Index
- » Talend Open Studio for Data Quality and Talend Enterprise Data Quality » Configuration, usage and feedback
- » Invalid SQL syntax on "View invalid rows" for "PATTERN MATCHING" TOP
#1 2011-11-21 16:37:55
- GillesDurozoi
- New member
- Registered: 2011-11-14
- Posts: 4
Invalid SQL syntax on "View invalid rows" for "PATTERN MATCHING" TOP
Configuration : TOP 4.2.3r67267
When trying to watch valid or invalid rows on a Pattern Matching Column Analysis, TOP generates this SQL statement : "SELECT * FROM <table> WHERE null OR <column> IS NULL", causing an error and forcing to edit the SQL statement.
It is the same error when trying to show valid/invalid column(s).
The TOP/Libraries/Indicators/System Indicators/Pattern Matching/Regular_Expression_Matching SQL Template has been correctly coded and tested for my MS SQL Server 2005 DBS : SELECT COUNT(CASE WHEN dbo.REGEXP(<%=__COLUMN_NAMES__%>,<%=__PATTERN_EXPR__%>,0) =1 THEN 1 END), COUNT(*) FROM <%=__TABLE_NAME__%> <%=__WHERE_CLAUSE__%>
I searched but did not find the way to modify the SQL template used for listing the valid/invalid rows or columns.
Any issue ?
Offline
#2 2011-11-24 12:45:55
Re: Invalid SQL syntax on "View invalid rows" for "PATTERN MATCHING" TOP
Hi Gilles,
There is no SQL template used for listing the valid/invalid rows or columns. It's rather done in the Java code and uses the generated query of the indicator.
There may be a problem with that Java code if I read you well.
I suggest that you raise an issue in our bugtracker and a developer will have a deeper look at it. http://jira.talendforge.org
Thank you for your support,
Sebastiao Correia.
Offline
#3 2011-11-29 14:56:33
- GillesDurozoi
- New member
- Registered: 2011-11-14
- Posts: 4
Re: Invalid SQL syntax on "View invalid rows" for "PATTERN MATCHING" TOP
Hi Sebastiao,
Thank you for your answer.
I am not yet granted to raise an issue on the bugtracker (I hope soon).
Anyway, I found another way for listing valid/invalid rows/columns via DQ Rules.
Offline
#6 2011-12-01 16:38:35
- GillesDurozoi
- New member
- Registered: 2011-11-14
- Posts: 4
Re: Invalid SQL syntax on "View invalid rows" for "PATTERN MATCHING" TOP
Thank you, PRGX02.
For Sebastiao : The analysis related in my post was run by DBMS (parameter "Execution Engine" set to "SQL", not "Java"). I don't really know whether that precision is accurate.
NB : When setting "Java" as "Execution Engine", I get an error message "Fail to run this analysis..... Error message : [Microsoft][SQL Native Client]Index de descripteur non valide". (That is not a problem for me as long as DBMS engine is OK).
For your information, it is the same on TALEND OPEN SUITE for DATA QUALITY V5.0.0 I installed today.
Last edited by GillesDurozoi (2011-12-01 16:53:34)
Offline
#7 2011-12-01 18:58:18
Re: Invalid SQL syntax on "View invalid rows" for "PATTERN MATCHING" TOP
Thanks Gilles for the precision. We indeed understand that the analysis is run by the DBMS.
The problem when you select the Java engine is another issue. Do you get this issue with a simple analysis with one Regex indicator?
Thank you for your support,
Sebastiao Correia.
Offline
#8 2011-12-07 13:03:52
- GillesDurozoi
- New member
- Registered: 2011-11-14
- Posts: 4
Re: Invalid SQL syntax on "View invalid rows" for "PATTERN MATCHING" TOP
Hi Sebastiao,
The issue "Execution Engine = Java" get an error message "Fail to run this analysis..... Error message : [Microsoft][SQL Native Client]Index de descripteur non valide" is obtained both with a single column regex pattern analysis or any other simple column analysis such as row count.
My Config : WXP Pro SP3, JVM 1.6.0_20, TOS-DQ 5.0.0.r72978, MS SQL Native Client 2005.90.5000.00
Offline
Pages: 1
- Index
- » Talend Open Studio for Data Quality and Talend Enterprise Data Quality » Configuration, usage and feedback
- » Invalid SQL syntax on "View invalid rows" for "PATTERN MATCHING" TOP