drill jdbc driver for status of query

[krishna mahadevan <kr...@gmail.com>]

Hi,

I am trying to run a drill query to create a table using CTAS. I am able to
do it success fully using webUI. But when i am trying to run the same query
using drill jdbc only a part of the actual data is saved in the json file.
My solution i thought was to save the full data and then retreive it. For
the same purpose i need to get the state of the query. is there a way to to
get the state using drill jdbc driver?

statement.executeQuery(query);

should return RUNNING/FAILED/COMPLETED

Thanks in Advance

Krishna

Re: drill jdbc driver for status of query

[Laurent Goujon <la...@dremio.com>]

the JDBC api is synchronous, so your call won't return until the query
completes or fails. If it fails, it should then throw a SQLException with
the reason for the failure.

Laurent

On Wed, Oct 26, 2016 at 1:39 AM, krishna mahadevan <kr...@gmail.com>
wrote:

> Hi,
>
> I am trying to run a drill query to create a table using CTAS. I am able to
> do it success fully using webUI. But when i am trying to run the same query
> using drill jdbc only a part of the actual data is saved in the json file.
> My solution i thought was to save the full data and then retreive it. For
> the same purpose i need to get the state of the query. is there a way to to
> get the state using drill jdbc driver?
>
> statement.executeQuery(query);
>
> should return RUNNING/FAILED/COMPLETED
>
> Thanks in Advance
>
> Krishna
>