<!-- 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>