Yuchen Liang created DRILL-8393:
-----------------------------------
Summary: Use some configuration items to specify the parameters as
filters that allow them to be passed to headers through SQL
Key: DRILL-8393
URL: https://issues.apache.org/jira/browse/DRILL-8393
Project: Apache Drill
Issue Type: Improvement
Components: Storage - HTTP
Affects Versions: 1.20.0
Reporter: Yuchen Liang
Fix For: 1.21.0
Some APIs require parameters (e.g. digital signature) in the headers to be
generated at access time.So I'm wondering if we can pass it in through filter
statement.
Perhaps we could design it like the params field in connections parameter. For
example:
{
"url": "[https://api.sunrise-sunset.org/json]";,
"requireTail": false,
"bodyParams": ["lat", "lng", "date"],
"headerParams": ["signature"]
}
SQL Query:
SELECT * FROM api.sunrise
WHERE `body.lat` = 36.7201600
AND `body.lng` = -4.4203400
AND `body.date` = '2019-10-02'
AND `header.signature` = 'xxxxx';
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
