Regex in Athena Match null data whithout raise any error

0

First, I debug my regular expression online through Regex101, and successfully get the data I want. this is my debug url.

My Text STRING:

{"date":"2022-08-01T01:02:46.121911Z","log":"{\"log\":\"2022-08-01 01:02:46.121 [MyScheduler_Worker-9] INFO u001b[0;39m o.jeecg.modules.quartz.service.XpushRemoteService:38u001b[0;39m - push to xPush ,entity = {\"body\":{\"fileName\":\"ExamMonitor0801.xls\",\"attachment\":\"xpush/prod/dingNotifier/BI/d6bd7cd53b1248c4ba55110fda2c3370/0801 all exam monitor.xlsx\",\"userIds\":[\"193960304827593088\",\"28095501311142182\",\"21480733271214119\",\"01454058034930401224\"]},\"appId\":\"OTHERS\",\"topic\":\"BI_MONITOR_REPORT\"}rn\",\"stream\":\"stdout\",\"time\":\"2022-08-01T01:02:46.12183064Z\"}"}

My REGULAR EXPRESSION

\{\"date\":\"([^ ]*)\",\"log\":\"\{\\\"log\\\":\\\"(.+)(?=\\\",\\\"stream)

But When I use this regular expression to create a table in athena.it finally get null data.

Enter image description here

Enter image description here

Enter image description here

  • Were you able to fix this issue, I have similar issue

asked 2 years ago68 views
No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions