Xcalar column names are immutable today, as my colleague pointed out.
What you can do is create a new column with the desired name, populate it with the contents of the old column, then hide the old column. When exporting that table later, you have the ability to pick the columns to retain. If it is important to trim columns in the Xcalar table, use the Project operator to remove unwanted columns.
How do you create a new named column and populate it with values from an existing column? Assume the column is named "MonthDayYear-split-1" and you want it to say "Month".
- Click on the right corner of the column and choose the Map option
- Select the ifStr function. If the column was an Integer/Float type then choose the if function
- For "condition to test" enter exists($MonthDayYear-spllit-1)
- For "value returned when condition is true" enter $MonthDayYear-spllit-1
- For "value returned when condition is false" enter $MonthDayYear-spllit-1
- For "New Resultant Column Name" enter Month (the desired name)
- Click on Map
Now you can hide the old column by choosing Hide column from the column pulldown menu
You can also project out the unwanted columns if hiding is not good enough:
Double-click on any row in DATA column, usually the last column (with green rows)
Click on the Toggle mode pulldown, next to the Search icon in the top right
Choose Project mode
Select only the columns you want in the table
Click on Submit Projection icon at the top center
What we have done here is use a dummy map function that does not change the data in any way to effectively rename a column.