For example: hive> select mid, tag1, tag2, dt from message_use_tags where dt="20211107" and (tag1 != ” or tag2 != ‘NULL’) limit 50; I want to specify: date = ‘20211107’ tag1 and tag2 can’t be both empty string at the same time. One of them can be empty. However, the following doesn’t achieve the purpose: tag1… Read More How to select rows with one of two column values can't be null?

I have the following table. date location_id type_id other_id 01/01/2021 1 22 3 01/01/2021 1 22 5 01/01/2021 2 1 1 15/01/2021 2 1 1 22/01/2021 1 22 1 01/02/2021 1 1 1 01/02/2021 1 22 1 I would like to count the number of records per year/month based on location_id and type_id. My desired… Read More Count records per year and month based on date & id