[
https://issues.apache.org/jira/browse/ASTERIXDB-1837?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Michael J. Carey updated ASTERIXDB-1837:
----------------------------------------
Component/s: Documentation
AsterixDB
> 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
> Components: AsterixDB, Documentation
> 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)
