[
https://issues.apache.org/jira/browse/DRILL-2246?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14949421#comment-14949421
]
Victoria Markman commented on DRILL-2246:
-----------------------------------------
Works in 1.2.0, no info on check in.
{code}
0: jdbc:drill:schema=dfs> alter system set `planner.slice_target` =1;
+-------+--------------------------------+
| ok | summary |
+-------+--------------------------------+
| true | planner.slice_target updated. |
+-------+--------------------------------+
1 row selected (0.244 seconds)
0: jdbc:drill:schema=dfs> select * from sys.options order by name;
+--------------------------------------------------------------------+----------+---------+----------+-------------+-------------+-----------+------------+
| name | kind
| type | status | num_val | string_val | bool_val | float_val |
+--------------------------------------------------------------------+----------+---------+----------+-------------+-------------+-----------+------------+
| drill.exec.functions.cast_empty_string_to_null | BOOLEAN
| SYSTEM | DEFAULT | null | null | false | null |
| drill.exec.storage.file.partition.column.label | STRING
| SYSTEM | DEFAULT | null | dir | null | null |
| exec.errors.verbose | BOOLEAN
| SYSTEM | DEFAULT | null | null | false | null |
| exec.java_compiler | STRING
| SYSTEM | DEFAULT | null | DEFAULT | null | null |
| exec.java_compiler_debug | BOOLEAN
| SYSTEM | DEFAULT | null | null | true | null |
| exec.java_compiler_janino_maxsize | LONG
| SYSTEM | DEFAULT | 262144 | null | null | null |
| exec.max_hash_table_size | LONG
| SYSTEM | DEFAULT | 1073741824 | null | null | null |
| exec.min_hash_table_size | LONG
| SYSTEM | DEFAULT | 65536 | null | null | null |
| exec.queue.enable | BOOLEAN
| SYSTEM | DEFAULT | null | null | false | null |
| exec.queue.large | LONG
| SYSTEM | DEFAULT | 10 | null | null | null |
| exec.queue.small | LONG
| SYSTEM | DEFAULT | 100 | null | null | null |
| exec.queue.threshold | LONG
| SYSTEM | DEFAULT | 30000000 | null | null | null |
| exec.queue.timeout_millis | LONG
| SYSTEM | DEFAULT | 300000 | null | null | null |
| exec.schedule.assignment.old | BOOLEAN
| SYSTEM | DEFAULT | null | null | false | null |
| exec.storage.enable_new_text_reader | BOOLEAN
| SYSTEM | DEFAULT | null | null | true | null |
| new_view_default_permissions | STRING
| SYSTEM | DEFAULT | null | 700 | null | null |
| org.apache.drill.exec.compile.ClassTransformer.scalar_replacement | STRING
| SYSTEM | DEFAULT | null | try | null | null |
| planner.add_producer_consumer | BOOLEAN
| SYSTEM | DEFAULT | null | null | false | null |
| planner.affinity_factor | DOUBLE
| SYSTEM | DEFAULT | null | null | null | 1.2 |
| planner.broadcast_factor | DOUBLE
| SYSTEM | DEFAULT | null | null | null | 1.0 |
| planner.broadcast_threshold | LONG
| SYSTEM | DEFAULT | 10000000 | null | null | null |
| planner.disable_exchanges | BOOLEAN
| SYSTEM | DEFAULT | null | null | false | null |
| planner.enable_broadcast_join | BOOLEAN
| SYSTEM | DEFAULT | null | null | true | null |
| planner.enable_constant_folding | BOOLEAN
| SYSTEM | DEFAULT | null | null | true | null |
| planner.enable_decimal_data_type | BOOLEAN
| SYSTEM | CHANGED | null | null | true | null |
| planner.enable_demux_exchange | BOOLEAN
| SYSTEM | DEFAULT | null | null | false | null |
| planner.enable_hash_single_key | BOOLEAN
| SYSTEM | DEFAULT | null | null | true | null |
| planner.enable_hashagg | BOOLEAN
| SYSTEM | DEFAULT | null | null | true | null |
| planner.enable_hashjoin | BOOLEAN
| SYSTEM | DEFAULT | null | null | true | null |
| planner.enable_hashjoin_swap | BOOLEAN
| SYSTEM | DEFAULT | null | null | true | null |
| planner.enable_hep_join_opt | BOOLEAN
| SYSTEM | DEFAULT | null | null | true | null |
| planner.enable_mergejoin | BOOLEAN
| SYSTEM | DEFAULT | null | null | true | null |
| planner.enable_multiphase_agg | BOOLEAN
| SYSTEM | DEFAULT | null | null | true | null |
| planner.enable_mux_exchange | BOOLEAN
| SYSTEM | DEFAULT | null | null | true | null |
| planner.enable_nestedloopjoin | BOOLEAN
| SYSTEM | DEFAULT | null | null | true | null |
| planner.enable_nljoin_for_scalar_only | BOOLEAN
| SYSTEM | DEFAULT | null | null | true | null |
| planner.enable_streamagg | BOOLEAN
| SYSTEM | DEFAULT | null | null | true | null |
| planner.identifier_max_length | LONG
| SYSTEM | DEFAULT | 1024 | null | null | null |
| planner.join.hash_join_swap_margin_factor | DOUBLE
| SYSTEM | DEFAULT | null | null | null | 10.0 |
| planner.join.row_count_estimate_factor | DOUBLE
| SYSTEM | DEFAULT | null | null | null | 1.0 |
| planner.memory.average_field_width | LONG
| SYSTEM | DEFAULT | 8 | null | null | null |
| planner.memory.enable_memory_estimation | BOOLEAN
| SYSTEM | DEFAULT | null | null | false | null |
| planner.memory.hash_agg_table_factor | DOUBLE
| SYSTEM | DEFAULT | null | null | null | 1.1 |
| planner.memory.hash_join_table_factor | DOUBLE
| SYSTEM | DEFAULT | null | null | null | 1.1 |
| planner.memory.max_query_memory_per_node | LONG
| SYSTEM | CHANGED | 1048576 | null | null | null |
| planner.memory.non_blocking_operators_memory | LONG
| SYSTEM | DEFAULT | 64 | null | null | null |
| planner.memory_limit | LONG
| SYSTEM | DEFAULT | 268435456 | null | null | null |
| planner.nestedloopjoin_factor | DOUBLE
| SYSTEM | DEFAULT | null | null | null | 100.0 |
| planner.partitioner_sender_max_threads | LONG
| SYSTEM | DEFAULT | 8 | null | null | null |
| planner.partitioner_sender_set_threads | LONG
| SYSTEM | DEFAULT | -1 | null | null | null |
| planner.partitioner_sender_threads_factor | LONG
| SYSTEM | DEFAULT | 2 | null | null | null |
| planner.producer_consumer_queue_size | LONG
| SYSTEM | DEFAULT | 10 | null | null | null |
| planner.slice_target | LONG
| SYSTEM | CHANGED | 1 | null | null | null |
| planner.width.max_per_node | LONG
| SYSTEM | DEFAULT | 23 | null | null | null |
| planner.width.max_per_query | LONG
| SYSTEM | DEFAULT | 1000 | null | null | null |
| security.admin.user_groups | STRING
| SYSTEM | DEFAULT | null | | null | null |
| security.admin.users | STRING
| SYSTEM | DEFAULT | null | mapr | null | null |
| store.format | STRING
| SYSTEM | DEFAULT | null | parquet | null | null |
| store.hive.optimize_scan_with_native_readers | BOOLEAN
| SYSTEM | DEFAULT | null | null | false | null |
| store.json.all_text_mode | BOOLEAN
| SYSTEM | DEFAULT | null | null | false | null |
| store.json.extended_types | BOOLEAN
| SYSTEM | DEFAULT | null | null | false | null |
| store.json.read_numbers_as_double | BOOLEAN
| SYSTEM | DEFAULT | null | null | false | null |
| store.mongo.all_text_mode | BOOLEAN
| SYSTEM | DEFAULT | null | null | false | null |
| store.mongo.read_numbers_as_double | BOOLEAN
| SYSTEM | DEFAULT | null | null | false | null |
| store.parquet.block-size | LONG
| SYSTEM | DEFAULT | 536870912 | null | null | null |
| store.parquet.compression | STRING
| SYSTEM | DEFAULT | null | snappy | null | null |
| store.parquet.dictionary.page-size | LONG
| SYSTEM | DEFAULT | 1048576 | null | null | null |
| store.parquet.enable_dictionary_encoding | BOOLEAN
| SYSTEM | DEFAULT | null | null | false | null |
| store.parquet.page-size | LONG
| SYSTEM | DEFAULT | 1048576 | null | null | null |
| store.parquet.use_new_reader | BOOLEAN
| SYSTEM | DEFAULT | null | null | false | null |
| store.parquet.vector_fill_check_threshold | LONG
| SYSTEM | DEFAULT | 10 | null | null | null |
| store.parquet.vector_fill_threshold | LONG
| SYSTEM | DEFAULT | 85 | null | null | null |
| store.partition.hash_distribute | BOOLEAN
| SYSTEM | DEFAULT | null | null | false | null |
| store.text.estimated_row_size_bytes | DOUBLE
| SYSTEM | DEFAULT | null | null | null | 100.0 |
| window.enable | BOOLEAN
| SYSTEM | DEFAULT | null | null | true | null |
+--------------------------------------------------------------------+----------+---------+----------+-------------+-------------+-----------+------------+
75 rows selected (0.889 seconds)
{code}
> select from sys.options fails in a weird way when slice_target=1
> ----------------------------------------------------------------
>
> Key: DRILL-2246
> URL: https://issues.apache.org/jira/browse/DRILL-2246
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Flow
> Reporter: Victoria Markman
> Priority: Minor
> Fix For: Future
>
>
> Since this is not supposed to be customer visible option, it's a minor issue.
> {code}
> alter system set `planner.slice_target` =1;
> select * from sys.options order by name;
> {code}
> {code}
> 0: jdbc:drill:schema=dfs> select * from sys.options order by name;
> Query failed: RemoteRpcException: Failure while trying to start remote
> fragment, No suitable constructor found for type [simple type, class
> org.apache.drill.exec.store.sys.SystemTablePlugin]: can not instantiate from
> JSON object (need to add/enable type information?)
> at [Source: {
> "pop" : "hash-partition-sender",
> "@id" : 0,
> "receiver-major-fragment" : 1,
> "child" : {
> "pop" : "sys",
> "@id" : 1,
> "table" : "OPTION",
> "plugin" : {
> "config" : {
> "type" : "SystemTablePluginConfig",
> "enabled" : true
> },
> "optimizerRules" : [ ]
> },
> "cost" : 20.0
> },
> "expr" : "hash(`name`) ",
> "destinations" : [ "ChFhdHNxYTQtMTMzLnFhLmxhYhCi8gEYo/IBIKTyAQ==",
> "ChFhdHNxYTQtMTM0LnFhLmxhYhCi8gEYo/IBIKTyAQ==",
> "ChFhdHNxYTQtMTMzLnFhLmxhYhCi8gEYo/IBIKTyAQ==",
> "ChFhdHNxYTQtMTM0LnFhLmxhYhCi8gEYo/IBIKTyAQ==",
> "ChFhdHNxYTQtMTMzLnFhLmxhYhCi8gEYo/IBIKTyAQ==",
> "ChFhdHNxYTQtMTM0LnFhLmxhYhCi8gEYo/IBIKTyAQ==",
> "ChFhdHNxYTQtMTMzLnFhLmxhYhCi8gEYo/IBIKTyAQ==",
> "ChFhdHNxYTQtMTM0LnFhLmxhYhCi8gEYo/IBIKTyAQ==",
> "ChFhdHNxYTQtMTMzLnFhLmxhYhCi8gEYo/IBIKTyAQ==",
> "ChFhdHNxYTQtMTM0LnFhLmxhYhCi8gEYo/IBIKTyAQ==",
> "ChFhdHNxYTQtMTMzLnFhLmxhYhCi8gEYo/IBIKTyAQ==",
> "ChFhdHNxYTQtMTM0LnFhLmxhYhCi8gEYo/IBIKTyAQ==",
> "ChFhdHNxYTQtMTMzLnFhLmxhYhCi8gEYo/IBIKTyAQ==",
> "ChFhdHNxYTQtMTM0LnFhLmxhYhCi8gEYo/IBIKTyAQ==",
> "ChFhdHNxYTQtMTMzLnFhLmxhYhCi8gEYo/IBIKTyAQ==",
> "ChFhdHNxYTQtMTM0LnFhLmxhYhCi8gEYo/IBIKTyAQ==",
> "ChFhdHNxYTQtMTMzLnFhLmxhYhCi8gEYo/IBIKTyAQ==",
> "ChFhdHNxYTQtMTM0LnFhLmxhYhCi8gEYo/IBIKTyAQ==",
> "ChFhdHNxYTQtMTMzLnFhLmxhYhCi8gEYo/IBIKTyAQ==",
> "ChFhdHNxYTQtMTM0LnFhLmxhYhCi8gEYo/IBIKTyAQ==" ],
> "initialAllocation" : 1000000,
> "maxAllocation" : 10000000000,
> "cost" : 0.0
> }; line: 10, column: 7] [ 3082d365-3bc6-4aeb-bb29-ddd133832cff on
> atsqa4-134.qa.lab:31010 ]
> Error: exception while executing query: Failure while executing query.
> (state=,code=0)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
