The SAS Scripting Wrapper for Analytics Transfer (SWAT) package is the R client to SAS Cloud Analytic Services (CAS). It allows users to execute CAS actions and process the results all from R.
Other
50
stars
22
forks
source link
retrieving count(*) from fedSQL query doesn't work correctly #30
When issuing a fedSQL group by query with count(*), the count(*) column that is retrieved has the same value in every row (correct value for first row).
Example:cas.fedSql.execDirect(conn, query="SELECT job, count(*) as cnt FROM casuser.hmeq GROUP BY job ORDER BY job;")
The correct result when using Python-swat:
conn.fedSql.execDirect(query="SELECT job, count(*) as cnt FROM casuser.hmeq GROUP BY job ORDER BY job;")
kesmit13
commented
3 years ago
Hi,
When issuing a fedSQL group by query with
count(*), thecount(*)column that is retrieved has the same value in every row (correct value for first row).Example:
cas.fedSql.execDirect(conn, query="SELECT job, count(*) as cnt FROM casuser.hmeq GROUP BY job ORDER BY job;")The correct result when using Python-swat:
conn.fedSql.execDirect(query="SELECT job, count(*) as cnt FROM casuser.hmeq GROUP BY job ORDER BY job;")