https://community.cloudera.com/t5/Archives-of-Support-Questions/Do-secondary-indexes-require-that-all-rows-have-values-for/m-p/160788#M24668 <P>Two questions.</P><P>1) Yes if data is upsert via Phoenix. HBase does not store null values in cells, however, Phoenix enters some dummy/empty values in order to be able to select all rows associated with a column. There was a bug couple years that was fixed: PHOENIX-63.</P><P>2) No. Even dynamic columns are defined after the table in the FROM clause on a SELECT statement, they are just encoded binary and only understood at the runtime. Indexes are populated on CREATE INDEX on explicit columns. You could get creative by using a virtual column, but that would require more storage and some tricks on the actual SQL and performance may be bad.</P> Fri, 22 Apr 2016 02:40:51 GMT cstanca 2016-04-22T02:40:51Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Do-secondary-indexes-require-that-all-rows-have-values-for/m-p/160787#M24667 <P>Can I add a secondary index to a dynamic column defined as part of a view?</P> Fri, 08 Apr 2016 02:39:21 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Do-secondary-indexes-require-that-all-rows-have-values-for/m-p/160787#M24667 rgelhausen 2016-04-08T02:39:21Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Do-secondary-indexes-require-that-all-rows-have-values-for/m-p/160788#M24668 <P>Two questions.</P><P>1) Yes if data is upsert via Phoenix. HBase does not store null values in cells, however, Phoenix enters some dummy/empty values in order to be able to select all rows associated with a column. There was a bug couple years that was fixed: PHOENIX-63.</P><P>2) No. Even dynamic columns are defined after the table in the FROM clause on a SELECT statement, they are just encoded binary and only understood at the runtime. Indexes are populated on CREATE INDEX on explicit columns. You could get creative by using a virtual column, but that would require more storage and some tricks on the actual SQL and performance may be bad.</P> Fri, 22 Apr 2016 02:40:51 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Do-secondary-indexes-require-that-all-rows-have-values-for/m-p/160788#M24668 cstanca 2016-04-22T02:40:51Z