Hello,
if i want profiles some tables by searching exact match with this regular expression
\b[C][o][l][o][m][b][o]\b the job returns without errors but doesn't match anything at data level.
But if i query directly that same regular expression returns some data
Luigi
-
622 Points
Posted 2 years ago
-
5,234 Points
It's a syntax type in my advice.
You're looking to profile value "Colombo", i suggest to change the regexp to spmething like
([C][o][l][o][m][b][o])
You can find some good samples here https://docs.delphix.com/pages/viewpa...
Regards,
Mouhssine
-
622 Points
-
622 Points
Hi Mouhssine,
also if i specify that synatx for catch the name Delphix profiler doesn't recognize it.
Neither if i edit ruleset with sql filter that match only one row containing that string.
Probably the skewed distribution of the name value in the column or probabily the relative position of the name in the column field that requires multiline matching regular expression.
Also is strange in general that profiling job returns succeeded without produce results as in this case and returns failed but with profiling report compiled.
Luigi
-
622 Points
Hello,
I have solved my problem.
The job status failed was due to setting to twenty the number of streams dedicated to profile job.
Now i have updated it to two and jobs have succeeded.
Also the search for exact match produce result
Thank you for your attention.
I would like to know the value of parameter NO_OF_ROWS that is read by kettle to determine the subset row to profile for each tables in rule set. This parameter could impact the profile job activity
Luigi
-
1,578 Points
Thank you
Gianpiero
-
5,234 Points
You have to contact support that will help you with that, I think they will provide and load a new configuration masking file to define this.
Regards,
Mouhssine
-
5,234 Points
Glad that's it working now.
But just to my personal known what matching regexp did you use yours or the one provided by me.
Regards,
Mouhssine
-
622 Points
Hello i used this expression
([cC][oO][lL][oO][mM][bB][oO]|[fF][eE][rR][rR][aA][rR][iI]|[rR][oO][sS][sS][iI]|[bB][iI][aA][nN][cC][hH][iI]|[sS][aA][lL][aA]|[vV][iI][lL][lL][aA]|[cC][aA][tT][tT][aA][nN][eE][oO]|[bB][rR][aA][mM][bB][iI][lL][lL][aA]|[rR][iI][vV][aA]|[fF][uU][mM][aA][gG][aA][lL][lL][iI]|[gG][aA][lL][lL][iI]|[lL][oO][cC][aA][tT][eE][lL][lL][iI]|[pP][oO][zZ][zZ][iI]|[mM][aA][rR][iI][aA][nN][iI]|[rR][oO][tT][aA]|[gG][aA][tT][tT][iI]|[bB][eE][rR][eE][tT][tT][aA]|[bB][aA][rR][bB][iI][eE][rR][iI]|[pP][aA][gG][aA][nN][iI]|[fF][eE][rR][rR][aA][rR][iI][oO])
Regards,
Luigi
-
5,234 Points
Okay, so there is no \b and the expression is a variante of the one provided. Great
Regards,
Mouhssine
Related Categories
-
Delphix Masking
- 205 Conversations
- 64 Followers