hadoop - 配置单元错误:没有匹配方法

Question

我正在 hive 中执行CTAS查询，如下所述:

create table ps_agg
as select host, count(*) c, sum(l4_ul_throughput+l4_dw_throughput) usg from ops.isop
where
cast(cast(from_unixtime(begin_time) as TIMESTAMP) AS DATE) >= '2016-08-01' & 
cast(cast(from_unixtime(begin_time) as TIMESTAMP) AS DATE) < '2016-09-01'
group by host;

其中 host, begin_time, l4_ul_throughput和 l4_dw_throughput是ISOP表中存在的列。

我在运行此查询时收到的错误是:

Wrong arguments 'begin_time' : No matching method for class org.apache.hadoop.hive.ql.udf.UDFOPBitAnd with (string, timestamp).

begin_time是表中的 int类型。

我不知道出什么事了。有人可以提出解决方案吗？

Answer 1

这个问题解决了；这是一个语法错误。

更正了语法:

create table ps_agg
as select host, count(*) c, sum(l4_ul_throughput+l4_dw_throughput) usg from ops.isop
where
cast(cast(from_unixtime(begin_time) as TIMESTAMP) AS DATE) >= '2016-08-01' AND
cast(cast(from_unixtime(begin_time) as TIMESTAMP) AS DATE) < '2016-09-01'
group by host;