摘要: Group By SyntaxSimple ExamplesSelect statement and group by clauseAdvanced FeaturesMulti-Group-By InsertsMap-side Aggregation for Group ByGrouping Set... 阅读全文
posted @ 2015-01-25 19:56 JackyKen 阅读(305) 评论(0) 推荐(0) 编辑
摘要: Select SyntaxWHERE ClauseALL and DISTINCT ClausesPartition Based QueriesHAVING ClauseLIMIT ClauseREGEX Column SpecificationMore Select SyntaxGROUP BYS... 阅读全文
posted @ 2015-01-25 19:49 JackyKen 阅读(410) 评论(0) 推荐(0) 编辑
摘要: LanguageManual ImportExportSkip to end of metadataAdded byCarl Steinbach, last edited byLefty Leverenzon May 14, 2013(view change)show commentGo to st... 阅读全文
posted @ 2015-01-25 14:54 JackyKen 阅读(366) 评论(0) 推荐(0) 编辑
摘要: LanguageManual DMLHive Data Manipulation LanguageHive Data Manipulation LanguageLoading files into tablesSyntaxSynopsisNotesInserting data into Hive T... 阅读全文
posted @ 2015-01-25 12:41 JackyKen 阅读(1235) 评论(0) 推荐(0) 编辑
摘要: Archiving for File Count ReductionNote: Archiving should be considered an advanced command due to the caveats involved.Archiving for File Count Reduct... 阅读全文
posted @ 2015-01-25 12:13 JackyKen 阅读(292) 评论(0) 推荐(0) 编辑
摘要: Statistics in HiveStatistics in HiveMotivationScopeTable and Partition StatisticsColumn StatisticsTop K StatisticsImplementationUsageConfiguration Var... 阅读全文
posted @ 2015-01-25 11:38 JackyKen 阅读(441) 评论(0) 推荐(0) 编辑
摘要: DisclaimerPrerequisitesUsers, Groups, and RolesNames of Users and RolesCreating/Dropping/Using RolesCreate/Drop RoleGrant/Revoke RolesViewing Granted ... 阅读全文
posted @ 2015-01-25 10:22 JackyKen 阅读(341) 评论(0) 推荐(0) 编辑