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

SHOW TABLES does not work for hidden tpch, tpcds schemas #1005

Closed
findepi opened this issue Jun 15, 2019 · 1 comment

Comments

2 participants
@findepi
Copy link
Member

commented Jun 15, 2019

tpch."sf3000.0" definitely exists:

presto> select * from tpch."sf3000.0".nation limit 1;
 nationkey |  name   | regionkey |                       comment
-----------+---------+-----------+-----------------------------------------------------
         0 | ALGERIA |         0 |  haggle. carefully final deposits detect slyly agai
(1 row)

but one cannot see tables in that schema:

presto> show tables from tpch."sf3000.0";
Query 20190615_143150_00028_gwaqu failed: line 1:1: Schema 'sf3000.0' does not exist
io.prestosql.sql.analyzer.SemanticException: line 1:1: Schema 'sf3000.0' does not exist
	at io.prestosql.sql.rewrite.ShowQueriesRewrite$Visitor.visitShowTables(ShowQueriesRewrite.java:192)
	at io.prestosql.sql.rewrite.ShowQueriesRewrite$Visitor.visitShowTables(ShowQueriesRewrite.java:150)
	at io.prestosql.sql.tree.ShowTables.accept(ShowTables.java:72)
	at io.prestosql.sql.tree.AstVisitor.process(AstVisitor.java:27)
	at io.prestosql.sql.rewrite.ShowQueriesRewrite.rewrite(ShowQueriesRewrite.java:147)
	at io.prestosql.sql.rewrite.StatementRewrite.rewrite(StatementRewrite.java:53)
	at io.prestosql.sql.analyzer.Analyzer.analyze(Analyzer.java:73)
	at io.prestosql.sql.analyzer.Analyzer.analyze(Analyzer.java:68)
@Praveen2112

This comment has been minimized.

Copy link
Member

commented Jun 15, 2019

@findepi Can I take up this issue ?

@Praveen2112 Praveen2112 self-assigned this Jun 15, 2019

@findepi findepi closed this in #1007 Jul 2, 2019

@findepi findepi added this to the 316 milestone Jul 2, 2019

@findepi findepi referenced this issue Jul 2, 2019

Closed

Release notes for 316 #1000

5 of 6 tasks complete
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.