drop schema failed #26652
Unanswered
A-little-bit-of-data
asked this question in
Q&A
drop schema failed
#26652
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
In trino version 430, if I run
CREATE schema test.sf1000
without specifying a location using the "with" clause, then usingshow create schema test.sf1000
results inCREATE SCHEMA test.sf1000 WITH (location = 'file:/user/hive/warehouse/sf1000.db').
In version 476, the same process works fine, but when I use "
drop schema test.sf1000
" the 430 version can delete the file, but version 476 reports the errortrino error: No factory for location: file:/user/hive/warehouse/sf1000.db.
Why is this happening?If I forgot to specify a location during development, can't I just delete and recreate it? What I actually need is
CREATE SCHEMA test.sf1000 WITH (location = 's3a://dev/warehouse/sf1000').
Beta Was this translation helpful? Give feedback.
All reactions