[jira] [Work logged] (KNOX-2746) Add presto and presto ui support in service definition

Tue, 17 May 2022 04:39:04 -0700 


     [ 
https://issues.apache.org/jira/browse/KNOX-2746?focusedWorklogId=771258&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-771258
 ]

ASF GitHub Bot logged work on KNOX-2746:
----------------------------------------

                Author: ASF GitHub Bot
            Created on: 17/May/22 11:38
            Start Date: 17/May/22 11:38
    Worklog Time Spent: 10m 
      Work Description: Bhargavi-Sagi opened a new pull request, #576:
URL: https://github.com/apache/knox/pull/576

   ## What changes were proposed in this pull request?
   
    [Presto](https://prestodb.io/docs/current/) is a distributed SQL query 
engine designed to query large data sets distributed over one or more 
heterogeneous data sources. Add support for in knox service definition, so that 
knox can provide proxying service for presto.
   
   ## How was this patch tested?
   Deployed knox in a cluster with presto, and checked access presto ui with 
knox server port 8442. Also checked presto apis with knox server as proxy
   
   <img width="1762" alt="Screenshot 2022-05-17 at 4 58 23 PM" 
src="https://user-images.githubusercontent.com/92242165/168801653-1afbf65b-ee66-4570-95be-602af065db3e.png";>
   <img width="1762" alt="Screenshot 2022-05-17 at 4 58 49 PM" 
src="https://user-images.githubusercontent.com/92242165/168801685-a041b25a-7ad5-45d6-830b-4fbf8bb22959.png";>
   
   API testing: 
   
   `curl --insecure -X POST -d 'show catalogs' -H "X-Presto-User: user" -H 
"Content-Type: application/json" 
https://localhost:8442/gateway/default/presto/v1/statement`
   
   
{"id":"20220517_112614_00000_muw7k","infoUri":"https://localhost:8442/gateway/default/presto/ui/query.html?20220517_112614_00000_muw7k","nextUri":"https://localhost:8442/gateway/default/presto/v1/statement/queued/20220517_112614_00000_muw7k/1?slug=x31aa07b4664b44de90fe15c2e2a758cc","stats":{"state":"WAITING_FOR_PREREQUISITES","waitingForPrerequisites":true,"queued":false,"scheduled":false,"nodes":0,"totalSplits":0,"queuedSplits":0,"runningSplits":0,"completedSplits":0,"cpuTimeMillis":0,"wallTimeMillis":0,"waitingForPrerequisitesTimeMillis":0,"queuedTimeMillis":0,"elapsedTimeMillis":0,"processedRows":0,"processedBytes":0,"peakMemoryBytes":0,"peakTotalMemoryBytes":0,"peakTaskTotalMemoryBytes":0,"spilledBytes":0},"warnings":[]}
   
   `curl --insecure 
https://localhost:8442/gateway/default/presto/v1/statement/queued/20220517_112614_00000_muw7k/1?slug=x31aa07b4664b44de90fe15c2e2a758cc`
   
   
{"id":"20220517_112614_00000_muw7k","infoUri":"https://localhost:8442/gateway/default/presto/ui/query.html?20220517_112614_00000_muw7k","nextUri":"https://localhost:8442/gateway/default/presto/v1/statement/queued/20220517_112614_00000_muw7k/2?slug=x31aa07b4664b44de90fe15c2e2a758cc","stats":{"state":"WAITING_FOR_PREREQUISITES","waitingForPrerequisites":true,"queued":false,"scheduled":false,"nodes":0,"totalSplits":0,"queuedSplits":0,"runningSplits":0,"completedSplits":0,"cpuTimeMillis":0,"wallTimeMillis":0,"waitingForPrerequisitesTimeMillis":6,"queuedTimeMillis":0,"elapsedTimeMillis":6,"processedRows":0,"processedBytes":0,"peakMemoryBytes":0,"peakTotalMemoryBytes":0,"peakTaskTotalMemoryBytes":0,"spilledBytes":0},"warnings":[]}
   
   `curl --insecure 
https://localhost:8442/gateway/default/presto/v1/statement/queued/20220517_112614_00000_muw7k/2?slug=x31aa07b4664b44de90fe15c2e2a758cc`
   
   
{"id":"20220517_112614_00000_muw7k","infoUri":"https://localhost:8442/gateway/default/presto/ui/query.html?20220517_112614_00000_muw7k","partialCancelUri":"https://localhost:8442/gateway/default/presto/v1/stage/20220517_112614_00000_muw7k.0","nextUri":"https://localhost:8442/gateway/default/presto/v1/statement/executing/20220517_112614_00000_muw7k/1?slug=x31aa07b4664b44de90fe15c2e2a758cc","columns":[{"name":"Catalog","type":"varchar(14)","typeSignature":{"rawType":"varchar","typeArguments":[],"literalArguments":[],"arguments":[{"kind":"LONG_LITERAL","value":14}]}}],"data":[["awsdatacatalog"],["hive"],["system"]],"stats":{"state":"RUNNING","waitingForPrerequisites":false,"queued":false,"scheduled":true,"nodes":1,"totalSplits":19,"queuedSplits":0,"runningSplits":0,"completedSplits":19,"cpuTimeMillis":14,"wallTimeMillis":141,"waitingForPrerequisitesTimeMillis":15,"queuedTimeMillis":0,"elapsedTimeMillis":12522,"processedRows":0,"processedBytes":0,"peakMemoryBytes":0,"peakTotalMemoryBytes":171,"peakTaskTotalMemoryBytes":171,"spilledBytes":0,"rootStage":{"stageId":"0","state":"RUNNING","done":false,"nodes":1,"totalSplits":1,"queuedSplits":0,"runningSplits":0,"completedSplits":1,"cpuTimeMillis":1,"wallTimeMillis":3,"processedRows":3,"processedBytes":67,"subStages":[{"stageId":"1","state":"FINISHED","done":true,"nodes":1,"totalSplits":17,"queuedSplits":0,"runningSplits":0,"completedSplits":17,"cpuTimeMillis":13,"wallTimeMillis":138,"processedRows":3,"processedBytes":67,"subStages":[{"stageId":"2","state":"FINISHED","done":true,"nodes":1,"totalSplits":1,"queuedSplits":0,"runningSplits":0,"completedSplits":1,"cpuTimeMillis":0,"wallTimeMillis":0,"processedRows":3,"processedBytes":0,"subStages":[]}]}]},"runtimeStats":{"S1-driverCountPerTask":{"name":"S1-driverCountPerTask","sum":17,"count":1,"max":17,"min":17},"S2-driverCountPerTask":{"name":"S2-driverCountPerTask","sum":1,"count":1,"max":1,"min":1},"S1-taskElapsedTimeNanos":{"name":"S1-taskElapsedTimeNanos","sum":142799852,"count":1,"max":142799852,"min":142799852},"S2-taskElapsedTimeNanos":{"name":"S2-taskElapsedTimeNanos","sum":106038415,"count":1,"max":106038415,"min":106038415},"S0-driverCountPerTask":{"name":"S0-driverCountPerTask","sum":1,"count":1,"max":1,"min":1},"S0-taskElapsedTimeNanos":{"name":"S0-taskElapsedTimeNanos","sum":0,"count":1,"max":0,"min":0}},"progressPercentage":100.0},"warnings":[]}
   




Issue Time Tracking
-------------------

            Worklog Id:     (was: 771258)
    Remaining Estimate: 0h
            Time Spent: 10m

> Add presto and presto ui support in service definition
> ------------------------------------------------------
>
>                 Key: KNOX-2746
>                 URL: https://issues.apache.org/jira/browse/KNOX-2746
>             Project: Apache Knox
>          Issue Type: Improvement
>          Components: Server
>            Reporter: sagi bhargavi
>            Priority: Major
>          Time Spent: 10m
>  Remaining Estimate: 0h
>
> Add spport for [Presto|https://github.com/prestodb/presto], also known as 
> PrestoDB in knox service definition.



--
This message was sent by Atlassian Jira
(v8.20.7#820007)

Reply via email to