James Taylor 2013-10-25, 00:24
Ted Yu 2013-10-25, 00:40
Thanks, Ted. That was a typo which I've corrected. Yes, these are
references to columns from your primary table. It should have read like
CREATE INDEX my_index ON my_table (v2 DESC, v1) INCLUDE (v3)
On Thu, Oct 24, 2013 at 5:40 PM, Ted Yu <[EMAIL PROTECTED]> wrote:
> From https://github.com/forcedotcom/phoenix/wiki/Secondary-Indexing :
> Is date_col a column from data table ?
> CREATE INDEX my_index ON my_table (date_col DESC, v1) INCLUDE (v3)
> SALT_BUCKETS=10, DATA_BLOCK_ENCODING='NONE';
> On Thu, Oct 24, 2013 at 5:24 PM, James Taylor <[EMAIL PROTECTED]
> > The Phoenix team is pleased to announce the immediate availability of
> > Phoenix 2.1 .
> > More than 20 individuals contributed to the release. Here are some of the
> > new features
> > now available:
> > * Secondary Indexing  to create and automatically maintain global
> > indexes over your
> > primary table.
> > - Queries automatically use an index when more efficient, turning your
> > full table scans
> > into point and range scans.
> > - Multiple columns may be indexed in ascending or descending sort
> > - Additional primary table columns may be included in the index to
> > a covered
> > index.
> > - Available in two flavors:
> > o Server-side index maintenance for mutable data.
> > o Client-side index maintenance optimized for write-once,
> > append-only use cases.
> > * Row Value Constructors , a standard SQL construct to efficiently
> > locate the row at
> > or after a composite key value.
> > - Enables a query-more capability to efficiently step through your
> > - Optimizes IN list of composite key values to be point gets.
> > * Map-reduce based CSV Bulk Loader  to build Phoenix-compliant HFiles
> > and load
> > them into HBase.
> > * MD5 hash and INVERT built-in functions
> > Phoenix 2.1 requires HBase 0.94.4 or above, with 0.94.10 or above
> > for mutable secondary indexing. For the best performance, we recommend
> > HBase 0.94.12 or above.
> > Regards,
> > James
> > @JamesPlusPlus
> > http://phoenix-hbase.blogspot.com/
> >  https://github.com/forcedotcom/phoenix/wiki/Download
> >  https://github.com/forcedotcom/phoenix/wiki/Secondary-Indexing
> >  https://github.com/forcedotcom/phoenix/wiki/Row-Value-Constructors
> > 
Julian Zhou 2013-10-25, 00:29
Asaf Mesika 2013-10-28, 18:14
James Taylor 2013-10-28, 18:40