if语句在bigquery中 [英] if clause in bigquery

问题描述

我有一个（联合）查询按预期工作。但是，只要我添加以下列，它不会显示任何结果，也不会完成。 （查询运行计数器不断增加）

pre code> IF（（d.network_type包含'_user'AND d.is_network = 1），s .impressions，0）AS effimp

有没有其他的方法可以优化这个？

---

完整查询如下，当我在上个月试过时，它正在工作。

  SELECT s.date_time AS date_time，s.requests AS请求，s.impressions AS印象，s.clicks AS点击，s.conversions AS转换，
 IF （（d.network_type包含'_user'AND d.is_network = 1），s.impressions，0）AS effimp，s.total_revenue AS total_revenue，
 s.total_basket_value AS total_basket_value，s.total_num_items AS total_num_items，s。 zone_id as zone_id 
 FROM company.ox_data_summary s 
 INNER JOIN company.ox_banners1 AS d ON d.bannerid = s.ad_id 
限制100 
  

查询失败
错误：意外。请重试。

如果我删除了IF子句，它确实有效。

解决方案

div>

看起来你正遇到查询处理错误，我们正在调查。

I have a (join) query that works as expected. But as soon as I add the following column, it does not show any results nor does it complete. (Query running counter keeps growing)

IF((d.network_type contains  '_user' AND d.is_network=1),s.impressions,0) AS effimp

Is there any other way to optimize this?

---

The full query is as follows and it was working when I tried it in the last month.

SELECT s.date_time AS date_time, s.requests AS requests, s.impressions AS impressions, s.clicks  AS clicks, s.conversions AS conversions,
       IF((d.network_type contains  '_user' AND d.is_network=1),s.impressions,0) AS effimp, s.total_revenue AS total_revenue, 
        s.total_basket_value AS total_basket_value , s.total_num_items AS  total_num_items , s.zone_id as zone_id
FROM company.ox_data_summary s
INNER JOIN company.ox_banners1 AS d ON d.bannerid=s.ad_id 
limit 100 

Query Failed Error: Unexpected. Please try again.

If I remove the "IF clause it does work.

解决方案

Looks like you're hitting a query processing bug. We're investigating.

这篇关于if语句在bigquery中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！