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

Hive VIEW with char(n) fails with "View is stale; it must be re-created" #6234

Open
findepi opened this issue Dec 7, 2020 · 0 comments
Open
Labels
bug Something isn't working

Comments

@findepi
Copy link
Member

findepi commented Dec 7, 2020

Hive

CREATE TABLE min_test_case_tbl(col1 char(1));

CREATE VIEW `min_test_case_vw`
AS select col1 from min_test_case_tbl;

Presto

presto:default> select * from min_test_case_vw;
Query 20201207_213331_00003_z2n4s failed: line 1:15: View 'hive.default.min_test_case_vw' is stale or in invalid state:
    column [col1] of type char(1) projected from query view at position 0 cannot be coerced to column [col1] of type varchar stored in view definition

(This is a regression in Presto 345)

@findepi findepi added the bug Something isn't working label Dec 7, 2020
@findepi findepi changed the title Hive VIEW with char(n) return type fails with "View is stale; it must be re-created" Hive VIEW with char(n) fails with "View is stale; it must be re-created" Dec 7, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Development

No branches or pull requests

1 participant