[ https://issues.apache.org/jira/browse/DRILL-2271?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jinfeng Ni resolved DRILL-2271. ------------------------------- Resolution: Duplicate > count(distinct ) against SystemTablePlugin will hit plan > serialization/deserialization issue when executed in distributed mode. > ------------------------------------------------------------------------------------------------------------------------------- > > Key: DRILL-2271 > URL: https://issues.apache.org/jira/browse/DRILL-2271 > Project: Apache Drill > Issue Type: Bug > Reporter: Jinfeng Ni > Priority: Minor > > The following query run fine in single node. > {code} > select count(distinct name) as cnt from `sys`.`options`; > {code} > However, if change the slice_target =1 and make it run in distributed mode, > it hit error : > {code} > alter session set `planner.slice_target` = 1; > +------------+------------+ > | ok | summary | > +------------+------------+ > | true | planner.slice_target updated. | > +------------+------------+ > select count(distinct name) as cnt from `sys`.`options`; > 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?) > {code} > Seems the serialization/deserialization of the plan for SystemTablePlugin > does not work correctly. -- This message was sent by Atlassian JIRA (v6.3.4#6332)