...
"more
" can take any kind of expressions in the SELECT clause, including UDFs.
(UDTFs and lateral views are not yet supported – see HIVE-5718.)
hive.map.groupby.sorted
- Default Value:
- Hive 0.x and 1.x:
false
- Hive 2.0 and later:
true
(HIVE-12325)
- Hive 0.x and 1.x:
- Added In: Hive 0.10.0 with HIVE-3432
If the bucketing/sorting properties of the table exactly match the grouping key, whether to perform the group by in the mapper by using BucketizedHiveInputFormat. The only downside to this is that it limits the number of mappers to the number of files.
hive.map.groupby.sorted.testmode
- Default Value:
false
- Added In: Hive 0.11.0 with HIVE-4281
- Removed In: Hive 2.0.0 with HIVE-12325
If the bucketing/sorting properties of the table exactly match the grouping key, whether to perform the group by in the mapper by using BucketizedHiveInputFormat. If the test mode is set, the plan is not converted, but a query property is set to denote the same. (This configuration property was removed in release 2.0.0.)
hive.groupby.orderby.position.alias
...