I use amazon redshift and sometimes the query execution hangs without any error messages e.g. this query will execute:
select extract(year from date), extract(week from date),count(*) from some_table where date>'2015-01-01 00:00:00' and date<'2015-12-31 23:59:59' group by extract(year from date), extract(week from date)
and this not:
select extract(year from date), extract(week from date),count(*) from some_table where date>'2014-01-01 00:00:00' and date<'2014-12-27 23:59:59' group by extract(year from date), extract(week from date)
But it happens only when I deploy project to server and on my local machine all queries executed without any problems.
I already set in my code autoCommit=true
for connection. Also all things listed above I do with grails using this library
compile 'com.amazonaws:aws-java-sdk-redshift:1.9.39'
Any ideas?
Aucun commentaire:
Enregistrer un commentaire