Code Monkey home page Code Monkey logo

Comments (2)

ryantking avatar ryantking commented on June 2, 2024 1

@meysampg I have a similar use case, and this is what I'm currently doing that gets the job done, hope it helps!

func doQuery(ctx context.Context, db *sql.DB, query string) error {
    // prepend a unique identifier to the query string
    query = fmt.Sprintf("/* my-program-%s */ %s", generateID(), query)
    rows, err := db.QueryContext(ctx, query)
    if err != nil {
        // ...
    }
    defer rows.Close()

    // Grab the ID of the query from the runtime table that stores all active running queries
    // This is why we used the unique identifier, so that way two queries with the same SQL won't
    // collide on this table.
    var queryID string
    if err := db.QueryRow("SELECT query_id FROM system.runtime.queries WHERE query = ?', query).Scan(&queryID); err != nil {
    // ...
    }
    for rows.Next() {
        // do what you will
    }
    // Handle the error returned from context cancellation and deadline expiration separately
    // from normal errors so we can run the cancel logic.
    // Can even handle them separately if you'd like.
    if err := rows.Err(); err == context.Canceled || err == context.DeadlineExceeded {
        killQuery := fmt.Sprintf("CALL system.runtime.kill_query('%s')", queryID)
        if err := db.Exec(killQuery); err != nil {
            // something went wrong cancelling
            return err
        }
     } else if err != nil {
         // all other errors
        return err
     }

     return nil
}

from presto-go-client.

meysampg avatar meysampg commented on June 2, 2024

@ryantking Brilliant! Thanks!

from presto-go-client.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.