Google e hlahisitse Logica, e leng puo e ncha e hlakileng ea lenaneo e etselitsoeng ho fetola lintlha tse fetolelang mananeo ho SQL. Puo e ncha e lebisitsoe ho ba batlang ho sebelisa syntax ea lenaneo le utloahalang ha ba ngola lipotso tsa database. Hajoale, khoutu ea SQL e hlahisoang e ka sebelisoa ho Google BigQuery kapa ho PostgreSQL le database tsa SQLite, leha tšehetso bakeng sa tsena e le liteko hajoale. Lipuo tse ling tsa SQL li reriloe bakeng sa nako e tlang. Khoutu ea projeke e ngotsoe ka Python mme e phatlalalitsoe tlasa laesense ea Apache 2.0.
Logica e haha ho Yedalog, puo e 'ngoe ea ts'ebetso ea data e ntlafalitsoeng ho Google,' me e fana ka boemo bo sa fumaneheng ho SQL ea matsoalloa. Lipotso ho Logica li hlophisitsoe joalo ka sete ea lipolelo tse utloahalang. Li-module, ts'ebetso ea ho kenya, le bokhoni ba ho sebelisa Logica ho tsoa ka har'a khetla ea Jupyter Notebook e sebetsanang le eona lia tšehetsoa. Mohlala, ho hlahisa kakaretso ea batho bao ho buuoang ka bona khafetsa litabeng ka 2020, u ka sebelisa lenaneo le latelang la Logica ho fihlella polokelong ea polokelo ea GDELT: @OrderBy(Mentions, "mentions desc"); @Limit(Ho boleloa, 10); Ho boleloa(motho:, o bua ka eng? += 1) ka ho hlaka :- gdelt-bq.gdeltv2.gkg(perss:, date:), Substr(ToString(date), 0, 4) == "2020", the_persons == Arohane(batho, ";"), motho ho_batho; $ logica e bolela.l matha E Bolela +———————+——————-+ | motho | e bolela_bala | +——————+——————-+ | 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 | +——————+——————-+
Ho ngola lipotso tse thata tsa SQL ho hloka ho ngola liketane tse boima tsa mela e mengata eo ho leng thata ho e utloisisa, e sitisang ho sebelisoa hape ha likarolo tsa lipotso, le tlhokomelo e thata. Maikutlo le mesebetsi li ka sebelisoa bakeng sa lipalo tse tloahelehileng, tse iphetang ho SQL, empa ha li tšehetse ts'ebetso ea ho reka kantle ho naha ebile li haelloa ke ho feto-fetoha ha lipuo tsa boemo bo holimo (mohlala, u ke ke ua khona ho fetisa tšebetso ka har'a tšebetso). Logica e u lumella ho etsa mananeo ho tsoa ho li-blocks tse nyane, tse utloisisehang, le tse ka sebelisoang hape tse ka lekoang, tse amanang le mabitso a ikhethileng, 'me tsa hlophisoa ka liphutheloana tse fumanehang bakeng sa ho sebelisoa mererong e meng.
Source: opennet.ru
