上一页 1 ··· 4 5 6 7 8 9 10 下一页
摘要: 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 阅读(1234) 评论(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 阅读(440) 评论(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) 编辑
摘要: DescribeDescribe DatabaseDescribe Table/View/ColumnDisplay Column StatisticsDescribe PartitionDescribe DatabaseVersion informationIconAs of Hive 0.7.D... 阅读全文
posted @ 2015-01-24 21:39 JackyKen 阅读(511) 评论(0) 推荐(0) 编辑
摘要: Create/Drop/Grant/Revoke Roles and PrivilegesHive Default Authorization - Legacy Modehas information about these DDL statements:CREATE ROLEGRANT ROLER... 阅读全文
posted @ 2015-01-24 21:38 JackyKen 阅读(850) 评论(0) 推荐(0) 编辑
摘要: Create/Drop/Alter ViewCreate ViewDrop ViewAlter View PropertiesAlter View As SelectVersion informationIconView support is only available in Hive 0.6 a... 阅读全文
posted @ 2015-01-24 21:29 JackyKen 阅读(1135) 评论(0) 推荐(0) 编辑
上一页 1 ··· 4 5 6 7 8 9 10 下一页