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

질문됨 2년 전69회 조회
답변 없음

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠