[DRILL-5809] Queries failed with UnrecognizedPropertyException

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 1.12.0
• Component/s: Functions - Drill

Environment

RHEL 6, 2.6.32-358.el6.x86_64, Apache Drill gitid 4c99f0cdd98b1a0e789c5d11b353f88a2f6d54aa

• Assignee: Timothy Farkas
• Reporter: Dechang Gu
• Reviewer: Paul Rogers
• Created: 21/Sep/17 17:47
• Updated: 27/Sep/17 18:02
• Resolved: 27/Sep/17 18:02

Description

Run tpch queries, all failed due to the following error:

java.sql.SQLException: SYSTEM ERROR: UnrecognizedPropertyException: Unrecognized field "type" (class org.apache.drill.exec.server.options.OptionValue), not marked as ignorable (8 known properties: "string_val", "kind", "accessibleScopes", "num_val", "name", "bool_val", "float_val", "scope"])
 at [Source: [B@4ec364a3; line: 6, column: 2] (through reference chain: org.apache.drill.exec.server.options.OptionValue["type"])


[Error Id: 9bad34d9-fe21-47fd-ade1-fbee3d5111e5 on ucs-node7.perf.lab:31010]
        at org.apache.drill.jdbc.impl.DrillCursor.nextRowInternally(DrillCursor.java:489)
        at org.apache.drill.jdbc.impl.DrillCursor.loadInitialSchema(DrillCursor.java:561)
        at org.apache.drill.jdbc.impl.DrillResultSetImpl.execute(DrillResultSetImpl.java:1895)
        at org.apache.drill.jdbc.impl.DrillResultSetImpl.execute(DrillResultSetImpl.java:61)
        at org.apache.calcite.avatica.AvaticaConnection$1.execute(AvaticaConnection.java:473)
        at org.apache.drill.jdbc.impl.DrillMetaImpl.prepareAndExecute(DrillMetaImpl.java:1100)
        at org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:477)
        at org.apache.drill.jdbc.impl.DrillConnectionImpl.prepareAndExecuteInternal(DrillConnectionImpl.java:181)
        at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:109)
        at org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:130)
        at org.apache.drill.jdbc.impl.DrillStatementImpl.executeQuery(DrillStatementImpl.java:112)
        at PipSQueak.executeQuery(PipSQueak.java:289)
        at PipSQueak.runTest(PipSQueak.java:104)
        at PipSQueak.main(PipSQueak.java:477)
Caused by: org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: UnrecognizedPropertyException: Unrecognized field "type" (class org.apache.drill.exec.server.options.OptionValue), not marked as ignorable (8 known properties: "string_val", "kind", "accessibleScopes", "num_val", "name", "bool_val", "float_val", "scope"])
 at [Source: [B@4ec364a3; line: 6, column: 2] (through reference chain: org.apache.drill.exec.server.options.OptionValue["type"])

Looks like the issue was introduced in commit: 6adeb986016a769755fd5e8fc66244ee1e8d18e1
DRILL-5723: Added System Internal Options That can be Modified at Run…

The commit prior to this one did not show the issue.

Issue Links

• links to: GitHub Pull Request #957