Zhiyong Liu created DRILL-2371:
----------------------------------
Summary: quoted and unquoted boolean values in BOOT options have
strange behavior
Key: DRILL-2371
URL: https://issues.apache.org/jira/browse/DRILL-2371
Project: Apache Drill
Issue Type: Bug
Components: Metadata
Reporter: Zhiyong Liu
Assignee: Steven Phillips
git.commit.id.abbrev=a84f7b9
In drill-override.conf, specify
"http" : {
"port" : 8047,
"enabled" : true
}
and don't quote the boolean value.
0: jdbc:drill:> select * from sys.options where name =
'drill.exec.http.enabled' order by name;
+------------+------------+------------+------------+------------+------------+------------+
| name | kind | type | num_val | string_val | bool_val |
float_val |
+------------+------------+------------+------------+------------+------------+------------+
| drill.exec.http.enabled | BOOLEAN | BOOT | null | null |
true | null |
+------------+------------+------------+------------+------------+------------+------------+
The query correctly returns the boolean value as 'bool_val' and the type set to
'BOOLEAN'.
Check http://<hostname>:8047 to make sure that it works.
Now, change the block to the following:
"http" : {
"port" : 8047,
"enabled" : "true"
}
restart drill and query:
0: jdbc:drill:> select * from sys.options where name =
'drill.exec.http.enabled' order by name;
+------------+------------+------------+------------+------------+------------+------------+
| name | kind | type | num_val | string_val | bool_val |
float_val |
+------------+------------+------------+------------+------------+------------+------------+
| drill.exec.http.enabled | null | BOOT | null | "true" |
null | null |
+------------+------------+------------+------------+------------+------------+------------+
Note that type is now null and the "boolean" value is now string_val.
Check http://<hostname>:8047 to observe that it works.
It may be more consistent if we either handle the second case the same way as
the first one in query result set, or fail in the second case.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
