Skip to content

Query execution using jdbc driver 3.2 logs warning

0

I'm using Athena JDBC driver 3.2 (uberjar) to execute queries in clojure. Queries that I execute produce expected results, but also log waning that I'm unable to resolve.

Example query:

(with-open [conn (jdbc/get-connection
                    {:classname      "com.amazon.athena.jdbc.AthenaDriver"
                     :subprotocol    "athena"
                     :subname        (str "//athena." endpoint ":443")
                     :User           user
                     :Password       password
                     :OutputLocation output-location
                     :WorkGroup      workgroup
                     :Region         region
                     :LogLevel       "OFF"})]
    (let [stmt (.createStatement conn)
          rs (.executeQuery stmt "SELECT timestamp '2012-10-31 01:00 UTC' AT TIME ZONE 'America/Los_Angeles' AS la_time;")]
      (.next rs)
      (let [result (.getObject rs 1)]
        result)))

Warning:

; 2024-06-17 10:12:59,380 WARN results.PaginatingAsyncQueryResultsBase :: Items requested for query execution <ID>, but subscription is cancelled

I've consulted documentation for connection properties to use with the driver with no success.

Would you have an idea how to resolve the waning?

asked 2 years ago182 views
1 Answer
0

I have exactly the same warning on a classic java application. impossible to understand why.

And, as the slf4j is an old version in the driver, difficult to mute it.

answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.