Articles in this section

How to rename dimension during raw data ingestion

Permanently deleted user
  • Updated
Follow

The following ingestion spec will help renaming dimension during ingestion while keep its values intact. In this case, original column names are `user` and `regionName`, and after ingestion, the column names are changed to `RENAME_User` and "RENAME_RegionName` in dataSource:

{
  "type" : "index",
  "spec" : {
    "dataSchema" : {
      "dataSource" : "wikipedia-rename",
...
          "dimensionsSpec" : {
            "dimensions" : [ "RENAME_User", .... "RENAME_RegionName", ... ]
          }
        }
      },
...
      "transformSpec" : {
        "filter" : null,
        "transforms" : [ {
          "type" : "expression",
          "name" : "RENAME_User",
          "expression" : "(\"user\")"
        }, {
          "type" : "expression",
          "name" : "RENAME_RegionName",
          "expression" : "(\"regionName\")"
        } ]
      }
    }
...
}

Related articles

Comments

2 comments

Sort by Date Votes
  • Jaiswal, Vikram

    Can you please clarify this statement: "In this case, original column names are `user` and `regionName`, and after ingestion, the column names are changed to `RENAME_User` and "RENAME_RegionName` in dataSource" ?

    Isn't column name changed during or before ingesting data into data source ?

    0
    Comment actions Permalink
  • Permanently deleted user

    I think you are right. The column names are changed DURING the ingestion to be precise. Users will see the new column names in the Druid dataSource after the ingestion is done, though. 

    0
    Comment actions Permalink

Please sign in to leave a comment.