HIVE select count(*) non null returns higher value than select count(*)

by

Most probably your query without where is using statistics because of this parameter is set:

set hive.compute.query.using.stats=true;

Try to set it false and execute again.

Alternatively you can compute statistics on the table.
See ANALYZE TABLE SYNTAX

Also it’s possible to gather statistics during INSERT OVERWRITE automatically:

set hive.stats.autogather=true;

More Related Contents:

  1. Find last day of a month in Hive
  2. Explode (transpose?) multiple columns in Spark SQL table
  3. Hive query performance for high cardinality field
  4. Hive – Unpivot functionality in hive
  5. Get value based on max of a different column grouped by another column [duplicate]
  6. how do I query sql for a latest record date for each user
  7. How to implement LIMIT with SQL Server? [duplicate]
  8. converting Epoch timestamp to sql server(human readable format)
  9. What is atomicity in dbms
  10. Concat groups in SQL Server [duplicate]
  11. Pivoting rows into columns dynamically in Oracle
  12. Scope of temporary tables in SQL Server
  13. How to get Oracle create table statement in SQL*Plus
  14. Convert text value in SQL Server from UTF8 to ISO 8859-1
  15. How do I select all the columns from a table, plus additional columns like ROWNUM?
  16. Select a Column in SQL not in Group By
  17. How to do an inner join on row number in sql server
  18. SQL Server 2005 ROW_NUMBER() without ORDER BY
  19. SQL sum with condition
  20. Can an INNER JOIN offer better performance than EXISTS
  21. Different CURRENT_TIMESTAMP and SYSDATE in oracle
  22. incomplete information from query on pg_views [duplicate]
  23. How to create a pivot query in sql server without aggregate function
  24. IN vs. JOIN with large rowsets
  25. What does collation mean?
  26. How can I solve ORA-00911: invalid character error?
  27. Try_Convert for SQL Server 2008 R2
  28. SQL Server variable scope in a stored procedure
  29. converting int to real in sqlite
  30. What is difference between foreign key and reference key?

Leave a Comment