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

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: *DB - AsterixDB, DOC - Documentation
• Assignee: Michael J. Carey
• Reporter: Michael J. Carey
• Created: 11/Mar/17 18:04
• Updated: 11/Mar/17 18:04

Description

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;