subject:"select count\(\*\) return wrong row counts"

Re: select count(*) return wrong row counts

2016-03-02 Thread Mich Talebzadeh

This works fine scala> sql("use oraclehadoop") res1: org.apache.spark.sql.DataFrame = [result: string] scala> sql("select count(1) from sales").show +---+ |_c0| +---+ |4991761| +---+ You can do "select count(*) from tablename") as it is not dynamic sql. Does it actually work?

select count(*) return wrong row counts

2016-03-02 Thread Jesse F Chen

I am finding a strange issue with Spark SQL where "select count(*) " returns wrong row counts for certain tables. I am using TPCDS tables, so here are the actual counts: Row