Find last day of a month in Hive

by

As of Hive 1.1.0, last_day(string date) function is available.

last_day(string date)

Returns the last day of the month which the date belongs to. date is a string in the format ‘yyyy-MM-dd HH:mm:ss’ or ‘yyyy-MM-dd’. The time part of date is ignored.

More Related Contents:

  1. HIVE select count(*) non null returns higher value than select count(*)
  2. Explode (transpose?) multiple columns in Spark SQL table
  3. Hive query performance for high cardinality field
  4. Hive – Unpivot functionality in hive
  5. Insert local .csv data in remote SQL Server via already working connection string
  6. I want to search job and salary from employee table but I am getting error like invalid relational operator [closed]
  7. Which is faster/best? SELECT * or SELECT column1, colum2, column3, etc
  8. Is SQL syntax case sensitive?
  9. How to use ANY instead of IN in a WHERE clause?
  10. Simple Query to Grab Max Value for each ID
  11. Constraint defined DEFERRABLE INITIALLY IMMEDIATE is still DEFERRED?
  12. How to find the employee with the second highest salary?
  13. SQL Server 2008: how do I grant privileges to a username?
  14. Including null values in an Apache Spark Join
  15. How to Implement Referential Integrity in Subtypes
  16. Equivalent function for DATEADD() in Oracle
  17. How do I do multiple CASE WHEN conditions using SQL Server 2008?
  18. How to get other columns when using Spark DataFrame groupby?
  19. Is there AUTO INCREMENT in SQLite?
  20. Name database design notation you prefer and why?
  21. Incorrect syntax near ”
  22. INNER JOIN in UPDATE sql for DB2
  23. How to delete duplicate rows with SQL?
  24. Best way to test SQL queries [closed]
  25. sql query if parameter is null select all
  26. What does a (+) sign mean in an Oracle SQL WHERE clause? [duplicate]
  27. Temporal database design, with a twist (live vs draft rows)
  28. SQL query with distinct and sum
  29. How do I perform update query with subquery in Access?
  30. Why do SQL Server Scalar-valued functions get slower?

Leave a Comment