[ https://issues.apache.org/jira/browse/CASSANDRA-7458?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jonathan Ellis updated CASSANDRA-7458: -------------------------------------- Description: Indexing information derived from the row can be powerful. For example, using the hypothetical {{extract_date}} function, {code} create table ticks ( symbol text, ticked_at datetime, price int, tags set<text>, PRIMARY KEY (symbol, ticked_at) ); CREATE INDEX ticks_by_day ON ticks(extract_date(ticked_at)); {code} http://www.postgresql.org/docs/9.3/static/indexes-expressional.html was: Indexing information derived from the row can be powerful. For example, using the hypothetical {{extract_date}} function, {code} create table ticks ( symbol text, ticked_at datetime, price int, tags set<text>, PRIMARY KEY (symbol, ticked_at) ); CREATE INDEX ticks_by_day ON ticks(extract_date(ticked_at)); {code} See also http://www.postgresql.org/docs/9.3/static/sql-createindex.html > functional indexes > ------------------ > > Key: CASSANDRA-7458 > URL: https://issues.apache.org/jira/browse/CASSANDRA-7458 > Project: Cassandra > Issue Type: New Feature > Components: API, Core > Reporter: Jonathan Ellis > Fix For: 3.0 > > > Indexing information derived from the row can be powerful. For example, > using the hypothetical {{extract_date}} function, > {code} > create table ticks ( > symbol text, > ticked_at datetime, > price int, > tags set<text>, > PRIMARY KEY (symbol, ticked_at) > ); > CREATE INDEX ticks_by_day ON ticks(extract_date(ticked_at)); > {code} > http://www.postgresql.org/docs/9.3/static/indexes-expressional.html -- This message was sent by Atlassian JIRA (v6.2#6252)