This statement creates the input table of clickstream data that the examples use:
CREATE TABLE clicks1 ( ts TIME, userid INTEGER, sessionid INTEGER pageid INTEGER, category INTEGER, val FLOAT, referrer VARCHAR (256) ) DISTRIBUTE BY HASH (category);
The following table summarizes the symbols and symbol predicates that the examples use.
| Symbol | Symbol Predicate |
|---|---|
| A | pageid IN (10, 25) |
| B | category = 10 OR (category = 20 AND pageid <> 33) |
| C | category IN (SELECT pageid FROM clicks1 GROUP BY userid HAVING COUNT(*) > 10) |
| D | referrer LIKE '%Amazon%' |
| X | true |