You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Yuchen Liang (Jira)" <ji...@apache.org> on 2023/02/03 06:25:00 UTC
[jira] [Updated] (DRILL-8393) Use some configuration items to specify the parameters as filters that allow them to be passed to headers through SQL
[ https://issues.apache.org/jira/browse/DRILL-8393?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Yuchen Liang updated DRILL-8393:
--------------------------------
Description:
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:
Config:
{ "url": "https://api.sunrise-sunset.org/json", "requireTail": false, "params": ["body.lat", "body.lng", "body.date", "header.header1"], "parameterLocation": "json_body" }
SQL Query:
SELECT * FROM api.sunrise
WHERE `body.lat` = 36.7201600
AND `body.lng` = -4.4203400
AND `body.date` = '2019-10-02'
AND `header.header1` = 'value1';
Post body:
{ "lat": 36.7201600, "lng": -4.4203400, "date": "2019-10-02"}
Headers:
{ "header1": "value1", ……}
was:
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';
> 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
> Priority: Major
> 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:
>
> Config:
> { "url": "https://api.sunrise-sunset.org/json", "requireTail": false, "params": ["body.lat", "body.lng", "body.date", "header.header1"], "parameterLocation": "json_body" }
>
> SQL Query:
> SELECT * FROM api.sunrise
> WHERE `body.lat` = 36.7201600
> AND `body.lng` = -4.4203400
> AND `body.date` = '2019-10-02'
> AND `header.header1` = 'value1';
>
> Post body:
> { "lat": 36.7201600, "lng": -4.4203400, "date": "2019-10-02"}
>
> Headers:
> { "header1": "value1", ……}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)