Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-7070

Virtual column name aliasing

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Normal
    • Resolution: Duplicate
    • Fix Version/s: 2.2.0 beta 1
    • Component/s: None
    • Labels:
      None

      Description

      Hi folks!

      Currently, storage space is saved significantly (in terabytes sometime for static tables!) by shortening column names as it's repeated in each row; however, this short column names can be very unreadable. So far, I've seen 10s of tables with 100s of convoluted names. Hard to debug issues, and work with on day-to-day basis. This can make smart engineers quit project or even company

      Another reason: most of the time, folks are not even aware that column names are repeated, and end up with really descriptive column names. Then, realize waste of disk/ram/network, and spend time on re-implementation and/or crazy migration to new table.

      Yet another reason: table might be shared by multiple system, use cases and people in organization, e.g. primary/analytics use cases, Ops/Developer, etc. Now, it's becoming the issue where we should reliably keep mapping from convoluted names to descriptive names. Usually, these mappings are done in java enums; I've seen in DB as well, just so Ops folks don't have to interpret java code

      It would be great if Cassandra internally could virtually alias the column names to a more efficient representation in storage.

      I can take a shot at this feature if there are no major concerns. We ideally want user to work with descriptive alias everywhere & not even aware of internal storage name of the column. Also, I think name/alias mapping needs to be cached all the time to avoid any performance hit.. Any thoughts? How difficult is it to accommodate? BTW, I think this may not directly apply to dynamic tables as we rely on column name for proper ordering of columns in wide rows. However, we may have some room there if it's not a clustered column..

      Thanks,
      Jay

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                pateljay3001 Jay Patel
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: