[jira] [Created] (ASTERIXDB-1837) Need to extend and clean-up SQL++ and AQL Primers (101s)

[Michael J. Carey (JIRA)]

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

             Summary: Need to extend and clean-up SQL++ and AQL Primers (101s)
                 Key: ASTERIXDB-1837
                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1837
             Project: Apache AsterixDB
          Issue Type: Bug
            Reporter: Michael J. Carey
            Assignee: Michael J. Carey


Might add some/all of these, as well as maybe drop the stuff about hints.
USE TinySocial;

-- Find chirps whose referred topics list includes "iphone"
-- using the SQL++ IN operator

SELECT VALUE cm
FROM ChirpMessages cm
WHERE "iphone" IN cm.referredTopics;

-- Find chirps whose referred topics list includes "iphone"
-- using existential quantification in SQL++

SELECT VALUE cm
FROM ChirpMessages cm
WHERE SOME rt IN cm.referredTopics SATISFIES rt = "iphone";

-- Print a topic-ordered list of the user name/referred topic
-- pairs for Chirp messages

SELECT DISTINCT cm.user.screenName, rt
FROM ChirpMessages cm, cm.referredTopics rt
ORDER BY rt;




--
This message was sent by Atlassian JIRA
(v6.3.15#6346)