How to Timeout SQL queries?

[LiShangAn]

Hi,

Is there any way to set the cursor timeout to let the hive client wait for the query to execute?

cursor.Exec(ctx, "select * from table1")

Does the HiveConfiguration support this?

Thanks :)

[beltran]

Hello, not sure what you mean, I guess something like:

ctx, cancel := context.WithTimeout(context.Background(), time.Duration(value)*time.Seconds)
defer cancel()
cursor.Execute(ctx, "SELECT ...", false)

wouldn't work for you? That way you could set a timeout.

[LiShangAn]

Thank you :)

That's what i meant.