时间戳

首页 > 解决方案 > 雪花视图 - 组语法编译错误

sql - 雪花视图 - 组语法编译错误

问题描述

我刚刚开始探索 Snowflake 并试图创建我的第一个视图。

我在分组时收到以下语法错误。谁能在这里指导我我错过了什么？

create or replace view MyView_V1 as 
    select     sum(NUMBER_OF_RECORDS) as total_records, 
               date_part(month, "DATE") as extracted_month, 
               date_part(week, "DATE") as  extracted_week, 
    from        "MV_DB"."MV_SCHEMA"."MV_TABLE",
    group by     extracted_month, extracted_week, 
    order by     extracted_month asc,extracted_week asc;

错误： SQL 编译错误：位置 0 处的语法错误第 6 行意外“来自”。位置 0 的第 7 行语法错误意外的“组”。位置 0 的第 8 行语法错误意外的“订单”。

谢谢你，阿克沙特

标签： sqlsnowflake-cloud-data-platformsnowsql

解决方案

请删除 from 子句前的逗号并执行查询。

    create or replace view MyView_V1 as 
        select     sum(NUMBER_OF_RECORDS) as total_records, 
                   date_part(month, "DATE") as extracted_month, 
                   date_part(week, "DATE") as  extracted_week
        from        "MV_DB"."MV_SCHEMA"."MV_TABLE"
        group by     extracted_month, extracted_week
        order by     extracted_month asc,extracted_week asc;

推荐阅读