Duration: 3h 30m | Video: h264 1280×720 | Audio: AAC 48kHz 2Ch | 1.3 GBGenre: eLearning | Language: English | 19 Aug 2019LearnHive IntroExternal & Managed TablesInsert & Multi InsertData Types & Complex Data TypesCollection FunctionConditional FunctionHive String FunctionsHive Date FunctionsMathematical FunctionHive AnalysisAlter CommandJoins, Multi Joins & Map JoinsWorking with Different Files – Parquet, AvroCompressionsAboutThis course will prepare you for advanced Hive and get you ready to take the CCA159 (Cloudera Big Data Analyst) certificationYou will start by learning what Hadoop and its distributed file system are and you’ll master the most common Hadoop commands you’ll need to work with Hadoop file systems. Then we explore the Apache Hive [Advanced]:Hive introExternal and managed tablesInsert and multi insertData types and complex data typesCollection functionConditional functionHive string functionsHive date functionsMathematical functionsHive analysisThe Alter commandJoins, multi joins, and map JoinsWorking with different files: Parquet and AvroCompressionPartitioningBucketingViewsLateral Views/ExplodeWindowing functions – Rank/Dense Rank/lead/lag/min/maxWindow specificationAll the codes and supporting files are available at:FeaturesMaster advanced Hive and Sqoop for big data analytics and ingestionMaster advanced Hive and prepare for the CCA159 (Cloudera Big Data Analyst) certification