==作者：YB-Chi==

[toc]

时间分区表查询出指定日期(精确到天)的数据量

数据库有一列为

String sql = "select count(*) from "+libraryName+"."+schemaName+"." +tableName+" where to_char(OCCUR_TIME,'yyyy-mm-dd')='"+dateStr+"'";

小松鼠执行hive sql的时候出现missing EFO near…

注意sql栏的状态是否上边藏了几个sql，有的话清掉。

Hbase的sql时间查询 查询某天的 HAPPENTIME类型为:TIMESTAMP

select * from FJUDM4.HBASE_MD_OMS_T_COMBINEMONITOR_BUG where HAPPENTIME>=to_date('2016-10-12 00:00:00') and HAPPENTIME<to_date('2016-10-13 00:00:00')

hive的sql时间分区查询

select * from fjudm4.hbase_md_all_op_ctrl where occur_time >= 2016-11-01 and occur_time < 2016-11-02
没有加单引号报错

select * from fjudm4.hbase_md_all_op_ctrl where occur_time = '2016-11-01'
不可以直接用=

select * from fjudm4.hbase_md_all_op_ctrl where occur_time >= '2016-11-01' and occur_time < '2016-11-02'
正确语法