[DRILL-2246] select from sys.options fails in a weird way when slice_target=1

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: Future
• Component/s: Execution - Flow
• Assignee: Unassigned
• Reporter: Victoria Markman
• Created: 13/Feb/15 23:08
• Updated: 08/Oct/15 21:24
• Resolved: 08/Oct/15 21:24

Description

Since this is not supposed to be customer visible option, it's a minor issue.

alter system set `planner.slice_target` =1;
select * from sys.options order by name;

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)

Issue Links

• duplicates: DRILL-2271 count(distinct ) against SystemTablePlugin will hit plan serialization/deserialization issue when executed in distributed mode.