select * from td_mldb.NerReplace(
on (select id, txt as orig_txt, txt from ner_input_distilbert_NER)
on (select model from ner_models_tst where model_id = 'distilbert-NER') DIMENSION
on (select tokenizer from ner_tokenizers_tst where tokenizer_id = 'distilbert-NER') DIMENSION
on (select tokenizer as config from ner_model_configurations_tst where tokenizer_id = 'distilbert-NER') DIMENSION
using
Accumulate('id','txt')
ModelOutputTensor('logits')
) a;
*** Query completed. 8 rows found. 2 columns returned.
*** Total elapsed time was 2 seconds.
id 22
txt The job title is Senior Analyst, job type is Full-time, last name PER. IBAN: ORGORG12ORGORGK0000000000000123456, companyname: ORGORGORG. Age: 37, eye color: brown, LOCORGeum address 0xE853c56864A2ebe4576a807D26Fdc4A0ada51919, phone ORGORGORG 353072070237232.
id 17
txt The date of the transaction is 2024-08-07. Date of birth: 1980-03-14. Phone IMEI: 356938035643809. Employer: ORG, job type Full-time, job area: ORG. His LOCLOCLOC address is 0x742d35Cc6634C0532925a3b844Bc454e4438f44e and MAC address is 00:1B:44:11:3A:B7.
id 5
txt Please send the package to Building 7, 300 LOC, LOC, 02111.
id 13
txt PER's city is LOC, and she works for ORGORGORG. Her credit card number is 5555 4444 3333 2222, CVV 456, and the issuer is ORGORGORG. Her LOCLOCLOC address is 0x3f5CE5FBFe3E9af3971dD833D26BA9b5C936f0bE, and she also uses a MISCORGMISCn address MQMcJhpWHYVeQArcZR3sBgyPZxxRtnH441.
id 24
txt Masked number: **** **** **** 1234, middle name PER, nearby GPS coordinate 40.7128,-74.0060. Credit card number: 4000 1234 5678 9010, CVV 888, BIC: BOFAUS3N, currency: USD, currency code: USD, amount: 300.00, city: LOC.
id 11
txt Account name: PER, account number 192837465, age 34. Please send $12,500.00 to ORGORG DEORGORGORGORGORGORG. PER was born on 1989-02-14 and currently lives in building number 17, LOC, LOC. His email is michael.rogers@example.com and his IBAN is DE89370400440532013000.
id 3
txt Dr. PER lives at 45LOC LOC, LOC, 12345.
id 9
txt PER's credit card (3714 496353 98431) is linked to her social number 678-90-1234.