01966nam a22002297a 4500001001200000003000400012005001700016006001900033007001200052008004100064020003000105020002600135040000800161100002400169245008000193250001800273260007200291300001700363520129700380650003701677700002201714WIIW0000170OSt20190802143800.0a|||||q|||||00| 0 c| ||||||||190802t2018       |||||q|||||00| 0 eng d  a978-1-4920-3277-9qE-Book  a1-4920-3277-8qE-Book  cOSt1 aGivre, Charles4aut10aLearning Apache Drill.bQuery and analyze distributed data sources with SQL  aFirst edition 1aBeijingaBostonaFarnhamaSebastopolaTokyobO'ReillycOctober 2018  a313 S.bIll.  aGet up to speed with Apache Drill, an extensible distributed SQL query engine that reads massive datasets in many popular file formats such as Parquet, JSON, and CSV. Drill reads data in HDFS or in cloud-native storage such as S3 and works with Hive metastores along with distributed databases such as HBase, MongoDB, and relational databases. Drill works everywhere: on your laptop or in your largest cluster.In this practical book, Drill committers Charles Givre and Paul Rogers show analysts and data scientists how to query and analyze raw data using this powerful tool. Data scientists today spend about 80% of their time just gathering and cleaning data. With this book, you'll learn how Drill helps you analyze data more effectively to drive down time to insight.Use Drill to clean, prepare, and summarize delimited data for further analysisQuery file types including logfiles, Parquet, JSON, and other complex formatsQuery Hadoop, relational databases, MongoDB, and Kafka with standard SQLConnect to Drill programmatically using a variety of languagesUse Drill even with challenging or ambiguous file formatsPerform sophisticated analysis by extending Drill's functionality with user-defined functionsFacilitate data analysis for network security, image metadata, and machine learning  aData Analyses & Machine Learning1 aRogers, Paul4aut