摘要：
Sampling SyntaxSampling Bucketized TableBlock SamplingSampling Syntax 抽样语法Sampling Bucketized Tabletable_sample: TABLESAMPLE (BUCKET x OUT OF y [ON co... 阅读全文
摘要：
Subqueries in the FROM ClauseSubqueries in the WHERE ClauseSubqueries in the FROM ClauseSELECT...FROM(subquery)name...SELECT...FROM(subquery)ASname...... 阅读全文
摘要：
Lateral View SyntaxDescriptionExampleMultiple Lateral ViewsOuter Lateral ViewsLateral View SyntaxlateralView: LATERAL VIEW udtf(expression) tableAlias... 阅读全文
摘要：
Union Syntaxselect_statement UNION ALL select_statement UNION ALL select_statement ...UNION is used to combine the result from multiple SELECT stateme... 阅读全文
摘要：
Join OptimizationJoin OptimizationImprovements to the Hive OptimizerStar Join OptimizationStar Schema ExamplePrior Support for MAPJOINLimitations of P... 阅读全文
摘要：
Hive JoinsHive JoinsJoin SyntaxExamplesMapJoin RestrictionsJoin OptimizationPredicate Pushdown in Outer JoinsEnhancements in Hive Version 0.11Join Syn... 阅读全文
摘要：
Documentation for Built-In User-Defined Functions Related To XPathUDFsxpath, xpath_short, xpath_int, xpath_long, xpath_float, xpath_double, xpath_numb... 阅读全文
摘要：
Hive Operators and User-Defined Functions (UDFs)Hive Operators and User-Defined Functions (UDFs)Built-in OperatorsRelational OperatorsArithmetic Opera... 阅读全文
摘要：
Transform/Map-Reduce SyntaxSQL Standard Based Authorization Disallows TRANSFORMTRANSFORM ExamplesSchema-less Map-reduce ScriptsTyping the output of TR... 阅读全文
摘要：
Syntax of Order BySyntax of Sort ByDifference between Sort By and Order BySetting Types for Sort BySyntax of Cluster By and Distribute BySyntax of Ord... 阅读全文