You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2014-04-17 08:45:37

driesnuyts
Member
41 posts

driesnuyts said:

[resolved] Query changes from SQL to Regex pattern when drilling down data

Hi,

I'm using SQL patterns to check if an URL is correct. When I execute the analysis I get the correct statistics, when I hover over the pattern in the analysis settings Talend shows me the right query.

Now here is the thing that confuses me. When I want to check the invalid/valid values Talend changes the query in the SQL editor to a REGEXP_LIKE where it should be LIKE.

How should I fix this?

Thanks

Dries
mini_132748_analysis_settings.pngmini_132748_sql_editor.png

Last edited by driesnuyts (2014-04-17 09:16:27)

Offline

#2 2014-04-17 09:03:10

xdshi
Talend Team


xdshi said:

Re: [resolved] Query changes from SQL to Regex pattern when drilling down data

Hi,

You can upload your screenshots by Talend Image Upload Section that allows to upload screen captures and images up to 200KB(20 images per post, each image must be less then 1024x768 pixels and 200 KB, .png is preferred)
This would be easier for you and more convenient for other users than pasting urls.

Could you indicate the talend product build version you're using so that we can have a look at it.

Best regards
Sabrina


What we can do is to make sure that Talend will be your best choice!

Offline

#3 2014-04-17 09:15:46

driesnuyts
Member
41 posts

driesnuyts said:

Re: [resolved] Query changes from SQL to Regex pattern when drilling down data

Hi

I'm currently using Talend Platform - Universal. Version 5.4.1 Buildid: r111943.

Kind regards

Dries

Offline

#4 2014-04-17 09:41:26

xdshi
Talend Team


xdshi said:

Re: [resolved] Query changes from SQL to Regex pattern when drilling down data

Hi driesnuyts,

I have re-directed it to Talend DQ manager to see if it is a bug then come back to you asap.
Thanks for reporting it to us.

Best regards
Sabrina


What we can do is to make sure that Talend will be your best choice!

Offline

#5 2014-04-17 10:27:00

scorreia
Talend Team


scorreia said:

Re: [resolved] Query changes from SQL to Regex pattern when drilling down data

Hi

that's a bug. Could you raise an issue in our bugtracker at https://jira.talendforge.org please?


Thank you for your support,
Sebastiao Correia.

Offline

#6 2014-04-17 10:55:03

driesnuyts
Member
41 posts

driesnuyts said:

Re: [resolved] Query changes from SQL to Regex pattern when drilling down data

Hi

Thanks for the reply. I submitted the bug.

This is the url: https://jira.talendforge.org/browse/TDQ-8864

Kind regards

Dries

Offline

#7 2014-04-22 06:34:50

Sanjay Tiwari
Member
11 posts

Sanjay Tiwari said:

Re: [resolved] Query changes from SQL to Regex pattern when drilling down data

Hi,
I have a job created on one server and i want to execute that job on another server using REST/SOAP API.I don't want to execute that job using IDE(Such as Ecclipse).
So my question is
1)Is it possible to perform above action defined?
2) If yes,then how? please provide me solution.Screenshots would be much helpful and appreciated.

With Regards
Sanjay Tiwari

Offline

#8 2014-04-22 06:59:48

xdshi
Talend Team


xdshi said:

Re: [resolved] Query changes from SQL to Regex pattern when drilling down data

Hi,

Your problem isn't related to this topic.
Please stick to your another topic [Forum 35691:topic Running Talend Job Created on one Server to Another Server ].

Best regards
Sabrina


What we can do is to make sure that Talend will be your best choice!

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy