[jira] [Updated] (ASTERIXDB-3012) Samples from (typed) view datasets aren't working

["Michael J. Carey (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/ASTERIXDB-3012?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Michael J. Carey updated ASTERIXDB-3012:
----------------------------------------
    Fix Version/s: 0.9.8
                       (was: 0.9.7)

> Samples from (typed) view datasets aren't working
> -------------------------------------------------
>
>                 Key: ASTERIXDB-3012
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-3012
>             Project: Apache AsterixDB
>          Issue Type: Bug
>          Components: UI - Web Interface
>    Affects Versions: 0.9.7
>            Reporter: Michael J. Carey
>            Assignee: Miles Hong
>            Priority: Major
>             Fix For: 0.9.8
>
>         Attachments: doncdata.sqlpp
>
>
> The metadata brower's sample feature (when you click on a dataset name) comes up empty for typed views (and perhaps for untyped views, I didn't try that yet).
> Here are some view definitions to try this against [^doncdata.sqlpp]with the DonCData example dataverse (which can be created using the attached DDL).
> USE DonCData; 
> -- FLATTEN CUSTOMERS
> CREATE VIEW customers_view (
>   custid STRING, name STRING, rating BIGINT, adr_street STRING, adr_city STRING, adr_zipcode STRING) 
> DEFAULT NULL
> PRIMARY KEY (custid) NOT ENFORCED
> AS 
>   SELECT custid, name, rating, address.street AS adr_street, address.city AS adr_city, address.zipcode AS adr_zipcode 
>   FROM customers;
> -- FLATTEN ORDERS
> CREATE VIEW orders_view (orderno BIGINT, custid STRING, order_date DATE, ship_date DATE) 
> DEFAULT NULL
> PRIMARY KEY (orderno) NOT ENFORCED
> FOREIGN KEY (custid) REFERENCES customers_view NOT ENFORCED
> AS 
>   SELECT orderno, custid, order_date, ship_date FROM orders;
> -- FLATTEN ITEMS
> CREATE VIEW items_view (orderno BIGINT, itemno BIGINT, item_qty BIGINT, item_price DOUBLE) 
> DEFAULT NULL
> PRIMARY KEY (orderno, itemno) NOT ENFORCED
> FOREIGN KEY (orderno) REFERENCES orders_view NOT ENFORCED
> AS
>   SELECT o.orderno, i.itemno, i.qty AS item_qty, i.price AS item_price
>   FROM orders AS o UNNEST o.items AS i;
> -- CHECK OUT FLAT VIEW CONTENTS
> SELECT VALUE v FROM customers_view v;
> SELECT VALUE v FROM orders_view v;
> SELECT VALUE v FROM items_view v;



--
This message was sent by Atlassian Jira
(v8.20.1#820001)