Skip to content

Commit 19396db

Browse files
alpinegizmofhueske
authored andcommitted
fix example of a regular join on dynamic tables
1 parent d892e74 commit 19396db

File tree

1 file changed

+2
-2
lines changed

1 file changed

+2
-2
lines changed

README.md

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -290,7 +290,7 @@ SET execution.type=streaming;
290290
```
291291

292292
```
293-
USE CATALOG default_catalog;
293+
USE CATALOG hive;
294294
```
295295

296296
```
@@ -299,7 +299,7 @@ SELECT
299299
o_orderpriority AS `priority`,
300300
COUNT(DISTINCT c_custkey) AS `number_of_customers`,
301301
COUNT(o_orderkey) AS `number_of_orders`
302-
FROM prod_orders
302+
FROM default_catalog.default_database.prod_orders
303303
JOIN prod_customer ON o_custkey = c_custkey
304304
JOIN prod_nation ON c_nationkey = n_nationkey
305305
JOIN prod_region ON n_regionkey = r_regionkey

0 commit comments

Comments
 (0)