[ https://issues.apache.org/jira/browse/DRILL-2246?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Victoria Markman resolved DRILL-2246. ------------------------------------- Resolution: Fixed > 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)