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)