[sqlalchemy] Redshift - approximate count

2015-04-03 Thread Kristi Tsukida
Redshift supports a modifier approximate as in SELECT APPROXIMATE COUNT(*) FROM my_table; Is there a way to get this with func.count()? Thanks -Kristi http://docs.aws.amazon.com/redshift/latest/dg/r_COUNT.html -- You received this message because you are subscribed to the Google Groups

Re: [sqlalchemy] Redshift - approximate count

2015-04-03 Thread Mike Bayer
I think you can get this with select.prefix_with(): http://docs.sqlalchemy.org/en/rel_0_9/core/selectable.html?highlight=prefix#sqlalchemy.sql.expression.Select.prefix_with On 4/3/15 8:22 PM, Kristi Tsukida wrote: Redshift supports a modifier approximate as in SELECT APPROXIMATE COUNT(*)