Created
November 13, 2017 18:40
-
-
Save ORBAT/a8ea0af881e730522437e9c6e05528a6 to your computer and use it in GitHub Desktop.
presto isue session
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Name | Value | Default | Type | Description | |
| -------------------------------------------+----------------+----------------+---------+------------------------------------------------------------------------------------------------------ | |
| aggregation_operator_unspill_memory_limit | 4MB | 4MB | varchar | Experimental: How much memory can should be allocated per aggragation operator in unspilling process | |
| colocated_join | false | false | boolean | Experimental: Use a colocated join when possible | |
| dictionary_aggregation | true | true | boolean | Enable optimization for aggregations on dictionaries | |
| distributed_index_join | false | false | boolean | Distribute index joins on join keys instead of executing inline | |
| distributed_join | true | true | boolean | Use a distributed join instead of a broadcast join | |
| enable_intermediate_aggregations | false | false | boolean | Enable the use of intermediate aggregations | |
| exchange_compression | true | true | boolean | Enable compression in exchanges | |
| execution_policy | phased | phased | varchar | Policy used for scheduling query tasks | |
| fast_inequality_joins | true | true | boolean | Use faster handling of inequality join if it is possible | |
| hash_partition_count | 100 | 100 | integer | Number of partitions for distributed joins and aggregations | |
| initial_splits_per_node | 32 | 32 | integer | The number of splits each node will run per task, initially | |
| iterative_optimizer_enabled | true | true | boolean | Experimental: enable iterative optimizer | |
| iterative_optimizer_timeout | 3.00m | 3.00m | varchar | Timeout for plan optimization in iterative optimizer | |
| legacy_order_by | false | false | boolean | Use legacy rules for column resolution in ORDER BY clause | |
| optimize_hash_generation | true | true | boolean | Compute hash codes for distribution, joins, and aggregations early in query plan | |
| optimize_metadata_queries | true | true | boolean | Enable optimization for metadata queries | |
| optimize_mixed_distinct_aggregations | true | true | boolean | Optimize mixed non-distinct and distinct aggregations | |
| plan_with_table_node_partitioning | true | true | boolean | Experimental: Adapt plan to pre-partitioned tables | |
| prefer_streaming_operators | true | false | boolean | Prefer source table layouts that produce streaming operators | |
| push_aggregation_through_join | true | true | boolean | Allow pushing aggregations below joins | |
| push_partial_aggregation_through_join | false | false | boolean | Push partial aggregations below joins | |
| push_table_write_through_union | true | true | boolean | Parallelize writes when using UNION ALL in queries that write data | |
| query_max_cpu_time | 1000000000.00d | 1000000000.00d | varchar | Maximum CPU time of a query | |
| query_max_execution_time | 100.00d | 100.00d | varchar | Maximum execution time of a query | |
| query_max_run_time | 100.00d | 100.00d | varchar | Maximum run time of a query (includes the queueing time) | |
| query_priority | 1 | 1 | integer | The priority of queries. Larger numbers are higher priority | |
| redistribute_writes | true | true | boolean | Force parallel distributed writes | |
| reorder_joins | true | true | boolean | Experimental: Reorder joins to optimize plan | |
| resource_overcommit | false | false | boolean | Use resources which are not guaranteed to be available to the query | |
| spill_enabled | false | false | boolean | Experimental: Enable spilling | |
| split_concurrency_adjustment_interval | 100.00ms | 100.00ms | varchar | Experimental: Interval between changes to the number of concurrent splits per node | |
| task_concurrency | 8 | 8 | bigint | Default number of local parallel jobs per worker | |
| task_share_index_loading | true | true | boolean | Share index join lookups and caching within a task | |
| task_writer_count | 1 | 1 | bigint | Default number of local parallel table writer jobs per worker | |
| hive.bucket_execution_enabled | true | true | boolean | Enable bucket-aware execution: only use a single worker per bucket | |
| hive.force_local_scheduling | false | false | boolean | Only schedule splits on workers colocated with data node | |
| hive.orc_bloom_filters_enabled | false | false | boolean | ORC: Enable bloom filters for predicate pushdown | |
| hive.orc_lazy_read_small_ranges | true | true | boolean | Experimental: ORC: Read small file segments lazily | |
| hive.orc_max_buffer_size | 8MB | 8MB | varchar | ORC: Maximum size of a single read | |
| hive.orc_max_merge_distance | 1MB | 1MB | varchar | ORC: Maximum size of gap between two reads to merge into a single read | |
| hive.orc_max_read_block_size | 16MB | 16MB | varchar | ORC: Maximum size of a block to read | |
| hive.orc_optimized_writer_enabled | false | false | boolean | Experimental: ORC: Enable optimized writer | |
| hive.orc_optimized_writer_validate | true | true | boolean | Experimental: ORC: Validate writer files | |
| hive.orc_stream_buffer_size | 8MB | 8MB | varchar | ORC: Size of buffer for streaming reads | |
| hive.parquet_optimized_reader_enabled | false | false | boolean | Experimental: Parquet: Enable optimized reader | |
| hive.parquet_predicate_pushdown_enabled | false | false | boolean | Experimental: Parquet: Enable predicate pushdown for Parquet | |
| hive.rcfile_optimized_writer_enabled | true | true | boolean | Experimental: RCFile: Enable optimized writer | |
| hive.rcfile_optimized_writer_validate | false | false | boolean | Experimental: RCFile: Validate writer files | |
| hive.statistics_enabled | true | true | boolean | Experimental: Expose table statistics |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment