Yes, Amazon Athena txhawb ntau cov ntaub ntawv tib yam li Amazon EMR. Athena's data catalog yog Hive metastore tau tshaj.
Cov lus nug twg Athena siv?
Qhib, muaj zog, tus qauv. Amazon Athena siv Presto nrog ANSI SQL kev txhawb nqathiab ua haujlwm nrog ntau hom qauv ntaub ntawv, suav nrog CSV, JSON, ORC, Avro, thiab Parquet. Athena yog qhov zoo tagnrho rau kev ceev, ad-hoc querying tab sis nws kuj tseem tuaj yeem tswj xyuas qhov nyuaj, suav nrog kev koom nrog loj, lub qhov rais ua haujlwm, thiab arrays.
Athena Amazon ua haujlwm li cas?
Athena ua haujlwm ncaj qha nrog cov ntaub ntawv khaws cia hauv S3. Athena siv Presto, faib SQL cav los khiav cov lus nug. Nws kuj tseem siv Apache Hive los tsim, poob, thiab hloov cov ntxhuav thiab cov partitions. … Athena siv ib txoj hauv kev hu ua schema-on-read, uas tso cai rau koj los tsim koj cov schema rau koj cov ntaub ntawv thaum lub sijhawm koj ua cov lus nug.
Athena query RDS?
Prebuilt Athena cov ntaub ntawv sib txuas muaj nyob rau cov ntaub ntawv xws li Amazon CloudWatch Logs, Amazon DynamoDB, Amazon DocumentDB, thiab Amazon RDS, thiab JDBC-raws li cov ntaub ntawv sib raug zoo xws li MySQL, thiab PostgreSQL raws li Apache 2.0 daim ntawv tso cai. Koj tuaj yeem siv Athena Query Federation SDK los sau cov kev cai sib txuas.
Athena siv lub luag haujlwm dab tsi?
Athena tau los ua tus vajtswv poj niam ntawm cov khoom siv tes ua thiab kev ua kom muaj kev thaj yeeb nyab xeeb feem ntau. Nws tau tshwj xeeb yog lub npe hu ua kev txhawb nqa ntawm kev sib tw thiab xaws. Tias nws kawgtau los ua tus neeg paub txog kev txawj ntse thiab kev ncaj ncees yog kev txhim kho ntawm nws txoj kev txhawb nqa ntawm kev txawj ntse.