Probabilistic guarantees for SQL query executionData manipulation in SQLHow do I write a SQL (or dwSQL) query across these two different datasets?Sql satament sql serverSpark SQL Pivot CrossTab functionalitySQL Server and skip first n rowsData dashboard for SQL server databaseNot enough replicas available for query at consistency all (2 required but only 1 alive)Natural Language to SQL queryCall a SQL procedure, for each group byPython-SQL database

Air travel with refrigerated insulin

PTIJ: Which Dr. Seuss books should one obtain?

Naïve RSA decryption in Python

Hot air balloons as primitive bombers

What do the positive and negative (+/-) transmit and receive pins mean on Ethernet cables?

Why is the intercept typed in as a 1 in stats packages (R, python)

What should be the ideal length of sentences in a blog post for ease of reading?

Can other pieces capture a threatening piece and prevent a checkmate?

What's the meaning of "what it means for sth to be sth"?

Does fire aspect on a sword destroy mob drops?

Why is "la Gestapo" feminine?

Why didn’t Eve recognize the little cockroach as a living organism?

Mortal danger in mid-grade literature

Exit shell with shortcut (not typing exit) that closes session properly

What is this high flying aircraft over Pennsylvania?

Magento 1 : each() function is deprecated

Why doesn't the fusion process of the sun speed up?

Magento 2: Make category field required in product form in backend

Exposing a company lying about themselves in a tightly knit industry (videogames) : Is my career at risk on the long run?

Put the phone down / Put down the phone

Would mining huge amounts of resources on the Moon change its orbit?

When doing an engine swap , do you have to have a matching ecu

How to left align the cases in Latex?

How can an organ that provides biological immortality be unable to regenerate?



Probabilistic guarantees for SQL query execution


Data manipulation in SQLHow do I write a SQL (or dwSQL) query across these two different datasets?Sql satament sql serverSpark SQL Pivot CrossTab functionalitySQL Server and skip first n rowsData dashboard for SQL server databaseNot enough replicas available for query at consistency all (2 required but only 1 alive)Natural Language to SQL queryCall a SQL procedure, for each group byPython-SQL database













1












$begingroup$


We are working on a project that tries to accelerate Spark SQL using dedicated hardware.
Our approach works much better (in terms of the resulting latency) if we allow query processing that is only probably correct.



That is, with high probability (e.g., 99.9%) we will return the correct answer.



I was wondering if such there are any existing systems with such a guarantee. The closest I've seen is the "approximate percentile" computation, but this also has an error in the result (whereas we give the exact result with high probability).



Thanks!










share|improve this question







New contributor




Jenny is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.







$endgroup$
















    1












    $begingroup$


    We are working on a project that tries to accelerate Spark SQL using dedicated hardware.
    Our approach works much better (in terms of the resulting latency) if we allow query processing that is only probably correct.



    That is, with high probability (e.g., 99.9%) we will return the correct answer.



    I was wondering if such there are any existing systems with such a guarantee. The closest I've seen is the "approximate percentile" computation, but this also has an error in the result (whereas we give the exact result with high probability).



    Thanks!










    share|improve this question







    New contributor




    Jenny is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
    Check out our Code of Conduct.







    $endgroup$














      1












      1








      1





      $begingroup$


      We are working on a project that tries to accelerate Spark SQL using dedicated hardware.
      Our approach works much better (in terms of the resulting latency) if we allow query processing that is only probably correct.



      That is, with high probability (e.g., 99.9%) we will return the correct answer.



      I was wondering if such there are any existing systems with such a guarantee. The closest I've seen is the "approximate percentile" computation, but this also has an error in the result (whereas we give the exact result with high probability).



      Thanks!










      share|improve this question







      New contributor




      Jenny is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.







      $endgroup$




      We are working on a project that tries to accelerate Spark SQL using dedicated hardware.
      Our approach works much better (in terms of the resulting latency) if we allow query processing that is only probably correct.



      That is, with high probability (e.g., 99.9%) we will return the correct answer.



      I was wondering if such there are any existing systems with such a guarantee. The closest I've seen is the "approximate percentile" computation, but this also has an error in the result (whereas we give the exact result with high probability).



      Thanks!







      bigdata apache-spark probability sql






      share|improve this question







      New contributor




      Jenny is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.











      share|improve this question







      New contributor




      Jenny is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      share|improve this question




      share|improve this question






      New contributor




      Jenny is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      asked yesterday









      JennyJenny

      61




      61




      New contributor




      Jenny is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.





      New contributor





      Jenny is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






      Jenny is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.




















          0






          active

          oldest

          votes











          Your Answer





          StackExchange.ifUsing("editor", function ()
          return StackExchange.using("mathjaxEditing", function ()
          StackExchange.MarkdownEditor.creationCallbacks.add(function (editor, postfix)
          StackExchange.mathjaxEditing.prepareWmdForMathJax(editor, postfix, [["$", "$"], ["\\(","\\)"]]);
          );
          );
          , "mathjax-editing");

          StackExchange.ready(function()
          var channelOptions =
          tags: "".split(" "),
          id: "557"
          ;
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function()
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled)
          StackExchange.using("snippets", function()
          createEditor();
          );

          else
          createEditor();

          );

          function createEditor()
          StackExchange.prepareEditor(
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: false,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: null,
          bindNavPrevention: true,
          postfix: "",
          imageUploader:
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          ,
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          );



          );






          Jenny is a new contributor. Be nice, and check out our Code of Conduct.









          draft saved

          draft discarded


















          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdatascience.stackexchange.com%2fquestions%2f47470%2fprobabilistic-guarantees-for-sql-query-execution%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown

























          0






          active

          oldest

          votes








          0






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes








          Jenny is a new contributor. Be nice, and check out our Code of Conduct.









          draft saved

          draft discarded


















          Jenny is a new contributor. Be nice, and check out our Code of Conduct.












          Jenny is a new contributor. Be nice, and check out our Code of Conduct.











          Jenny is a new contributor. Be nice, and check out our Code of Conduct.














          Thanks for contributing an answer to Data Science Stack Exchange!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid


          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.

          Use MathJax to format equations. MathJax reference.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdatascience.stackexchange.com%2fquestions%2f47470%2fprobabilistic-guarantees-for-sql-query-execution%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          Adding axes to figuresAdding axes labels to LaTeX figuresLaTeX equivalent of ConTeXt buffersRotate a node but not its content: the case of the ellipse decorationHow to define the default vertical distance between nodes?TikZ scaling graphic and adjust node position and keep font sizeNumerical conditional within tikz keys?adding axes to shapesAlign axes across subfiguresAdding figures with a certain orderLine up nested tikz enviroments or how to get rid of themAdding axes labels to LaTeX figures

          Tähtien Talli Jäsenet | Lähteet | NavigointivalikkoSuomen Hippos – Tähtien Talli

          Do these cracks on my tires look bad? The Next CEO of Stack OverflowDry rot tire should I replace?Having to replace tiresFishtailed so easily? Bad tires? ABS?Filling the tires with something other than air, to avoid puncture hassles?Used Michelin tires safe to install?Do these tyre cracks necessitate replacement?Rumbling noise: tires or mechanicalIs it possible to fix noisy feathered tires?Are bad winter tires still better than summer tires in winter?Torque converter failure - Related to replacing only 2 tires?Why use snow tires on all 4 wheels on 2-wheel-drive cars?