mardi 2 juin 2015

Amazon Redshift: query execution hangs

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