我该如何在Hive中查询同一表的多个分区?是否可以在同一条命令中实现?
类似于以下语法:???
类似于以下语法:???
SELECT * FROM mytable WHERE partition ='first_partition' and partition='second_partition'
page_views
按列date
进行分区,则以下查询仅检索2008-03-01
和2008-03-31
之间的日期行。SELECT page_views.*
FROM page_views
WHERE page_views.date >= '2008-03-01' AND page_views.date <= '2008-03-31'
SELECT * FROM mytable WHERE column_one ='first_partition' and column_two ='second_partition'