Attach filesAttach ScreenshotVotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Not A Problem
    • None
    • 4.10.0
    • None
    • None

    Description

      Schema with 5K columns

      create table (k1 integer, k2 integer, column_1 varchar ... column_5000 varchar CONSTRAINT PK PRIMARY KEY (K1, K2)) 
      VERSIONS=1, MULTI_TENANT=true, IMMUTABLE_ROWS=FALSE
      

      In this mutable schema, only 100 random columns are filled with random 15 chars. Rest are nulls.

      Using a batch size of 1000 with single client/single thread. Time it takes to load data is 5-7X slower compared to standard non-encoded format.

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            samarthjain Samarth Jain
            mujtabachohan Mujtaba Chohan
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment