topic Re: MySql Query not returning any data in Data Quality

MySql Query not returning any data

Anonymous — Sat, 16 Nov 2024 05:55:20 GMT

Hello All, I did tried to load the data from mysql using yMySqlRow component.

Query:-

"SELECT
`table`.`empID`,
`table`.`fromDate`,
`table`.`toDate`,
TIME_FORMAT(STR_TO_DATE(`table`.`fromTime`, '%H%i'), '%h:%i %p'),
`table`.`toTime`
FROM `table`"

here fromTime column values are in hh:mm am/pm(ex: 9:00 am) varchar data type.

So while loading the data i was trying to change the column data type into time(HH:MMS AM/PM)

But it is not returning any data.

Output:-

||||
[statistics] disconnected

i did tried the another way also of sql query.

"SELECT
`table`.`empID`,
`table`.`fromDate`,
`table`.`toDate`,
CAST(`table`.`fromTime`, '%H%i'),
`table`.`toTime`
FROM `table`"

strill returing the same output.

Any help please.

Mohan V.

Re: MySql Query not returning any data

vapukov — Sun, 05 May 2019 10:52:47 GMT

Hi,

tMySQLRow does not return the data unless you do not use additional components

just use tDBInput for input

Re: MySql Query not returning any data

Anonymous — Sun, 05 May 2019 15:15:44 GMT

@vapukov thanks for the reply.

Yes i did used the tDBinput and connected to tMySqlRow.

then when i tried to execute this i was not able to get any output.

can you please help me.