Question

spark sql怎么去获取hive 表一定日期范围内的数据

我现在需要去hive表当中读取数据，读取数据时是以日期为条件获取一个时间段内的数据，在hive当中操作是可以获取的但是在spark SQL当中获取不到。hive表操作语句是OK的，hive语句如下：
SELECT id,merchant_no,sku_id,stock_no,change_count,stock_count_snapshoot,create_time,order_id,stock_type,start_time FROM stock_data WHERE merchant_no='a69683' and cast(start_time as date) between '2017-09-01' and '2017-09-10';

Answer 1

select orderid,fenjian,timee
from
(
select orderid,fenjian,timee,row_number(orderid,fenjian) rn
from (
select orderid,fenjian,timee from tableName
distribute by orderid,fenjian sort by orderid,fenjian,timee asc
) t1
) t2
where t2.rn=1

追问

您好，能够详述一下吗