【详述】有一个实时表，在数仓dwd层对他做物化视图
【SQL】 CREATE MATERIALIZED VIEW dws.dws_table_name_realtime AS
SELECT
tenant_id
, statistics_date
, market_id
, id
, msku
FROM ods.table_name
创建时报错：[1064] [42000]: create materialized failed. table:table_name not exist
表查询是没有问题的
【StarRocks版本】2.4
请确认下库名是否正确，table_name 表的建表请发下
库名是没问题的，仅执行查询语句正常。
建表语句
CREATE TABLE ods.ods_e_sales_operations
(
tenant_id Int ,
statistics_date Datetime ,
market_id Int ,
id Bigint ,
msku Varchar(65533) ,
spu Varchar(65533) ,
asin Varchar(65533) ,
market_id_msku Varchar(65533) ,
server_id Int ,
warehouse_id Int ,
country Int ,
currency Varchar(65533) ,
product_name Varchar(65533) ,
brand Varchar(65533) ,
category Varchar(65533) ,
sku Varchar(65533) ,
variation_asin Varchar(65533) ,
listing_state Varchar(65533) ,
listing_level Varchar(65533) ,
crawl_title Varchar(65533) ,
first_sales_date Datetime ,
add_date Datetime ,
update_date Datetime ,
create_time Datetime ,
order_product_sales Decimal(20, 8) ,
order_product_sales_b2b Decimal(20, 8) ,
orders Int ,
order_items Int ,
order_items_b2b Int ,
units_ordered Int ,
units_ordered_b2b Int ,
units_ordered_traffic Int ,
patch_units_ordered Int ,
multi_channel_orders Int ,
refunds Int ,
returns Int ,
returns_sellable Int ,
returns_purchase_cost Decimal(20, 8) ,
returns_arrive_cost Decimal(20, 8) ,
refund_cost Decimal(20, 8) ,
return_product_sales Decimal(20, 8) ,
refund_discount_cost Decimal(20, 8) ,
refund_tax_cost Decimal(20, 8) ,
order_ids Varchar(65533) ,
ads_impressions Int ,
ads_clicks Int ,
ads_orders Int ,
ads_item_orders Int ,
ads_sales Decimal(20, 8) ,
ads_item_sales Decimal(20, 8) ,
ads_spend Decimal(20, 8) ,
sessions Int ,
page_views Int ,
buy_box_percentage Decimal(12, 2) ,
commission_cost Decimal(20, 8) ,
shipping_cost Decimal(20, 8) ,
fba_shipping_cost Decimal(20, 8) ,
shipping_charge Decimal(20, 8) ,
discount_cost Decimal(20, 8) ,
amazon_tax Decimal(20, 8) ,
others_cost Decimal(20, 8) ,
purchase_cost Decimal(20, 8) ,
arrive_cost Decimal(20, 8) ,
product_shipping_cost Decimal(20, 8) ,
vat_cost Decimal(20, 8) ,
sales_gross_profit Decimal(20, 8) ,
sales_net_profit Decimal(20, 8) ,
patch_amazon_cost Decimal(20, 8) ,
patch_purchase_cost Decimal(20, 8) ,
patch_arrive_cost Decimal(20, 8) ,
patch_cost Decimal(20, 8) ,
multichannel_amazon_cost Decimal(20, 8) ,
multichannel_purchase_cost Decimal(20, 8) ,
multichannel_arrive_cost Decimal(20, 8) ,
multichannel_cost Decimal(20, 8) ,
bogus_orders Int ,
bogus_quantity Int ,
bogus_sales_cost Decimal(20, 8) ,
bogus_others_cost Decimal(20, 8) ,
bogus_discount_cost Decimal(20, 8) ,
bogus_purchase_cost Decimal(20, 8) ,
bogus_arrive_cost Decimal(20, 8) ,
bogus_vat_cost Decimal(20, 8) ,
bogus_principal_price Decimal(20, 8) ,
bogus_price Decimal(20, 8) ,
storage_fee Decimal(20, 8) ,
platform_fee Decimal(20, 8) ,
total_revenue Decimal(20, 8) ,
total_spend Decimal(20, 8) ,
product_manager_account Varchar(65533) ,
product_manager_account_id Int ,
purchase_account Varchar(65533) ,
purchase_account_id Int ,
selling_manager_name Varchar(65533) ,
selling_manager_id Int ,
sessions_asin Int ,
page_views_asin Int ,
buy_box_percentage_asin Decimal(12, 2) ,
origin Tinyint ,
db Varchar(256) ,
table Varchar(256) ,
ts_ms Bigint ,
cost_origin Varchar(65533)
)
COMMENT ‘’ ENGINE = StarRocks;
库名没有问题，SQL查询是正常的，创建视图也没问题，只是创建物化视图报错
版本2.4.1
麻烦发下完整的建表语句，看您上面发的没有分区和分桶键，这样不好在本地测试