You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Bridget Bevens (JIRA)" <ji...@apache.org> on 2018/05/30 20:43:01 UTC
[jira] [Commented] (DRILL-6452) document steps to execute SQL
queries from Postman (chrome extension) on Drill
[ https://issues.apache.org/jira/browse/DRILL-6452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16495649#comment-16495649 ]
Bridget Bevens commented on DRILL-6452:
---------------------------------------
Hey [~khfaraaz], I've edited your Google doc. Can you please decline or accept my changes in the Google doc? Once you do that I can copy the content into a MarkDown (.md) file and post it to the Apache Drill site.
Thanks,
Bridget
> document steps to execute SQL queries from Postman (chrome extension) on Drill
> ------------------------------------------------------------------------------
>
> Key: DRILL-6452
> URL: https://issues.apache.org/jira/browse/DRILL-6452
> Project: Apache Drill
> Issue Type: Task
> Components: Documentation
> Affects Versions: 1.14.0
> Reporter: Khurram Faraaz
> Assignee: Khurram Faraaz
> Priority: Minor
>
> We need documentation to list the steps with screen shots about executing SQL queries from Postman (chrome extension) on Drill.
> Here are the steps to execute SQL queries from Postman
> {noformat}
> 1. Install Postman extension for Chrome browser.
> To install Postman
> https://chrome.google.com/webstore/detail/postman/fhbjgbiflinjbdggehcddcbncdddomop?hl=en
> Then click on ADD TO CHROME button
> 2. On the top right of your Chrome browser window, click on the postman icon.
> In your Postman:
> 3. set the type to “POST” and enter the request URL as “http://<your drillbit ip>:8047/query.json”
> 4. In the Header tab, add an entry for “Content-Type” as key and “application/json” as value.
> Add another entry for “User-Name” as key and “mapr” as value
> 5. In the Body tab, select “raw” and a new dropdown list should appear next to “raw" and on the dropdown select “JSON”
> 6. And in the Body box, enter your request body in JSON format. The file test.csv is expected to reside under /tmp folder (i.e. in dfs.tmp schema)
> {
> “queryType”: “SQL”,
> “query”: “select * from `dfs.tmp`.`test.csv`”
> }
> 5. Press send!
> {noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)