Kua whakaurua mai e Google a Logica, he reo hōtaka arorau hou kua hangaia mō te whakahaere raraunga e whakamāori ana i ngā kaupapa ki te SQL. Ko te reo hou e aro ana ki te hunga e hiahia ana ki te whakamahi i te wetereo hōtaka arorau i te wā e tuhi ana i ngā patai pātengi raraunga. I tēnei wā, ka taea te whakahaere i te waehere SQL e puta mai ana i roto i a Google BigQuery, i roto rānei i ngā pātengi raraunga PostgreSQL me SQLite, ahakoa he whakamātautau tonu te tautoko mō ēnei. Kei te whakamaheretia ētahi atu reo SQL mō te heke mai. Kua tuhia te waehere o te kaupapa ki te Python, ā, kua whakaputaina i raro i te raihana Apache 2.0.
Ka hangaia a Logica i runga i a Yedalog, tētahi atu reo tukatuka raraunga i whakawhanakehia e Google, ā, ka whakaratohia he taumata o te whakarāpopototanga kāore e wātea ana i roto i te SQL taketake. Ka whakaritea ngā patai i roto i te Logica hei huinga o ngā tauākī arorau. Ka tautokona ngā kōwae, ngā mahi kawemai, me te kaha ki te whakamahi i te Logica mai i roto i te anga taunekeneke Jupyter Notebook. Hei tauira, hei whakaputa i tētahi whakarāpopototanga o ngā tāngata e whakahuatia pinepinetia ana i roto i ngā purongo i te tau 2020, ka taea e koe te whakamahi i te kaupapa Logica e whai ake nei hei uru atu ki te pātengi raraunga GDELT: @OrderBy(Mentions, "mentions desc"); @Limit(Mentions, 10); Mentions(person:, mentions? += 1) distinct :- gdelt-bq.gdeltv2.gkg(persons:, date:), Substr(ToString(date), 0, 4) == "2020", the_persons == Split(persons, ";"), person in the_persons; $ logica mentions.l run Mentions +—————-+—————-+ | person | mentions_count | +—————-+—————-+ | Donald Trump | 3077130 | | Los Angeles | 1078412 | | Joe Biden | 1054827 | | George Floyd | 872919 | | Boris Johnson | 674786 | | Barack Obama | 438181 | | Vladimir Putin | 410587 | | Bernie Sanders | 387383 | | Andrew Cuomo | 345462 | | Las Vegas | 325487 | +—————-+—————-+
Ko te tuhi i ngā patai SQL uaua me tuhi i ngā mekameka maha-rārangi uaua e uaua ana ki te mārama, e aukati ana i te whakamahinga anō o ngā wāhanga patai, ā, e uaua ana hoki te tiaki. Ka taea te whakamahi i ngā tirohanga me ngā mahi mō ngā tātaitanga noa, auau i roto i te SQL, engari kāore e tautoko i ngā mahi kawemai, ā, kāore hoki i te ngāwari o ngā reo taumata-tiketike (hei tauira, kāore e taea te tuku i tētahi mahi i roto i tētahi mahi). Mā Logica koe e tito kaupapa mai i ngā poraka arorau iti, e mārama ana, e taea ana te whakamahi anō ka taea te whakamātautau, te hono atu ki ngā ingoa motuhake, me te whakarōpū ki ngā mōkihi e wātea ana hei whakamahi i roto i ētahi atu kaupapa.
Source: opennet.ru
