¡Descarga Flume laboratorio flume en big data y más Ejercicios en PDF de Estadística solo en Docsity! LAB PARTITION DATA Eddison Andres Gil Pinilla David Jesus Falla Maestría en Ingeniería y Analítica de Datos Create a new, empty table in Impala or Hive: CREATE EXTERNAL TABLE accounts_by_areacode ( acct_num INT, first_name STRING, last_name STRING, phone_number STRING) PARTITIONED BY (areacode STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' LOCATION '/loudacre/accounts_by_areacode'; clouders-traimrg-==osparkudentrav_cahis 33 - Viwsre Workstation 15 Player (Non-=ommercial ue cal) EA 157 E suniarzs, sismu NETA EE Mueve EQU Ll UE Mete an | €) catas: vuubrcsuenteque 0 [E coge aros al= Esmostvisitedo [Bcioudera élue (YARNIRI E isparkUl (local) sperk Doc Solr Acmin Ul Kie SEK Doc. ONES “y Hive Editor — Query Editor Queres — Saved Queries HstOy DATABASE 2e ete » AAA E FIELDS TEREIMATED ey 38 O EOCARLON o louascra webpage" Smeas. Epiain | Creen | nen que Recentousres | Query Log Columns Results Cm + me Que Rosal (9 Fnclox aalormalicall sens some lla Lo Mozila sa: hal we can impaave ji experience, TA) É cloudera-trainirg-capspark-sudent-rew_cdh3 £ 3a - VMware Workstation 15 Player (Non-commercial use cnly). 3 mE - dE alicia ayer O E nao Maos corra ATA Hue HiveLditor- Query / el llue Metestore Men... x le Hue Job romSer | Golocalvast crerableriefaulaccouns, by_areecode ye [Bv coge aros n= Esmost visited» [Bicicudera éfttue (van ne E ispark Ul (local) Isperk Doc solr Acmin Ul (Kie SDK Doc. CET EE [ile Browser 2300 [E Metastore Manager acnone Databases > default > accounts_by. O imperibata Galas | PonmoncaZ0 Sampo — repenes worse Data time Te Coment Dres Table a acom m Avi Estaca meme cr . soma esto Parts (20) 3 omg a song Hue Metastere Mano.. 2. In order to populate the new table, you will need to extract the area code from the phone number. Use a SELECT statement to extract the area code in an INSERT INTO TABLE command to copy the specified columns to the new table, dynamically partitioning by area code. Realizamos la búsqueda para extraer el areacode: Query: SELECT substr(phone_number, 1,3)AS areacode FROM accounts_avro1; El cloudera-tsinirg-=aosparlesudentras.cah33a - Viwere Workstation 15 Player (Non-=ommercial use cal) 25 Par dEl a live Editor- Query x | ely llue - Metastore Man... « / H é-) localhost conaJabramser ve [Bv coge spark Doc Ke SDK DOC. NS same Sutus Ur Mage Roducos < Queve Peri * Dusalon $ Suimited TINTO TABLE waiving [00 | retlaiing A As 916.08.19 a sana E I5SIO7OVO!_0) cra. ca cniStago E TS ME ocio rn ts > AS pora aros o AS AS vi E iii E I5SIO7OVO!_0) tra EI 09 MICA o ra sa LS money MEE E sm SEIECTA ccoumts_ al. amy E ISSISIOTODO!_0)01 SELECT 0 ACCOUS aMOL.2 procestage=) 9122900 rg ages Hue job arcuser Mo.) Ea 3. Execute a simple query to confirm that the table was populated correctly, such as Query: SELECT * FROM accounts_by_areacode LIMIT 10 e Ll é-) Olocalhost co0a/beesesyexecute/query, Esmost visites» [Blctcudera etue CE Gs Hive Editor 1 sorgS DATABASE se Hue Hlve Editor Gu. ] cloudera-tsinirg-=aosparlesudentras.cah33a - Viwere Workstation 15 Player (Non-=ommercial use cal) 3 Query 0 ly llue= Metestore Man... | a nn aman Query Editor Pasas My Queres Eispark ul ¡Saved Queries "spark Doc“ Isolr Amin UL soy 1) SELECT * FROM acccunts_by areacade LIMIT 18; ec cos Quey Lay counts by arencodeacet num Explain croaxea | Nan quey Fesuls O accounts by arsacodenrst name. Dista st Bojan Pm Mara ve [Bv coge Kite SK Doc COTE BoB accounts by arsacodesast name counts by arescode.pnone numbs FHbroucl cas Sion sosa Lindemann Bay mua Using Hue or the hdfs command line interface, confirm that the directory structure of the accounts_by_areacode table includes partition directories. Review the data in the directories to verify that the partitioning is correct. 3 «coudera-wainirg-capspa lesudentraw.cahi a - VMware Wojistaicn 15 Player (Nor-corwrercial use cl) - Flor En < dE amlications Places Side O ES E voaros, 30m as ive Lditor- Query / ely Hue File sromser a) Hue Metestore Men... x | H) Hue Jcburomser | areecode ve [Br cole ara oe é-) Olocalhost c0n0/tiebromservienjuserza nirgafodacre/accoLris, Esmost visited» [Bicicudera éfttue (van ne E ispark Ul (local) Isperk Doc solr Acmin Ul (Kie SDK Doc. CO - CA KB File Browser 2 tuno si vn rap Pericos NI 000 0.1605 36 Sra araOS pepa a O e ato 0 010035. 1620%n 2 SECA ca a oro 1 acne a acosa o sc cs A cis vag ae BOP cies vag ae BOO aerea pepa a mo acre ca a sor o orcsceeo pa acceso e css A cio vag ae BOP Moe vag ae BOO acne pong pag a moon A me [alo e Hue lle Breuser- A.
