Named Object
Syntax
<Object Definition> as <ObjectName>
Named object is an object with an explicit name. Currently, the named object is limited to vectors. When a vector is bound to a variable, the vector will implicitly use the variable name as the vector object name.
Example
(1) create a table
$ t = table(1..5 as id, rand(100, 5) as price);
$ t;
// t.id and t.price are named objects.
id |
price |
---|---|
1 |
34 |
2 |
33 |
3 |
28 |
4 |
84 |
5 |
6 |
(2) SQL query
select price as x from t;
x |
---|
34 |
33 |
28 |
84 |
6 |
(3) plot
$ plot([1..10 as x, 21..30 as y], 2016.10.01..2016.10.10 as date)