topic Re: Mysql select - get data by json_extract in Talend Studio

Mysql select - get data by json_extract

Anonymous — Tue, 25 Feb 2020 19:24:39 GMT

Hello,

how do I get the result from a json object with json_extract in a mysql select?

My example code:

{"price":"19.99"}

select
 a.id,
 a.name,
 JSON_EXTRACT(aa.details, '\"$.price\"') AS JsonAttr,
from article as a
left join article_attributes AS aa ON a.id = aa.articleId

best regards

Re: Mysql select - get data by json_extract

manodwhb — Wed, 26 Feb 2020 07:37:41 GMT

@torbre , do you want to extract the json fields from mysql table? then use tExtractJson after the tDBInput component.

Re: Mysql select - get data by json_extract

Anonymous — Wed, 26 Feb 2020 10:21:38 GMT

Hello,

@manodwhb,

Yes, I want to extract the JSON from the db cloumn. Actually, I wanted to avoid another component, since you can extract the data in select using JSON_EXTRACT. My question would still be, why is it not possible to extract the data like this via a select in tMysqlInput?

My Solution: I now extract the data using Java code.

Thank you for your prompt reply

Best regards