<!-- markdown css tag --><div class="pinggu_markdown">
<div class="pinggu_markdown__html"><pre class=" language-sql"><code class="prism language-sql"><span class="token keyword">SELECT</span>
EVENT_DATE<span class="token punctuation">,</span>
<span class="token function">COUNT</span><span class="token punctuation">(</span>USER_ID<span class="token punctuation">)</span> <span class="token keyword">OVER</span><span class="token punctuation">(</span><span class="token keyword">ORDER</span> <span class="token keyword">BY</span> EVENT_DATE RANGE <span class="token operator">between</span> <span class="token number">6</span> <span class="token keyword">preceding</span> <span class="token operator">and</span> <span class="token keyword">current</span> <span class="token keyword">row</span><span class="token punctuation">)</span> <span class="token keyword">as</span> WAU
<span class="token keyword">FROM</span><span class="token punctuation">(</span>
<span class="token keyword">SELECT</span> <span class="token keyword">DISTINCT</span>
EVENT_DATE<span class="token punctuation">,</span>
USER_ID
<span class="token keyword">FROM</span> FACT_USER_SESSIONS_DAY
<span class="token punctuation">)</span>
</code></pre>
<p><font color="red" size="6">问题:</font></p>
<blockquote>
<p>如图所示,我想提取给定日期(EVENT_DATE)及前6天内,出现的用户数,但代码出现以下报错:<br>
“SQL compilation error: error in query Sliding window fr ame unsupported for function ROW_NUMBER”<br>
但是如果我使用rows between, 就能正确运行,但这并不是我想要的,因此我想询问一下,这个问题该如何解决,我已经谷歌了一下午了。。。</p>
</blockquote>
</div>
</div>