Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Bug] throw "Invalid data type for creating infinity:VARCHAR" error when do refresh mv #51238

Open
kobebryantlin0 opened this issue Sep 20, 2024 · 0 comments · May be fixed by #51240
Open

[Bug] throw "Invalid data type for creating infinity:VARCHAR" error when do refresh mv #51238

kobebryantlin0 opened this issue Sep 20, 2024 · 0 comments · May be fixed by #51240
Labels
type/bug Something isn't working

Comments

@kobebryantlin0
Copy link
Contributor

Steps to reproduce the behavior (Required)

CREATE MATERIALIZED VIEW test_mv
DISTRIBUTED BY HASH(index_code) BUCKETS 20
REFRESH ASYNC EVERY(INTERVAL 1 DAY) 
PARTITION BY str2date(dt, '%Y-%m-%d') 
PROPERTIES ( 
    "force_external_table_query_rewrite" = "TRUE"
)
AS select zb, index_code, dt from test_hive_table
where dt = "2024-09-16" and zb = "xxx";

execute refresh mv command

  refresh MATERIALIZED VIEW test_mv with sync mode;

Other info (Hive Column Type)

  dt -> string (Partition Column)
  zb-> string (Partition Column)
  index_code -> int 

Expected behavior (Required)

success

Real behavior (Required)

 throw error: Invalid data type for creating infinity: VARCHAR

StarRocks version (Required)

  • 3.3.2
@kobebryantlin0 kobebryantlin0 added the type/bug Something isn't working label Sep 20, 2024
@kevincai kevincai changed the title 【Bug】throw "Invalid data type for creating infinity:VARCHAR" error when do refresh mv [Bug] throw "Invalid data type for creating infinity:VARCHAR" error when do refresh mv Sep 24, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/bug Something isn't working
Projects
None yet
1 participant