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

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

Michael J. Carey created ASTERIXDB-3012:
-------------------------------------------

             Summary: 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
             Fix For: 0.9.7
         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)