sthetland commented on a change in pull request #6974: sql support for dynamic
parameters
URL: https://github.com/apache/druid/pull/6974#discussion_r380952198
##########
File path: docs/querying/sql.md
##########
@@ -540,7 +554,27 @@ like:
}
```
-Metadata is available over the HTTP API by querying [system
tables](#metadata-tables).
+Parameterized SQL queries are also supported:
+
+```json
+{
+ "query" : "SELECT COUNT(*) FROM data_source WHERE foo = ? AND __time > ?",
+ "parameters": [
+ { "type": "VARCHAR", "value": "bar"},
+ { "type": "TIMESTAMP", "value": "2000-01-01 00:00:00" }
+ ]
+}
+```
+
+##### SqlParameter
+
+|Property|Type|Description|Required|
+|--------|----|-----------|--------|
+|`type`|`String` (`SqlType`) | String value of `SqlType` of parameter.
[`SqlType`](https://calcite.apache.org/avatica/apidocs/org/apache/calcite/avatica/SqlType.html)
is an friendly wrapper around
[`java.sql.Types`](https://docs.oracle.com/javase/8/docs/api/java/sql/Types.html?is-external=true)|yes|
Review comment:
nit: "...is a friendly wrapper..."
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]