This is an automated email from the ASF dual-hosted git repository.
etudenhoefner pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/iceberg.git
The following commit(s) were added to refs/heads/main by this push:
new 09e6a9f7b8 Spec: Fix view example (#8966)
09e6a9f7b8 is described below
commit 09e6a9f7b8d733ca7a02c3933b8c88917bdb8477
Author: Ajantha Bhat <[email protected]>
AuthorDate: Fri Nov 10 17:01:58 2023 +0530
Spec: Fix view example (#8966)
---
format/view-spec.md | 4 +++-
1 file changed, 3 insertions(+), 1 deletion(-)
diff --git a/format/view-spec.md b/format/view-spec.md
index d6064787bf..4ba7c6cbc9 100644
--- a/format/view-spec.md
+++ b/format/view-spec.md
@@ -239,12 +239,14 @@
s3://bucket/warehouse/default.db/event_agg/metadata/00001-(uuid).metadata.json
```
Each change creates a new metadata JSON file.
+In the below example, the underlying SQL is modified by specifying the
fully-qualified table name.
```sql
USE prod.other_db;
CREATE OR REPLACE VIEW default.event_agg (
- event_count,
+ event_count COMMENT 'Count of events',
event_date)
+COMMENT 'Daily event counts'
AS
SELECT
COUNT(1), CAST(event_ts AS DATE)
