Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-6452

document steps to execute SQL queries from Postman (chrome extension) on Drill

    XMLWordPrintableJSON

    Details

    • Type: Task
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.14.0
    • Fix Version/s: None
    • Component/s: Documentation
    • Labels:
      None

      Description

      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

      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!
      
      

        Attachments

          Activity

            People

            • Assignee:
              khfaraaz Khurram Faraaz
              Reporter:
              khfaraaz Khurram Faraaz
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: