例
仮想テーブルを作成する
curl -d "[\"CREATE VIRTUAL TABLE /services/databases/PUB3/link1 SET TARGET /shared/examples/ds_orders/tutorial/customers SET ANNOTATION 'this is a published table'\"]"
-u "admin:admin"
-X POST "http://localhost:9400/rest/execute/v1/actions/dsl/invoke"
-H "Content-Type:application/json"
仮想プロシージャを作成する
curl -d "[\"CREATE VIRTUAL PROCEDURE /services/databases/PUB3/link2 SET TARGET /shared/examples/LookupProduct SET ANNOTATION 'this is a published procedure'\"]"
-u "admin:admin"
-X POST "http://localhost:9400/rest/execute/v1/actions/dsl/invoke"
-H "Content-Type:application/json"
仮想テーブルの名前の変更と再配置を行う
//only rename
curl -d "[\"ALTER VIRTUAL TABLE /services/databases/PUB3/link1 RELOCATE TO /services/databases/PUB3/renamedlink1 SET ANNOTATION 'altered virtual table'\"]"
-u "admin:admin"
-X POST "http://localhost:9400/rest/execute/v1/actions/dsl/invoke"
-H "Content-Type:application/json"
//Both rename and relocate
curl -d "[\"ALTER VIRTUAL TABLE /services/databases/PUB3/link1 RELOCATE TO /services/databases/publishedDB/renamedlink1 SET ANNOTATION 'altered virtual table'\"]"
-u "admin:admin"
-X POST "http://localhost:9400/rest/execute/v1/actions/dsl/invoke"
-H "Content-Type:application/json"
注釈の設定を解除する
curl -d "[\"ALTER VIRTUAL TABLE /services/databases/PUB3/link1 SET ANNOTATION NULL\"]"
-u "admin:admin"
-X POST "http://localhost:9400/rest/execute/v1/actions/dsl/invoke"
-H "Content-Type:application/json"
仮想テーブルターゲットを変更する
curl -d "[\"ALTER VIRTUAL TABLE /services/databases/PUB3/link1 SET TARGET /shared/examples/ds_orders/tutorial/employees SET ANNOTATION 'altered virtual procedure with table target'\"]"
-u "admin:admin"
-X POST "http://localhost:9400/rest/execute/v1/actions/dsl/invoke"
-H "Content-Type:application/json"
仮想テーブルを削除する
curl -d "[\"DROP VIRTUAL TABLE /services/databases/PUB3/link1\"]"
-u "admin:admin"
-X POST "http://localhost:9400/rest/execute/v1/actions/dsl/invoke"
-H "Content-Type:application/json"
存在する場合は仮想プロシージャを削除する
curl -d "[\"DROP VIRTUAL PROCEDURE IF EXISTS /services/databases/PUB3/link2\"]"
-u "admin:admin"
-X POST "http://localhost:9400/rest/execute/v1/actions/dsl/invoke"
-H "Content-Type:application/json"
仮想テーブルのプロパティを取得する
curl -u "admin:admin" -X POST "http://localhost:9400/rest/execute/v1/actions/query/invoke" -H "Content-Type:application/json"
-d "{\"query\":\"SELECT * FROM model.ALL_RESOURCE_PROPERTIES props
WHERE metadata_id = (SELECT table_id FROM model.ALL_TABLES where table_name = 'link1' and parent_path='/services/databases/publishedDB')\",
\"standardSQL\":true}"