[DRILL-5817] deprecated sys options should be deleted from old zookeeper setting

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Invalid
• Affects Version/s: 1.11.0
• Fix Version/s: 1.11.0
• Component/s: Functions - Drill

Environment

drill 1.11.0

• Assignee: Timothy Farkas
• Reporter: Dechang Gu
• Created: 25/Sep/17 17:16
• Updated: 28/Sep/17 23:01
• Resolved: 28/Sep/17 23:01

Description

In the following example, exec.query.rowkeyjoin.batchsize is a deprecated sys options, which is replaced with exec.query.rowkeyjoin_batchsize. Further both of them are just for MapR drill distribution, hence should not be listed at all.

0: jdbc:drill:schema=default> select * from sys.options where name like '%batch%';
+-----------------------------------------------+-------+---------+----------+----------+-------------+-----------+------------+
|                     name                      | kind  |  type   |  status  | num_val  | string_val  | bool_val  | float_val  |
+-----------------------------------------------+-------+---------+----------+----------+-------------+-----------+------------+
| drill.exec.hashagg.min_batches_per_partition  | LONG  | SYSTEM  | DEFAULT  | 3        | null        | null      | null       |
| exec.query.rowkeyjoin.batchsize               | LONG  | SYSTEM  | DEFAULT  | 128      | null        | null      | null       |
| exec.query.rowkeyjoin_batchsize               | LONG  | SYSTEM  | DEFAULT  | 128      | null        | null      | null       |
+-----------------------------------------------+-------+---------+----------+----------+-------------+-----------+------------+
3 rows selected (0.118 seconds)