Below is my table description.
hive> describe dbsize; OK db_name string location string size_in_mb string size_in_gb string date string
# Partition Information # col_name data_type comment
date string Time taken: 0.335 seconds, Fetched: 10 row(s)
Have to mins the column size_in_mb with different date in where condition.
Having sample sql query for rdbms environment.
select DB_NAME, LOCATION, c2-c1 "difference size in MB", c4-c3 "difference size in GB" from dbsize (select size_in_mb c1 from dbsize where date='01-23-2020'), (select size_in_mb c2 from dbsize where date='01-25-2020'), (select size_in_gb c3 from dbsize where date='01-23-2020'), (select size_in_gb c4 from dbsize where date='01-25-2020');
Need help on hive hql query to mins the columns for two different dates. In same single table.
Please advise me.
... View more
