Hi DEV, I create table according to the below SQL
cc.sql(""" CREATE TABLE IF NOT EXISTS t3 (ID Int, date Timestamp, country String, name String, phonetype String, serialname String, salary Int, name1 String, name2 String, name3 String, name4 String, name5 String, name6 String,name7 String,name8 String ) STORED BY 'carbondata' """) after I load data to this table, I found the dimension columns "name" and "name7" both have no dictionary encode. column "name" has no inverted index but column "name7" has inverted index questions: 1. why by default they have no dictionary decode and some have no inverted index? 2. is there any document to introduce these loading strategies? 3. the dimension column "name" has no inverted index, does its' data still have order in DataChunk2 blocklet? 4. as I know, usually dimension column data is sorted and stored in DataChunk2 blocklet. which cases the dimension column data are not sorted in DataChunk2 blocklet except user specify the column with no inverted index? 5. as I know the first column of mdk key is always sorted in DataChunk2 blocklet, why not set the isExplicitSorted to true?