You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@iceberg.apache.org by "ajantha-bhat (via GitHub)" <gi...@apache.org> on 2024/03/07 12:26:23 UTC
[I] Show view when no views exist show return empty result [iceberg]
ajantha-bhat opened a new issue, #9893:
URL: https://github.com/apache/iceberg/issues/9893
### Apache Iceberg version
main (development)
### Query engine
Spark
### Please describe the bug 🐞
spark-sql (default)> show views in nessie.db3;
24/03/07 17:52:19 WARN ObjectStore: Failed to get database global_temp, returning NoSuchObjectException
Time taken: 0.107 seconds
It should return empty result when view is not created before.
I checked the same after creating the view. It passes.
```
spark-sql (default)> create view nessie.db3.v1 as select * from nessie.db3.t1;
Time taken: 0.566 seconds
spark-sql (default)> select * from nessie.db3.v1;
42
43
Time taken: 0.974 seconds, Fetched 2 row(s)
spark-sql (default)> show views in nessie.db3;
db3 v1 false
Time taken: 0.11 seconds, Fetched 1 row(s)
spark-sql (default)>
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org
Re: [I] Show view when no views exist show return empty result [iceberg]
Posted by "ajantha-bhat (via GitHub)" <gi...@apache.org>.
ajantha-bhat commented on issue #9893:
URL: https://github.com/apache/iceberg/issues/9893#issuecomment-1983421272
I think it is giving empty result, just that this warning message confused me. I don't think we can remove this warning.
`24/03/07 17:52:19 WARN ObjectStore: Failed to get database global_temp, returning NoSuchObjectException
`
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org
Re: [I] Show view when no views exist show return empty result [iceberg]
Posted by "ajantha-bhat (via GitHub)" <gi...@apache.org>.
ajantha-bhat closed issue #9893: Show view when no views exist show return empty result
URL: https://github.com/apache/iceberg/issues/9893
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org