Good idea. Phoenix doesn't do that today. I'm hoping that HBase can come up with better block encodings that factor this kind of information out without perf taking a hit. They actually have one (TRIE), but I'm not sure how stable it is. Also, I'm not sure how well the existing encodings do for this (maybe good enough?).
Please file a JIRA. Thanks, James On Mon, Jan 19, 2015 at 7:41 AM, Anil Gupta <[email protected]> wrote: > You mean to have a support for aliases for columns? > If yes, then +1 for that. > > Sent from my iPhone > > On Jan 19, 2015, at 3:49 AM, Bulvik, Noam <[email protected]> wrote: > > Hi, > > > > Do you plan to support assign short name for columns as part of phoenix > features. i.e. when creating table using phoenix DDL there will be a > metadata table that will convert the column name to short names (like a,b,c > … aa,bb….). each time there will be a query the SQL that the user will use > will be converted to the short name to query the db and will be converted > back to the real name in the result set. > > > > This may save a lot of space because the name of a column is part of each > row saved in the files. > > > > Regards, > > Noam > > Information in this e-mail and its attachments is confidential and > privileged under the TEOCO confidentiality terms that can be reviewed here.
